select * from v$database;
select * from v$instance;实例
select * from v$session; 会话
select * from v$parameter;
select * from v$thread;
select * from dba_data_files ;
select * from dba_tablespaces ;
select * from dba_segments;
select * from dict;
select * from dba_tables;
show parameter processes ;看参数
select * from v$license;
select * from dba_objects;
SELECT * FROM DBA_SYS_PRIVS;看权限
show user 看当前用户
select * from dba_users;
select * from dba_free_space;select * from v$loghist;
select * from v$logfile;
select * from v$log;
select * from v$archive;
select * from v$tempfile;
select * from v$datafile;
select * from v$backup;
select * from v$controlfile;