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