Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: x$kghlu, Steve's shared_pool_lru_stats
Hi!
If your shared pool is split to several separate areas protected by separate shared pool child latches, then every shared pool area has its own LRU lists, thus x$kghlu reports a row for each of them.
Multiple shared pool areas feature is available from 9i - _kghdsidx_count parameter controls how many shared pool areas/child latches are used (max is 7).
Also, if java pool is defined, x$kghlu reports one additional row in 10g, maybe in 9i as well, I haven't checked (probably because java pool memory is managed by the same KGH module which handles shared pool).
Tanel.
> Just out of curiousity, no fires - does anyone know
> under what circumstanses it returns more than row for
> a single instance (no RAC) database?
>
> Thanks,
> Boris Dali.
>
> ______________________________________________________________________
> Post your free ad now! http://personals.yahoo.ca
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 05 2004 - 16:04:42 CST
![]() |
![]() |