oracle中几个有特殊意义的表

-----------------------------------------------------------------------------------------------------------------

select * from V$SQL;

select * from V$SQLAREA;

select * from V$ACCESS;

select * from V$SESSION;

select * from V$PROCESS;

 

select * from DBA_DATA_FILES;

select * from DBA_INDEXES;

select * from DBA_TABLES;

select * from DBA_INDEXES;

select * from DBA_TABLESPACES;

select * from DBA_TABLESPACE_USAGE_METRICS;

select * from DBA_TAB_COMMENTS;

select * from DBA_COL_COMMENTS;

 

 

索引表不断增大两种解决方案：

 

1：truncate数据表

2：重建索引。

 

rollup，asm，rac，sprofile.ora，审计，全局索引