说明: DATA SEGMENT MESS DB "Triangle",0DH,0AH CN EQU $-MESS MESS1 DB "(0,0)",0AH,0DH,"$" MESS2 DB "(0,100)",0AH,0DH,"$" MESS3 DB "(100,0)",0AH,0DH,"$" FAL DB ? DATA ENDS CODE SEGMENT ASSUME CS:CODE, DS:DATA START:MOV AX,DATA MOV DS,AX MOV AH,0FH INT 10H M <jun1987929> 上传 | 大小:1kb
说明: 监控 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 ratio from v$rollstat a,v$rollname b where a.us <wangqz1027> 上传 | 大小:283kb