You will need to either be connected as SYS or SYSDBA:
SQL> connect sys/password
Connected.
SQL> desc x$bh
Name Null? Type
----------------------------------------- -------- ----------------
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
BUF# NUMBER
HLADDR RAW(4)
NXT_HASH RAW(4)
PRV_HASH RAW(4)
NXT_REPL RAW(4)
PRV_REPL RAW(4)
FLAG NUMBER
LRU_FLAG NUMBER
TS# NUMBER
FILE# NUMBER
DBARFIL NUMBER
DBABLK NUMBER
CLASS NUMBER
STATE NUMBER
MODE_HELD NUMBER
CHANGES NUMBER
CSTATE NUMBER
X_TO_NULL NUMBER
FORCED_READS NUMBER
FORCED_WRITES NUMBER
LE_ADDR RAW(4)
DIRTY_QUEUE NUMBER
SET_DS RAW(4)
OBJ NUMBER
BA RAW(4)
CR_SCN_BAS NUMBER
CR_SCN_WRP NUMBER
CR_XID_USN NUMBER
CR_XID_SLT NUMBER
CR_XID_SQN NUMBER
CR_UBA_FIL NUMBER
CR_UBA_BLK NUMBER
CR_UBA_SEQ NUMBER
CR_UBA_REC NUMBER
CR_SFL NUMBER
LRBA_SEQ NUMBER
LRBA_BNO NUMBER
HRBA_SEQ NUMBER
HRBA_BNO NUMBER
RRBA_SEQ NUMBER
RRBA_BNO NUMBER
US_NXT RAW(4)
US_PRV RAW(4)
WA_NXT RAW(4)
WA_PRV RAW(4)
TCH NUMBER
TIM NUMBER
SQL> connect mark/password
Connected.
SQL> desc x$bh
ERROR:
ORA-04043: object x$bh does not exist
SQL> desc sys.x$bh
ERROR:
ORA-04043: object sys.x$bh does not exist
SQL> connect mark/password as sysdba
Connected.
SQL> desc sys.x$bh
Name Null? Type
----------------------------------------- -------- ----------------
ADDR RAW(4)
INDX NUMBER
INST_ID NUMBER
BUF# NUMBER
HLADDR RAW(4)
NXT_HASH RAW(4)
PRV_HASH RAW(4)
NXT_REPL RAW(4)
PRV_REPL RAW(4)
FLAG NUMBER
LRU_FLAG NUMBER
TS# NUMBER
FILE# NUMBER
DBARFIL NUMBER
DBABLK NUMBER
CLASS NUMBER
STATE NUMBER
MODE_HELD NUMBER
CHANGES NUMBER
CSTATE NUMBER
X_TO_NULL NUMBER
FORCED_READS NUMBER
FORCED_WRITES NUMBER
LE_ADDR RAW(4)
DIRTY_QUEUE NUMBER
SET_DS RAW(4)
OBJ NUMBER
BA RAW(4)
CR_SCN_BAS NUMBER
CR_SCN_WRP NUMBER
CR_XID_USN NUMBER
CR_XID_SLT NUMBER
CR_XID_SQN NUMBER
CR_UBA_FIL NUMBER
CR_UBA_BLK NUMBER
CR_UBA_SEQ NUMBER
CR_UBA_REC NUMBER
CR_SFL NUMBER
LRBA_SEQ NUMBER
LRBA_BNO NUMBER
HRBA_SEQ NUMBER
HRBA_BNO NUMBER
RRBA_SEQ NUMBER
RRBA_BNO NUMBER
US_NXT RAW(4)
US_PRV RAW(4)
WA_NXT RAW(4)
WA_PRV RAW(4)
TCH NUMBER
TIM NUMBER
SQL>
HTH
Mark
-----Original Message-----
K.Karadeniz
Sent: Wednesday, May 02, 2001 10:06
To: Multiple recipients of list ORACLE-L
I see that there is no X$ tables in my database or I can not view them . My
O.S. is NT .
How can I view them.??
Thanks
Bunyamin K.Karadeniz
Database Group / Information Systems Department
HAVELSAN Ankara /TURKEY
Tel : +903122873565 / 1681
Mobile Tel : +90 535 3357729
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
- X$ tables ?? Bunyamin K.Karadeniz
- RE: X$ tables ?? Suhen Pather
- RE: X$ tables ?? Mark Leith
- Re: X$ tables ?? Brijesh Lal
- Re: X$ tables ?? Mark Leith
- Re: X$ tables ?? Jared Still
