oracle数据库增加很快,udump下文件为什么突然增长很快?

这几天,我突然发现udump目录下文件增长很快,每天几百兆,哪位老大能帮我解决一下问题,我数据总共才几百兆啊

我摘了一段,大家帮我看看什么问题,怎么才能较少

Dump file :\Oracle\admin\oradb\udump\ORA02464.TRC

Mon Apr 23 19:17:57 2007

ORACLE V8.1.6.0.0 - Production vsnsta=0

vsnsql=e vsnxtr=3

Windows 2000 Version 5.0 Service Pack 4, CPU type 586

Oracle8i Release 8.1.6.0.0 - Production

JServer Release 8.1.6.0.0 - Production

Windows 2000 Version 5.0 Service Pack 4, CPU type 586

Instance name: oradb

Redo thread mounted by this instance: 1

Oracle process number: 17

Windows thread id: 2464, image: ORACLE.EXE

*** SESSION ID

c58e339c7046a1ffce9c5508745874fa.gif16.8153) 2007-04-23 19:17:57.378

=====================

PARSING IN CURSOR #1 len=147 dep=1 uid=0 oct=3 lid=0 tim=0 hv=3013728279 ad='698c678'

select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:1 or grantee#=1) and privilege#>0

END OF STMT

PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=0

EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=5,cu=0,mis=0,r=1,dep=1,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=1,dep=1,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=0

STAT #1 id=1 cnt=2 pid=0 pos=0 obj=0 op='CONNECT BY '

STAT #1 id=2 cnt=3 pid=1 pos=1 obj=0 op='CONCATENATION '

STAT #1 id=3 cnt=1 pid=2 pos=1 obj=102 op='INDEX RANGE SCAN '

STAT #1 id=4 cnt=3 pid=2 pos=2 obj=102 op='INDEX RANGE SCAN '

STAT #1 id=5 cnt=2 pid=1 pos=2 obj=83 op='TABLE ACCESS BY USER ROWID SYSAUTH$ '

STAT #1 id=6 cnt=2 pid=1 pos=3 obj=102 op='INDEX RANGE SCAN '

=====================

PARSING IN CURSOR #1 len=503 dep=1 uid=0 oct=42 lid=0 tim=0 hv=3548304514 ad='6985038'

ALTER SESSION SET NLS_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_TERRITORY= 'CHINA' NLS_CURRENCY= 'RMB' NLS_ISO_CURRENCY= 'CHINA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'SIMPLIFIED CHINESE'  NLS_SORT= 'BINARY' TIME_ZONE= '+08:00' NLS_DUAL_CURRENCY = 'RMB' NLS_TIME_FORMAT = 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT = 'HH.MI.SSXFF AM TZH:TZM' NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZH:TZM'

END OF STMT

PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=0

EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=0

=====================

PARSING IN CURSOR #1 len=72 dep=0 uid=32 oct=3 lid=32 tim=0 hv=3347955950 ad='6999728'

SELECT VALUE FROM SYS.NLS_DATABASE_PARAMETERS WHERE PARAMETER = :SYS_B_0

END OF STMT

PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=1,cu=4,mis=0,r=1,dep=0,og=4,tim=0

STAT #1 id=1 cnt=1 pid=0 pos=0 obj=93 op='TABLE ACCESS FULL PROPS$ '

=====================

PARSING IN CURSOR #1 len=72 dep=0 uid=32 oct=3 lid=32 tim=0 hv=3347955950 ad='6999728'

SELECT VALUE FROM SYS.NLS_DATABASE_PARAMETERS WHERE PARAMETER = :SYS_B_0

END OF STMT

PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=1,cu=4,mis=0,r=1,dep=0,og=4,tim=0

STAT #1 id=1 cnt=1 pid=0 pos=0 obj=93 op='TABLE ACCESS FULL PROPS$ '

=====================

PARSING IN CURSOR #1 len=44 dep=0 uid=32 oct=3 lid=32 tim=0 hv=1833653757 ad='6862694'

select * from cert_info where envsn=:SYS_B_0

END OF STMT

PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

=====================

PARSING IN CURSOR #1 len=48 dep=0 uid=32 oct=3 lid=32 tim=0 hv=1504375318 ad='68a2e4c'

SELECT ROWID from cert_info where envsn=:SYS_B_0

END OF STMT

PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=0

STAT #1 id=1 cnt=1 pid=0 pos=0 obj=22263 op='INDEX UNIQUE SCAN '

=====================

PARSING IN CURSOR #1 len=60 dep=0 uid=32 oct=3 lid=32 tim=0 hv=49067315 ad='685e064'

SELECT ROWID,tab.* from tab WHERE ROWID=:SYS_B_0

END OF STMT

PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

XCTEND rlbk=0, rd_only=1

EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

XCTEND rlbk=0, rd_only=1

STAT #1 id=1 cnt=0 pid=0 pos=0 obj=21967 op='TABLE ACCESS BY USER ROWID tab '

=====================

PARSING IN CURSOR #1 len=60 dep=0 uid=32 oct=3 lid=32 tim=0 hv=49067315 ad='685e064'

SELECT ROWID,tab.* from tab WHERE ROWID=:SYS_B_0

END OF STMT

PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0

FETCH #1:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=1,dep=0,og=4,tim=0

XCTEND rlbk=0, rd_only=1

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值