Re: x$kghlu, Steve's shared_pool_lru_stats

  • From: Boris Dali <boris_dali@xxxxxxxx>
  • To: rafiq9857@xxxxxxxxx, Mark.Bobak@xxxxxxxxxxxxxxx, steve.adams@xxxxxxxxxxxx, rjqjunk@xxxxxx
  • Date: Fri, 5 Nov 2004 12:14:33 -0500 (EST)

Thanks for all the replies. Some answers:

sys@bona> sho release
release 902000500

sys@bona>  select owner, object_name, object_type from
dba_objects where object_name = 'DUAL';

OWNER      OBJECT_NAM OBJECT_TYP
---------- ---------- ----------
SYS        DUAL       TABLE
PUBLIC     DUAL       SYNONYM

2 rows selected.

sys@bona> select * from dual;

D
-
X

1 row selected.

sys@bona> select * from sys.x$dual;

ADDR                   INDX    INST_ID D
---------------- ---------- ---------- -
0000000110154DF8          0          1 X

1 row selected.



sys@bona> select * from gv$instance;

   INST_ID INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME 
                                                     
VERSION
---------- --------------- ----------------
----------------------------------------------------------------
----------
STARTUP_T STATUS       PAR    THREAD# ARCHIVE
LOG_SWITCH_ LOGINS     SHU DATABASE_STATUS  
INSTANCE_ROLE      ACTIVE_ST
--------- ------------ --- ---------- -------
----------- ---------- --- -----------------
------------------ ---------
         1               1 xxxx             yyyyyyy   
                                                    
9.2.0.5.0
05-NOV-04 OPEN         NO           1 STARTED         
   ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE  
NORMAL

1 row selected.

DB name and server name in the output above are
replaced with xxxx, yyyyyy.


Thanks to Richard Quintin's pointer to Tanel's earlier
post - _kghdsidx_count happened to be 2 on this DB
(NOT set explicitly). Is that the reason for 2 line
output from x$kghlu?

Thanks,
Boris Dali.


 --- Mohammad Rafiq <rafiq9857@xxxxxxxxx> wrote: 
> 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>

______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca
--
//www.freelists.org/webpage/oracle-l

Other related posts:

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