每到月底,机器的负荷都比较大,现在又产生这个 ora-600error ,操作都很慢

请各位老大帮忙看看,这个错误怎么解决!

SQL> conn /as sysdba

Connected.

SQL> select * from dba_ddl_locks;

select * from dba_ddl_locks

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [17059], [0x70000008732E238], [],

[], [], [], [], []

alert:

Wed Nov 28 20:11:28 2007

Errors in file /oracle/ora9/admin/ctmesp1/udump/ctmesp1_ora_811092.trc:

ORA-00600: internal error code, arguments: [17059], [0x7000000AFD391D0], [], [], [], [], [], []

Wed Nov 28 20:57:39 2007

Errors in file /oracle/ora9/admin/ctmesp1/udump/ctmesp1_ora_487452.trc:

ORA-00600: internal error code, arguments: [17059], [0x70000008647FB30], [], [], [], [], [], []

Wed Nov 28 21:13:00 2007

Errors in file /oracle/ora9/admin/ctmesp1/udump/ctmesp1_ora_716816.trc:

ORA-00600: internal error code, arguments: [17059], [0x7000000B14DD2D8], [], [], [], [], [], []

tracefile:

$ vi /oracle/ora9/admin/ctmesp1/udump/ctmesp1_ora_487452.trc

"/oracle/ora9/admin/ctmesp1/udump/ctmesp1_ora_487452.trc" 106515 lines, 6484852 characters

/oracle/ora9/admin/ctmesp1/udump/ctmesp1_ora_487452.trc

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production

With the Partitioning and Oracle Data Mining options

JServer Release 9.2.0.8.0 - Production

ORACLE_HOME = /oracle/ora9/product/9.2

System name:    AIX

Node name:      CTMESP1

Release:        3

Version:        5

Machine:        000108B0D700

Instance name: CTMESP1

Redo thread mounted by this instance: 1

Oracle process number: 55

Unix process pid: 487452, image: [email=oracle@CTMESP1]oracle@CTMESP1[/email] (TNS V1-V3)

*** 2007-11-28 20:57:36.879

*** SESSION ID

211.4182) 2007-11-28 20:57:36.760

LIBRARY OBJECT HANDLE: handle=7000000b4660120

name=select * from DBA_DDL_LOCKS

hash=f966527 timestamp=11-28-2007 14:05:11

namespace=CRSR flags=RON/KGHP/TIM/OBS/PN0/SML/[12410000]

kkkk-dddd-llll=0000-0001-0001 lock=N pin=S latch#=1

lwt=7000000b4660150[7000000b4660150,7000000b4660150] ltm=7000000b4660160[7000000b4660160,7000000b4660160]

pwt=7000000b4660180[7000000b4660180,7000000b4660180] ptm=7000000b4660210[7000000b4660210,7000000b4660210]

ref=7000000b4660130[7000000b4660130, 7000000b4660130] lnd=7000000b4660228[7000000b4660228,7000000b4660228]

LOCK OWNERS:

lock     user  session count mode flags

-------- -------- -------- ----- ---- ------------------------

700000080d7ef78 70000007e880188 70000007e880188     1 N   PNC/[04]