如何查询oracle 性能,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