Multitenant - Automatic Workload Repository

Click on the link below for a tutorial on Oracle Database 18c Multitenant Architecture - Automatic Workload Repository (AWR). This link points to  a YouTube video.

Oracle Database 18c Multitenant Architecture - Automatic Workload Repository

Demo AWR

Example

CREATE_SNAPSHOT Function and Procedure

EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT('ALL');

show con_id

select con_id, 

dbid, 

snap_id, 

instance_number, 

begin_interval_time, 

end_interval_time 

from dba_hist_snapshot where con_id=3;

EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE (start_snap_id => 1, end_snap_id => 3, baseline_name =>'pdb1_peakload_1');

select con_id, dbid, baseline_id, baseline_name, start_snap_id, end_snap_id from DBA_HIST_BASELINE where con_id=3;

@?/rdbms/admin/ashrpt.sql

Similarly, for AWR report, run the awrrpt.sql script.

@?/rdbms/admin/awrrpt.sql