Re: x$kghlu, Steve's shared_pool_lru_stats

  • From: Mohammad Rafiq <rafiq9857@xxxxxxxxx>
  • To: boris_dali@xxxxxxxx
  • Date: Fri, 5 Nov 2004 10:34:13 -0500

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@xxxxxxxxxxxxxxx> 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@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
>
--
//www.freelists.org/webpage/oracle-l

Other related posts:

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