随笔分类 -  Oracle

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.... 阅读全文
posted @ 2013-12-17 21:07 圣光救赎者 阅读(434) 评论(0) 推荐(0)
MEMORY_TARGET 与 操作系统/dev/shm的大小
摘要：故障：ORA-00845: MEMORY_TARGET not supported on this systemOracle 11g的Linux版本在修改了MEMORY_TARGET或者SGA_TARGET后启动可能会报错：SQL> shutdown immediateDatabase closed... 阅读全文
posted @ 2013-06-11 09:44 圣光救赎者 阅读(876) 评论(0) 推荐(0)