|
SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 STATUS VARCHAR2(20);
3 DSTART DATE;
4 DSTOP DATE;
5 PVALUE NUMBER;
6 PNAME VARCHAR2(30);
7 BEGIN
8 PNAME := 'sreadtim';
9 DBMS_STATS.GET_SYSTEM_STATS(status, dstart, dstop, pname, pvalue);
10 DBMS_OUTPUT.PUT_LINE('single block readtime in ms : '||pvalue);
11 END;
12 /
single block readtime in ms :
PL/SQL procedure successfully completed.
SQL>
|