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.

• Steve Adams <steve.adams_at_ixora.com.au> 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_at_freelists.org
  > [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
  > Boris Dali
  > Sent: Friday, 5 November 2004 9:44 AM
  > To: oracle-l_at_freelists.org
  > 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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 05 2004 - 07:16:22 CST