AW: multiple dbid values in dba_hist_sqltext

From: Petr Novak <>
Date: Wed, 20 Apr 2011 06:34:53 +0000
Message-ID: <>

Hallo Jeffrey,

you can check content (dbid,instance) of you AWR repository in dba_hist_database_instance, baselines in dba_hist_baseline. In dbms_xplan.display_awr you can also specify the parameter dbid, because you can export the AWR data with awrextr.sql and import them with awrload.sql into central repository. You can clean up the repository with dbms_workload_repository.drop_baseline or dbms_workload_repository.drop_snapshot_range.

Best Regards,

Von: []&quot; im Auftrag von &quot;Jeffrey Beckstrom [] Gesendet: Dienstag, 19. April 2011 20:42 Bis: oracle-l-freelists; oracle-db-l
Betreff: multiple dbid values in dba_hist_sqltext

dbms_xplan.display_awr is giving me an ora-1422. I believe this is due to records in sys.dba_hist_sqltext with multiple dbid's. I presume the "extra" dbids are from cloning of the database. How can I clean up this table?

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

Received on Wed Apr 20 2011 - 01:34:53 CDT

Original text of this message