Re: x$kghlu, Steve's shared_pool_lru

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Fri, 5 Nov 2004 12:14:33 -0500 (EST)
Message-ID: <20041105171433.90891.qmail@web41406.mail.yahoo.com>

Thanks for all the replies. Some answers:

sys_at_bona> sho release
release 902000500

sys_at_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_at_bona> select * from dual;

D
-

X

1 row selected.

sys_at_bona> select * from sys.x$dual;

ADDR                   INDX    INST_ID D


---------------- ---------- ---------- -

0000000110154DF8          0          1 X

1 row selected.

sys_at_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_at_gmail.com> 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_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>

Post your free ad now! http://personals.yahoo.ca
--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 05 2004 - 11:10:29 CST

Re: x$kghlu, Steve's shared_pool_lru_stats