Oracle 数据字典学习

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';