p141.sql

来自「oracal的入门知识」· SQL 代码 · 共 14 行

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%'
/