Is it possible to clone calibrate_io results to another database ?
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 ?