multiblock readtime in ms : dbms_stats « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. dbms_stats

multiblock readtime in ms

    

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 := 'mreadtim';
  9   DBMS_STATS.GET_SYSTEM_STATS(status, dstart, dstop, pname, pvalue);
 10   DBMS_OUTPUT.PUT_LINE('multiblock readtime in ms   : '||pvalue);
 11  END;
 12  /
multiblock readtime in ms   :

PL/SQL procedure successfully completed.

SQL>

   
    
    
    
  

Related examples in the same category