Re: Source of expensive SQL

Ah, I was looking into only *.sql files in rdbms/admin directory, forgot about the *.bsq's :)
catalog.sql had other flag bits defined, but not these two...

Thanks Wolfgang,
Tanel.

• Original Message ----- From: "Wolfgang Breitling" To: Cc: "ORACLE-L" Sent: Friday, January 06, 2006 12:01 PM Subject: Re: Source of expensive SQL

> Not sure if it helps, but wouldn't "bitand(i.flags, 256)" and
> "bitand(i.flags, 512)" be the same as 0x100 and 0x200 below
> (from sql.bsq):
>
> flags number not null,
> /* mutable flags: anything permanent should go into property */
> /* unusable (dls) : 0x01 */
> /* analyzed : 0x02 */

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l