Oracle-L: Re: where is info stored when using the ANALYZE cmd?

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Wed, 28 May 2003 07:34:56 -0800
Message-ID: <F001.005A43E0.20030528073456@fatcity.com>

Answer to question #1: The plan_table owned by system or sys. #2: Try the following: V$BUFFER_POOL, V$LIBRARYCACHE, V$DB_OBJECT_CACHE, V$MYSTAT, V$SESSION_WAIT, V$SESSTAT Good Hunting.

Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)

                                                                                                                            
                    maryann_30_at_yah                                                                                          
                    oo.com               To:     ORACLE-L_at_fatcity.com                                                       
                    Sent by:             cc:                                                                                
                    root_at_fatcity.c       Subject:     where is info stored when using the ANALYZE cmd?                      
                    om                                                                                                      
                                                                                                                            
                                                                                                                            
                    05/28/2003                                                                                              
                    08:15 AM                                                                                                
                    Please respond                                                                                          
                    to ORACLE-L

If I analyze the code using the explain plan, where is info created from this explain plan stored at?
If I added more buffers to the buffer-cache, where should I go check if they made any positive difference?

thx,
maa

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maryann Atkinson
  INET: maryann_30_at_yahoo.com

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).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Reginald.W.Bailey_at_jpmorgan.com

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).

Received on Wed May 28 2003 - 10:34:56 CDT