oracle 11g数据库bug一例

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

在mount状态下，我向查看dba_data_files这个表，

SQL> desc dba_data_files
ERROR:
ORA-04043: object dba_data_files does not exist

alter database open;
SQL> desc dba_data_files
ERROR:
ORA-04043: object dba_data_files does not exist

仍然显示这个对象不存在

shutdown immediate
startup
SQL> desc dba_data_files
Name Null? Type
----------------------------------------- -------- ----------------------------

FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER

重启后显示正常，看来这是个bug啊