- 博客(3)
- 资源 (10)
- 收藏
- 关注
转载 Oracle常用监控SQL
1.监控事例的等待:select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) curr,count(*) from v$session_wait group by event order by 4;2.回滚段的争用情况:select name,waits,gets,waits/gets
2012-06-18 16:55:59 697
转载 ORA-00600错误及其解决方案
ORA-00600错误及其解决方案错误描述:数据库版本:SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
2012-06-12 15:31:22 4527 1
转载 Oracle 查看 对象 持有 锁 的情况
有关Oracle 锁的说明,参考:ORACLE锁机制http://blog.csdn.net/tianlesoftware/article/details/4696896用如下SQL 查看一下系统中相关对象上锁的情况:[sql] view plaincopyprint?name="code" class="sql">/* Formattedo
2012-06-08 11:09:10 762
TMS.Component.Pack.v4.4.Full.Source.D5-11.C5-11.ccrun.599528.rar
2007-07-31
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人