每到月底,机器的负荷都比较大,现在又产生这个 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]