| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: X$ tables ??
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: mark_at_cool-tools.co.uk
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: ListGuru_at_fatcity.com (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). Received on Wed May 02 2001 - 13:55:29 CDT
 |
 |