SQL Performance (MOSC)

MOSC Banner

11gR2: PARALLELISM AUTO DOP / CALIBRATE IO / num_physical_disks and max_latency ?

edited Jun 12, 2018 3:23PM in SQL Performance (MOSC) 4 commentsAnswered
Hi,I want to use AUTO DOP (Degree Of Parallelism) for the first time in database 11.2.3.0 to optimize queries such as :MERGE INTO PRODUCTS P USING (SELECT /*+ PARALLEL */              FROM (SELECT /*+ PARALLEL */           WHERE DMP.no_partition = 894ON (P.col1 = D.col2)WHEN MATCHED THEN  UPDATE ALTER SYSTEM SET parallel_degree_policy=LIMITED; ALTER SESSION SET PARALLEL_DEGREE_LIMIT= 4 ; -- To have degree cappedBut I have also to execute DBMS_RESOURCE_MANAGER.CALIBRATE_IO to populate IO statistics.select * from v$io_calibration_status; no rows selected ; DBMS_RESOURCE_MANAGER.CALIBRATE_IO ( num_physical_disks IN PLS_INTEGER DEFAULT 1,max_latency IN PLS_INTEGER DEFAULT 20,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center