Re: x$kghlu, Steve's shared_pool_lru_stats

How many dual tables you have on your database and number of counts for rows on those tables. It appears you may have more then one dual tables or your dual table have 2 rows?

Although new versions of Oracle does not allow for dual to have more than 1 rows but it happened till ver 7.3.4 and results were that 2 rows were returned from dictionary tables/views. If you have 2 rows then one row must be deleted to get correct results.

Regards
Rafiq

On Fri, 5 Nov 2004 09:54:54 -0500, Bobak, Mark <mark.bobak_at_il.proquest.com> wrote:
> 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
>

--
http://www.freelists.org/webpage/oracle-l