On 2003.05.28 23:04 Wolfgang Breitling wrote: > I was about to post the results of my test which also did prove you wrong. > I ran the test with a 10046 level 8 trace to show the individual index > block reads which nicely show why it is called a skip scan, but since you > already proved yourself wrong there is no need.
Thanks, Wolfgang! If there is one thing I really excel at, that is proving myself wrong. I succeeded again. > > BTW, as of Oracle 9 you don't necessarily need to restart the database to > reset the pools. This should do the trick: > > ALTER SESSION SET EVENTS 'immediate trace name flush_cache'; > alter system flush shared_pool; Thanks! How did you come accross this little gem? > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).