Oracle Automatic Degree of Parallelism (Auto DOP)

alter system set PARALLEL_FORCE_LOCAL = TRUE scope=both sid='*';

alter system set PARALLEL_DEGREE_POLICY = AUTO scope=both sid='*';

SET SERVEROUTPUT ON

DECLARE

  lat  INTEGER;

  iops INTEGER;

  mbps INTEGER;

BEGIN

-- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (, , iops, mbps, lat);

   DBMS_RESOURCE_MANAGER.CALIBRATE_IO (1, 10, iops, mbps, lat);

  DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);

  DBMS_OUTPUT.PUT_LINE ('latency  = ' || lat);

  dbms_output.put_line('max_mbps = ' || mbps);

end;

/

select * from V$IO_CALIBRATION_STATUS;

explain plan for select * from dba_tables;

set line 300 pages 3000

select * from table(dbms_xplan.display(null, null, 'advanced'));

To get rid of it:

delete from resource_io_calibrate$;

commit;