找不到视图

Question

Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 
Connected as amlu
 
SQL> desc v$bh
Name               Type         Nullable Default Comments 
------------------ ------------ -------- ------- -------- 
FILE#              NUMBER       Y                         
BLOCK#             NUMBER       Y                         
CLASS#             NUMBER       Y                         
STATUS             VARCHAR2(10) Y                         
XNC                NUMBER       Y                         
FORCED_READS       NUMBER       Y                         
FORCED_WRITES      NUMBER       Y                         
LOCK_ELEMENT_ADDR  RAW(4)       Y                         
LOCK_ELEMENT_NAME  NUMBER       Y                         
LOCK_ELEMENT_CLASS NUMBER       Y                         
DIRTY              VARCHAR2(1)  Y                         
TEMP               VARCHAR2(1)  Y                         
PING               VARCHAR2(1)  Y                         
STALE              VARCHAR2(1)  Y                         
DIRECT             VARCHAR2(1)  Y                         
NEW                CHAR(1)      Y                         
OBJD               NUMBER       Y                         
TS#                NUMBER       Y                         
 
SQL> desc x$bh
Object x$bh does not exist.

Answer 1

SQL> desc v$bh
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ------------------
 FILE#                                              NUMBER
 BLOCK#                                             NUMBER
 ...
SQL> desc x$bh
ERROR:
ORA-04043: 对象 x$bh 不存在
SQL> desc sys.x$bh
ERROR:
ORA-04043: 对象 sys.x$bh 不存在
SQL> conn / as sysdba
已连接。
SQL> desc sys.x$bh
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ------------------
 ADDR                                               RAW(4)
 INDX                                               NUMBER
 INST_ID                                            NUMBER
 ...                                    NUMBERSQL> desc x$bh
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ------------------
 ADDR                                               RAW(4)
 INDX                                               NUMBER
 ...