p252.sql

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

CREATE OR REPLACE VIEW redo_size
AS
   SELECT VALUE
     FROM v$mystat, v$statname
    WHERE v$mystat.statistic# = v$statname.statistic#
      AND v$statname.NAME = 'redo size'
/