- 博客(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关注的人