Re: awr snapshot failing

From: Taral Desai <taral.desai_at_gmail.com>
Date: Fri, 3 Jun 2011 13:49:32 -0500
Message-ID: <BANLkTi=y2NALXBS=44u0-gH_RV-pRh4pKg_at_mail.gmail.com>

There are couple of bugs on metalink which point to possible corruption.

Please, take help of support. To identify you can try to export SYSAUX tablespace see if you get any error. You can also use DBMS_SPACE_ADMIN to verify for ASSM.

On Thu, Jun 2, 2011 at 5:10 AM, K R <kp0773_at_gmail.com> wrote:

> All ,
>
> any idea what is going in one of my database
>
> SQL> exec dbms_workload_repository.create_snapshot;
> BEGIN dbms_workload_repository.create_snapshot; END;
>
> *
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600:
> internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], [],
> [],
> [], [], []
> ], [], [], [], [], [], [], [], [], []
> ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 99
> ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 122
> ORA-06512: at line 1
>
> appreciate any suggestions
>
> thanks
> Kart
>

-- 
Thanks & Regards,
Taral Desai

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 03 2011 - 13:49:32 CDT