Re: multiple dbid values in dba_hist_sqltext
From: Leyi Zhang (Kamus) <"Leyi>
Date: Wed, 20 Apr 2011 18:49:20 +0800
Message-ID: <BANLkTikkpA_o8mpYf3xezCgnJSmYF1Z0fg_at_mail.gmail.com>
Try: exec dbms_swrf_internal.unregister_database(db_id);
Date: Wed, 20 Apr 2011 18:49:20 +0800
Message-ID: <BANLkTikkpA_o8mpYf3xezCgnJSmYF1Z0fg_at_mail.gmail.com>
Try: exec dbms_swrf_internal.unregister_database(db_id);
-- Kamus <kamusis_at_gmail.com> 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_at_gcrta.org> wrote:Received on Wed Apr 20 2011 - 05:49:20 CDT
> 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-l