Database Tuning (MOSC)

MOSC Banner

AWR has multiple DB ID - Need to change the default DBID for awrrpt

edited Feb 24, 2010 5:24AM in Database Tuning (MOSC) 6 commentsAnswered ✓
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?

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