AW: multiple dbid values in dba_hist_sqltext
- From: Petr Novak <Petr.Novak@xxxxxxxxxxxx>
- To: "JBECKSTROM@xxxxxxxxx" <JBECKSTROM@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>, oracle-db-l <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 20 Apr 2011 06:34:53 +0000
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,
Petr
________________________________________
Von: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx]" im
Auftrag von "Jeffrey Beckstrom [JBECKSTROM@xxxxxxxxx]
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » AW: multiple dbid values in dba_hist_sqltext - Petr Novak
