Re: multiple dbid values in dba_hist_sqltext
- From: "Leyi Zhang (Kamus)" <kamusis@xxxxxxxxx>
- To: JBECKSTROM@xxxxxxxxx
- Date: Wed, 20 Apr 2011 18:49:20 +0800
Try: exec dbms_swrf_internal.unregister_database(db_id);
--
Kamus <kamusis@xxxxxxxxx>
Visit my blog for more : http://www.dbform.com
Join ACOUG: http://www.acoug.org
On Wed, Apr 20, 2011 at 2:42 AM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote:
> 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:
