multiple dbid values in dba_hist_sqltext

From: Jeffrey Beckstrom <>
Date: Tue, 19 Apr 2011 14:42:57 -0400
Message-Id: <>

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 Tue Apr 19 2011 - 13:42:57 CDT

Original text of this message