Sample Header Ad - 728x90

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