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_at_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_at_bona> select count(1) from x$kghlu;
>=20
> COUNT(1)
> ----------
> 2
<more trimming>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 05 2004 - 08:52:53 CST
