Introduction
19c brings with it a host of new features for multi-tenant. Below are some of the highlights
- A PDB recovery catalog
- The ability to control Datapump Resources
- Enhancements to Real Application Testing (RAT)
- DBCA Enhancements when running in silent mode.
- ADDM for pluggable databases
PDB Recovery Catalog
You can connect to an RMAN catalog now even when the target database is a pluggable database. The virtual private catalog command introduced in 11g, can be used to manage permissions for backups of the PDB.
Controlling Datapump Resources
In 12c we had a new parameter called MAX_DATAPUMP_JOBS_PER_PDB. It had a bizarrely wide set of values (0 to 2147483647). This has now been updated to something more reasonable. (0 to 250). It also has a parameter value of AUTO, which if set, defaults the parameter to 50% of the SESSIONS init.ora parameter.
In addition, to the changes above, there is a new parameter called MAX_DATAPUMP_PARALLEL_PER_JOB. This controls the number of parallel processes per datapump job in any given PDB. The values range from 1 to 1024. There is also an AUTO setting which defaults the parameter to 50% of the SESSIONS init.ora
Real Application Testing
In past versions Real Application testing (RAT) captured workloads from the container. With 19c, you can capture workloads from any PDB. This provides flexibility in managing your testing cycles.
DBCA Enhancements
The ability to relocate or duplicate a PDB has been around for a while, but you can now do this in silent mode in DBCA using the dbca -relocatePDB or dbca -source PDB name_of_the_pdb_to_clone
ADDM
ADDM has been enabled by default on the root container for a while, but it can now be enabled on the PDBs. The following methods can be used to access information about ADDM anlysis
- OEM
- DBA_ADDM_* views
- DBA_ADVISOR_* views
Published 13th March 2023
