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 := 'cpuspeed';
9 DBMS_STATS.GET_SYSTEM_STATS(status, dstart, dstop, pname, pvalue);
10 DBMS_OUTPUT.PUT_LINE('status : '||status);
11 DBMS_OUTPUT.PUT_LINE('cpu in mhz : '||pvalue);
12
13 END;
14 /
status : MANUALGATHERING
cpu in mhz :
PL/SQL procedure successfully completed.