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:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2004