Database Administration (MOSC)

MOSC Banner

multitenant update awr retention in mutitenant 19c

2 node RAC 19c database for EBS 12.2.3 on Linux

I am having trouble knowing what to source and log in a multitenant architecture to do mainteance on the db.

I would like to update the retention period on awr reports.

I can do this in a non multitenant database.

  1. find the dbid ( select dbid from v$database)
  2. find all the dbid's in the db : select dbid from dba_hist_wr_control;
  3. delete all but the dbid in v$database
  4. select 'exec dbms_swrf_internal.unregister_database('||dbid||');' from dba_hist_wr_control;
  5. update the retention period for awr:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center