Database Administration (MOSC)

MOSC Banner

Is it possible to clone calibrate_io results to another database ?

edited Feb 8, 2020 4:01AM in Database Administration (MOSC) 3 commentsAnswered

When creating a new db on a server, i run calibrate_io :

SET SERVEROUTPUT ON

DECLARE

  lat  INTEGER;

  iops INTEGER;

  mbps INTEGER;

BEGIN

-- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (<DISKS>, <MAX_LATENCY>, iops, mbps, lat);

  DBMS_RESOURCE_MANAGER.CALIBRATE_IO (4, 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;

/

max_iops = 181391

latency  = 0

max_mbps = 2851

Doing this for every new db is silly - it takes time and the impact on my SAN/other db's is high.

Is there a way I can migrate (exp/impdp?) the results to a new db ?

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