/* Formatted on 2010/1/8 18:34:37 (QP5 v5.114.809.3010) */
SELECT NAME,
VALUE,
100
* (VALUE
/ DECODE ( (SELECT SUM (VALUE)
FROM v$sysstat
WHERE NAME LIKE 'workarea executions%'),
0, NULL,
(SELECT SUM (VALUE)
FROM v$sysstat
WHERE NAME LIKE 'workarea executions%')))
pct
FROM v$sysstat
WHERE NAME LIKE 'workarea executions%'
/
SELECT NAME,
VALUE,
100
* (VALUE
/ DECODE ( (SELECT SUM (VALUE)
FROM v$sysstat
WHERE NAME LIKE 'workarea executions%'),
0, NULL,
(SELECT SUM (VALUE)
FROM v$sysstat
WHERE NAME LIKE 'workarea executions%')))
pct
FROM v$sysstat
WHERE NAME LIKE 'workarea executions%'
/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16348200/viewspace-624711/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16348200/viewspace-624711/