数据库手册：Oracle维护常用SQL语句
性能相关内容 1、捕捉运行很久的SQL column username format a12 column opname format a16 column progress
进程相关： 1、 求当前会话的SID，SERIAL# SELECT Sid, Serial# FROM V$session WHERE Audsid = Sys_Context
1、查看表空间的名称及大小 select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size from dba
1、查看表空间的名称及大小 select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size from dba
14、回滚段查看 select rownum, sys.dba_rollback_segs.segment_name Name, v$rollstat.extents Exte
1、查看表空间的名称及大小 select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size from dba_table
14、回滚段查看 select rownum, sys.dba_rollback_segs.segment_name Name, v$rollstat.extents Extents, v
1、查看表空间的名称及大小 select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size from dba
代码: select sql_text ,sharable_mem from v$sql where sharable_mem '100000' order by sharable_mem
代码: select sql_text ,sharable_mem from v$sql where sharable_mem '100000' order by sharable_mem