Oracle 資料字典學習

Oracle資料字典對於Oracle來說，是個非常重要的組成部分。學習Oracle的資料字典，對於資料庫的管理具有重要的意義。下邊是我我從書上學到的追蹤Oracle視圖的方法，放在這裡，做個印記！

一、靜態視圖：
select * from dict where table_name like '%SYNONYM%';
select * from DBA_SYNONYMS where table_name='DBA_TABLES';
select * from dba_objects where object_name='DBA_TABLES';
select * from dba_views where view_name='DBA_TABLES';

二、動態視圖：
select * from DBA_SYNONYMS where SYNONYM_name='V$SESSION';
select * from dba_objects where object_name='V_$SESSION';
select * from dba_views where view_name='V_$SESSION';
select * from v$fixed_view_definition where view_name='V$SESSION';
select * from v$fixed_view_definition where view_name='GV$SESSION';
select * from v$fixed_table where name='X$KSUSE';