-
编辑 删除
监控数据库性能的SQL汇总
监控数据库性能的SQL汇总 1. 监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot" from v$session_Wait group by event order by 4; 2. 回滚段的争用情况 select name, waits, gets, waits/gets "Ratio" from v$rollstat a, v$rollname b where a.usn = b.usn; [@more@]监控数据库性能的SQL汇总 1. 监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr&qu
-
编辑 删除
oracle dba 常用sql
***********************************************************************************************1.查询系统中不能自动扩展(即无足够空间)的对象select a.owner||'.'||a.segment_name, a.segment_type , a.bytes/1024/1024 , a.next_extent/1024/1024 , a.tablespace_name from sys.dba_segments a where a. next_extent * 3 > ( select max(b.bytes) from dba_free_space b
