ora常用系统表

--查询表
select * from all_all_tables;
--查询表中的列
select * from all_tab_columns t where t.TABLE_NAME='xxx';
--查询表级注释
select * from all_tab_comments t where t.TABLE_NAME='xxx';
--查询列级注释
select * from all_col_comments t where t.TABLE_NAME='xxx';
--查询视图
select * from all_views;
--查询数据库对象 
/*object_type的类型有
JOB CLASS
INDEX
DESTINATION
INDEXTYPE
PROCEDURE
JAVA CLASS
SCHEDULE
WINDOW
JAVA RESOURCE
TABLE PARTITION
TABLE
VIEW
TYPE
FUNCTION
PROGRAM
SYNONYM
CONSUMER GROUP
SCHEDULER GROUP
EVALUATION CONTEXT
PACKAGE BODY
EDITION
OPERATOR
SEQUENCE
PACKAGE
INDEX PARTITION
LOB*/
select distinct t.object_type from all_objects t where t.object_type='TABLE';


--查看执行计划                
SELECT sp.id,
       lpad(' ', sp.DEPTH * 3, ' ') || sp.OPERATION || ' ' || sp.OPTIONS operation,
       sp.OBJECT_NAME 
  FROM V$SQL_PLAN sp
 WHERE SQL_ID = 'cdxrwq26uh037'
 ORDER BY ID;
 
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR('cdxrwq26uh037'));
--查看trace
Set autotrace trace exp stat;
Delete from t where t.object_id<10000;--[t -->dba_objects]
--查看表占用空间大小
Select count(*)  from user_extents where segment_name='表名';
--表中数据重新分布
Alte table t move；
--查看实例
select * from gv$instance


--查询系统用户
select * from all_users;