Re: Source of expensive SQL

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: <breitliw@xxxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 6 Jan 2006 12:16:05 -0600

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 */


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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006