AWR has multiple DB ID - Need to change the default DBID for awrrpt
Hi, I have used awrextr.sql to unload a customers AWR contents and loaded it into my dev database with awrload.sql. When I run awrrpt.sql I see TWO DB ID's, the original DB ID from the deb database and also the DB ID from the customer AWR data I loaded with awrload. However, the original DBID is defaulted with a '*' and it doesn't prompt me for which DBID I want to run the report for. The next prompt is for listing the number of days of snapshots.
How do I change the DB ID so that when I run awrrpt, I can report from the customer AWR data?
How do I change the DB ID so that when I run awrrpt, I can report from the customer AWR data?
0