学习笔记——DataDictionary

所有数据字典表：
          select a.table_name, type, table_num, comments from dictionary a ,v$fixed_table b where a.table_name=b.name;
数据字典表中列的具体含义：
          select * from dict_columns where table_name=&TABLENAME;
aud$    -- 审计相关
$ORACLE_HOME/rdbms/admin/sql.bsq                   -- 基表
$ORACLE_HOM/rdbms/admin/catalog.sql               -- 数据字典视图，静态视图只有analyze,dbms_stats时才会被更新
静态视图           user_*                   all_*                      dba_*                  user_catalog      cat
动态性能视图    v$*
常用：
select dbid, name, created, log_mode, open_mode from v$database;
select host_name, instance_name, version from v$instance;
v$controlfile     v$log         v$logfile
select tablespace_name,  block_size, status, contents, logging from dba_tablespaces;
select file_id, file_name, tablespace_name, status, bytes/1024/1024 "file_size(M)" from dba_data_files;
select user_id, username, created from dba_users;
v$archive;
v$archived_log;
v$backup;
v$database;
v$datafile;
v$log;
v$logfile;
v$loghist;
v$tablespace;

v$tempfile;

-- The End --