multiple dbid values in dba_hist_sqltext
From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 19 Apr 2011 14:42:57 -0400
Message-Id: <4DAD9F710200000B004D30FB_at_groupwise.gcrta.org>
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?
Date: Tue, 19 Apr 2011 14:42:57 -0400
Message-Id: <4DAD9F710200000B004D30FB_at_groupwise.gcrta.org>
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 Tue Apr 19 2011 - 13:42:57 CDT