multiple dbid values in dba_hist_sqltext

From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
Date: Tue, 19 Apr 2011 14:42:57 -0400

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

Follow-Ups:
- AW: multiple dbid values in dba_hist_sqltext
  - From: Petr Novak
- Re: multiple dbid values in dba_hist_sqltext
  - From: Leyi Zhang (Kamus)

Other related posts:

» multiple dbid values in dba_hist_sqltext - Jeffrey Beckstrom
» Re: multiple dbid values in dba_hist_sqltext- Leyi Zhang (Kamus)