--查看用户空间
SELECTUSER_USED_SPACE('SYSDBA');--查看系统信息
SELECT * FROM V$INSTANCE;--查看存储信息
SELECT * FROM V$TABLESPACE;--查看内存管理信息
SELECT NAME,N_PAGES,N_LOGIC_READS,RAT_HIT FROM V$BUFFERPOOL;--查看事务信息
SELECT TRX_ID,LTYPE,LMODE,TABLE_ID FROM V$LOCK;--查看线程信息
SELECT * FROM V$threads;--查看历史模块
SELECT SESS_ID,TOP_SQL_TEXT,TIME_USED FROM V$SQL_HISTORY;--查看缓存信息
SELECT * FROM V$DICT_CACHE;--查看会话信息
SELECT SESS_ID,SQL_TEXT,STATE,CREATE_TIME,CLNT_HOST FROM V$SESSIONS;--查看捕获信息
SELECT * FROM V$CAPTURE;--开启统计信息
DBMS_STATS.GATHER_TABLE_STATS('DMHR','DZCGZLDJB_T' ,NULL,100, TRUE, 'FOR ALL COLUMNS SIZE AUTO');
DBMS_STATS.TABLE_STATS_SHOW('DMHR','DZCGZLDJB_T');--确定高负载的 SQL
SELECT * FROM V$LONG_EXEC_SQLS;
SELECT * FROM V$SYSTEM_LONG_EXEC_SQLS;--执行计划说明
select*from V$SQL_NODE_NAME;--设置自动提交事务
SET AUTOCOMMIT ON;
--查看用户空间SELECT USER_USED_SPACE('SYSDBA');--查看系统信息SELECT * FROM V$INSTANCE;--查看存储信息SELECT * FROM V$TABLESPACE;--查看内存管理信息SELECT NAME,N_PAGES,N_LOGIC_READS,RAT_HIT FROM V$BUFFERPOOL;--查看事务信息SELECT TRX_ID,LTYPE,LMODE,TABLE_ID FROM V$LOCK;--查看线.