RE: x$kghlu, Steve's shared_pool_lru_stats
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <boris_dali@xxxxxxxx>, "Steve Adams" <steve.adams@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Nov 2004 09:54:54 -0500
Just out of curiosity, what does:
select * from gv$instance;
output?
-Mark
<Stuff deleted>
> Thanks for the reply. Here's an output from one of the
> DBs here (first time I see this and hence the
> question):
>=20
> sys@bona> @shared_pool_lru_stats
>=20
> 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;
>=20
> COUNT(1)
> ----------
> 2
<more trimming>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: x$kghlu, Steve's shared_pool_lru_stats
- » x$kghlu, Steve's shared_pool_lru_stats
- » RE: x$kghlu, Steve's shared_pool_lru_stats
- » RE: x$kghlu, Steve's shared_pool_lru_stats
- » RE: x$kghlu, Steve's shared_pool_lru_stats
- » Re: x$kghlu, Steve's shared_pool_lru_stats
- » Re: x$kghlu, Steve's shared_pool_lru_stats
- » Re: x$kghlu, Steve's shared_pool_lru_stats
- » Re: x$kghlu, Steve's shared_pool_lru_stats
- » RE: x$kghlu, Steve's shared_pool_lru_stats
- » Re: x$kghlu, Steve's shared_pool_lru_stats