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" <breitliw@xxxxxxxxxxxxx>
To: <tanel.poder.003@xxxxxxx>
Cc: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
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


Other related posts: