ITPub博客

<p>这个步骤比较简单，查询v$sort_usage就可以了：</p><div class="dp-highlighter"><div class="bar"><div class="tools"><a href="http://www.laoxiong.net/temporary_tablespace_excessive_usage_case.html#">view plain</a><a href="http://www.laoxiong.net/temporary_tablespace_excessive_usage_case.h...

select a.sid,b.SERIAL# from v$access a,V$SESSION b where a.OBJECT='包名'   and a.sid=b.sid;

查看回收站是否开启:<br />SELECT Value FROM V$parameter WHERE Name = 'recyclebin'; <br />查看回收站中的数据：<br />SELECT * FROM DBA_RECYCLEBIN t where t.original_name = 'T_TEST'

sqlplus "/as sysdba"<br />@$ORACLE_HOME\RDBMS\ADMIN\utlrp.sql; this script will compile all invalid objects in database

<p style="margin-left:148.85pt;text-indent:-21.25pt;"><span>spool droptable.sql</span></p><p style="margin-left:148.85pt;text-indent:-21.25pt;"><span>&nbsp;</span></p><p style="margin-left:148.85pt;text-indent:-21.25pt;"><span>SELECT 'DROP TABLE '|| table_name || ';' FROMUSER_TABLES ORDER...

$ more check.sql<br />set head off<br />set pagesize 2000<br />spool comp.sql<br />select 'alter '||decode(object_type, 'VIEW', 'VIEW','TRIGGER','TRIGGER',<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'PROCEDURE', 'PROCEDURE', 'FOUNCTION','FUNCTION',<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'PAC...

<span style="font-size:16px;">判断回滚段竞争的SQL语句：（当Ratio大于2时存在回滚段竞争，需要增加更多的回滚段）<br />select rn.name, rs.GETS, rs.WAITS, (rs.WAITS / rs.GETS) * 100 ratio<br />from v$rollstat rs, v$rollname rn<br />where rs.USN = rn.usn<br /><br />判断恢复日志竞争的SQL语句：（immedi...

select rowid,user_id from sshr.xx_user where user_id=3010586select rowid,       dbms_rowid.rowid_object(rowid) object_id,              dbms_rowid.rowid_relative_fno(rowid) fil...

表空间碎片相关：select tablespace_name,       round(sqrt(max(blocks) / sum(blocks)) *             (100 / sqrt(sqrt(count(blocks)))),        &n...