From mark@cool-tools.co.uk Wed, 02 May 2001 08:45:42 -0700 From: "Mark Leith" Date: Wed, 02 May 2001 08:45:42 -0700 Subject: RE: X$ tables ?? Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Bunyamin K.Karadeniz Sent: Wednesday, May 02, 2001 10:06 To: Multiple recipients of list ORACLE-L Subject: X$ tables ??    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