| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Allows a Pluggable database to modify all DBA_HIST views to obtain its data from a different source. |
| AUTHID |
CURRENT_USER |
| Dependencies |
| ALL_OBJECTS |
DBMS_STANDARD |
PLITBLM |
| DBMS_ASSERT |
DBMS_SWRF_LIB |
|
|
| Documented |
No |
| First Available |
12.2 |
| Security Model |
Owned by SYS with EXECUTE granted to the DBA role |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsmb.sql |
| Subprograms |
|
| |
| CLEANUP_DB_REPLAY_OBJECTS |
| Drops DB Replay objects that should help with future backports, specifically patch apply and rollback |
dbms_management_bootstrap.cleanup_db_replay_objects; |
exec dbms_management_bootstrap.cleanup_db_replay_objects;
PL/SQL procedure successfully completed. |
| |
| MODIFY_AWR_VIEW_SETTINGS |
| Allows a Pluggable database to modify all DBA_HIST views to obtain its data from a different source |
dbms_management_bootstrap.modify_awr_view_settings(
view_location IN VARCHAR2 DEFAULT 'AWR_ROOT',
recomp_objs IN BOOLEAN DEFAULT TRUE); |
exec dbms_management_bootstrap.modify_awr_view_settings(recomp_objs=>FALSE);
PL/SQL procedure successfully completed. |
| |
RECREATE_AWR_PARTITIONS (new 23ai)  |
| Used to reduce the total number of partitions created for tables in AWR, using the active partition policy (retention, interval, etc) |
dbms_management_bootstrap(
dbid NUMBER,
table_name VARCHAR2 DEFAULT NULL,
timeout NUMBER DEFAULT NULL); |
| TBD |