Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: x$kghlu, Steve's shared_pool_lru_stats

RE: x$kghlu, Steve's shared_pool_lru_stats

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Fri, 5 Nov 2004 08:20:33 -0500 (EST)
Message-ID: <20041105132033.46990.qmail@web41405.mail.yahoo.com>


Hi Steve,

Thanks for the reply. Here's an output from one of the DBs here (first time I see this and hence the question):

sys_at_bona> @shared_pool_lru_stats

 RECURRENT TRANSIENT FLUSHED PINS AND ORA-4031 LAST ERROR

    CHUNKS     CHUNKS     CHUNKS   RELEASES     ERRORS
      SIZE

---------- ---------- ---------- ---------- ----------
      3871      11666          0    2387736          0
         0
      8010      31546          0   16910987          0
         0

sys_at_bona> select count(1) from x$kghlu;

  COUNT(1)


         2

Thanks,
Boris Dali.


Post your free ad now! http://personals.yahoo.ca
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 05 2004 - 07:16:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US