oracle 常用性能查询SQL分享

select count(1) from dictionary;
select * from dba_data_files;
select count(1) from dba_objects t where t.owner='BESTTONE';
select * from dba_tablespaces t where t.tablespace_name='BESTTONE';
select count(1) from dba_tables t where t.owner='BESTTONE';
select t.table_name,t.comments from dictionary  t where t.table_name like 'V$%';
select * from dba_constraints;
select * from dba_cons_columns;
select * from dba_tablespaces t where t.tablespace_name='SIM002';
CREATE TABLESPACE SS DATAFILE 'D:\ORACLE\ORADATA\BSTO\SS.DBF' SIZE 1M;
SELECT T.tablespace_name, T.status from DBA_TABLESPACES T;
SELECT T.TABLESPACE_NAME,T.FILE_NAME from DBA_DATA_FILES T;
ALTER TABLESPACE SIM002 OFFLINE;
ALTER TABLESPACE SIM002 ONLINE;
SELECT T.os_username,
       T.username,
       T.terminal,
       DECODE(T.returncode,
              '0',
              'Connected',
              '1005',
              'failedNull',
              '1017',
              'failed'),
       to_char(t.timestamp, 'dd-mon-yy hh24:mi:ss'),
       to_char(t.logoff_time, 'dd-mon-yy hh24:mi:ss')
  from DBA_AUDIT_SESSION T;--尝试登陆审计
select t.action,t.name  from audit_actions t;
select * from dba_audit_object;
select * from v$sesstat;
select a.sid,a.value "total cpu time" from v$sesstat a ,v$statname b
where a.STATISTIC#=b.STATISTIC# and b.NAME='cpu used by this session'
order by a.sid;--会话级服务时间值
select sum(time_waited) &quo