Re: awr snapshot failing

  • From: Taral Desai <taral.desai@xxxxxxxxx>
  • To: kp0773@xxxxxxxxx
  • Date: Fri, 3 Jun 2011 13:49:32 -0500

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@xxxxxxxxx> 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

Other related posts: