Re: skip scan index

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: mgogala_at_adelphia.net

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: ListGuru_at_fatcity.com (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).