Invoking DBMS_RESOURCE_MANAGER.CALIBRATE_IO in a PDB failing
0
votes
0
answers
49
views
We have migrated a standalone Oracle database into an Oracle 21 multitenant database. We had run the DBMS_RESOURCE_MANAGER.CALIBRATE_IO package procedure in the source database prior to migrating the database into a new PDB.
When we had a massive query that uses parallel processing on the destination server run a long time, I tried to invoke DBMS_RESOURCE_MANAGER.CALIBRATE_IO in the PDB, and got the error
ORA-65040: operation not allowed from within a pluggable database
Which is verified in the doco. So I ran it in the CDB, worked fine. I queried the table DBA_RSRC_IO_CALIBRATE in the CDB, and got good results. When I connected to the PDB and queried that table, I got back the values that were set in the *source* database; not the values I set in the CDB.
How do I get the data in the CDB to be applied in the PDB?
Asked by Mark Stewart
(1168 rep)
Jan 13, 2025, 10:10 PM