oracle17059,ORA-00600 [17059] 请各位老大帮忙!!

在月底期间,数据库出现高负荷并引发了ORA-600内部错误,影响了SQL查询性能。错误日志显示在多个时间点出现,涉及到的错误代码17059和内存地址不同。可能的原因包括数据文件损坏、并发问题或系统资源不足。为了解决这个问题,需要检查数据库状态,分析trc文件,并可能进行数据库修复、回滚未完成的事务或调整系统资源分配。
摘要由CSDN通过智能技术生成

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

c58e339c7046a1ffce9c5508745874fa.gif211.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]

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值