这几天,我突然发现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
16.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