AW: multiple dbid values in dba_hist_sqltext
Date: Wed, 20 Apr 2011 06:34:53 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B64070238224D_at_SMXC001.trivadis.com>
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_at_freelists.org [oracle-l-bounce_at_freelists.org]" im Auftrag von "Jeffrey Beckstrom [JBECKSTROM_at_gcrta.org] 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 20 2011 - 01:34:53 CDT