RE: x$kghlu, Steve's shared_pool_lru_stats

  • From: Boris Dali <boris_dali@xxxxxxxx>
  • To: Steve Adams <steve.adams@xxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 5 Nov 2004 08:20:33 -0500 (EST)

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@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@bona> select count(1) from x$kghlu;

  COUNT(1)
----------
         2

Thanks,
Boris Dali.

 --- Steve Adams <steve.adams@xxxxxxxxxxxx> wrote: 
> Hi Boris,
> 
> Never, I hope!
> 
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/         - For DBAs
> @   http://www.christianity.net.au/  - For all 
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Boris Dali
> Sent: Friday, 5 November 2004 9:44 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: x$kghlu, Steve's shared_pool_lru_stats
> 
> 
> Just out of curiousity, no fires - does anyone know
> under what circumstanses it returns more than row
> for
> a single instance (no RAC) database?
> 
>  

______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2004