Oracle | DBMS_MANAGEMENT

Oracle DBMS_MANAGEMENT_BOOTSTRAP Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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	DBMS_SYS_ERROR
DBMS_ASSERT	DBMS_SWRF_LIB	PLITBLM

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

MODIFY_AWR_VIEW_SETTINGS

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.