Diff report from an imported AWR

Toad for Oracle
1

Hello All,

I am trying to generate a diff report that i imported from another instance.

I am able to force an ugly html by coping an output from the package

set lines 600
set pages 10000
Select *
from table(dbms_workload_repository.awr_diff_report_html(
3565825942,
1,
18640,
18642,
45058048,
1,
4889,
4891));

when trying to use the tool in Toad you can only edit the query in the Starting Snapshot, and have to remove WHERE dbid = :dbid, AND instance_number = 1to display the other snapshots. Also if in a PDB you have to change CDB_HIST_SNAPSHOT to DBA_HIST_SNAPSHOT .
You also cant change the instance.
Am i missing a setting somewhere to allow for this compare?

Thanks
Dave

2

Hi Dave,

If you select the DBID that you want up here, then CDB_HIST_SNAPSHOT should have what you are looking for.

image
image728×470 24.5 KB

If you are trying to compare snapshots from one DBID to another, it looks like the GUI doesn't allow that. I can add an enhancement request for it if that's what you're after.

-John

3

Hey John,

Yes that is what Im looking for.
I did figure out a workaround but it did require moving the PDB awr into the standalone.
There seems to be a bug on oracle going from standalone to pdb but still testing with cmd line.

Thanks
Dave