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?

Does DBMS_RESOURCE_MANAGER have limit io bandwidth? I want reporting group to be limited to some mbps. During peak hours our database disks are 100% loaded, because reporting groups are selecting many rows. I want somehow to limit io resource without canceling their selects.