Memory Dump in Oracle trace file

[davidstraker]

Hey all

We are getting a "memory dump from <x> to <y>" error appearing in our trace files. It appears to be occurring when some third-party software we use attempts either a SELECT... FOR UPDATE or an UPDATE on a table which contains a BLOB column. The BLOB is included in the SQL statement.

There are no errors appearing in the alert log. Also, as this is an 8.1.7.4 database, it is out of support with Oracle and so I can get no joy from them on the matter.

A transcript of part of the trace file is given below; the memory dump error is recurring constantly throughout it. Can anybody throw some light on what could be causing the error?

Thanx
David.

Trace File Transcript
=====================
Dump file D:\oracle\ora81\RDBMS\TRACE\ORA02204.TRC
Tue Jun 20 16:29:45 2006
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: idb

Redo thread mounted by this instance: 1

Oracle process number: 31

Windows thread id: 2204, image: ORACLE.EXE


*** 2006-06-20 16:29:45.203
*** SESSION ID28.236) 2006-06-20 16:29:45.187
=====================
PARSING IN CURSOR #1 len=492 dep=0 uid=18 oct=3 lid=18 tim=0 hv=313033313 ad='57c5404'
SELECT F_WorkObjectBlob, F_WobNum, F_WorkSpaceId, F_Locked, F_LockMachine, F_LockUser, F_LockTime, F_LastUser, F_BitFlags, F_BindPending, F_BoundUser, F_BoundMachine, F_NextQueue, F_Tag, F_UniqueId, F_OperationId, F_WorkClassId, F_QueueWPClassId, F_EnqueueTime, F_CreateTime, F_InstrSheetId, F_WorkOrderId, F_SortOrder, F_StepProcId, WorkItemID, QueueName, Priority, Step, IndexingArea, DiaryDate, MyBox, QARequired, ChildID, VWServer, Moved, Reactivated FROM VWQueue1_359 where F_WobNum = :W
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=0,tim=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1111838976 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1111838976 p2=1 p3=0
BINDS #1:
bind 0: dty=23 mxl=32(16) mal=00 scl=00 pre=00 oacflg=00 oacfl2=0 size=32 offset=0
bfp=0c0521dc bln=32 avl=16 flg=05
value=
Dump of memory from 0xC0521DC to 0xC0521EC
C0521D0 9E2362B1 [.b#.]
C0521E0 479F3EB7 8B3F2BA9 A1441E4C [.>.G.+?.L.D.]
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1111838976 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1111838976 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1111838976 p2=1 p3=0
FETCH #1:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=1,dep=0,og=4,tim=0
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1111838976 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1111838976 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1111838976 p2=1 p3=0
XCTEND rlbk=0, rd_only=1
WAIT #0: nam='SQL*Net message to client' ela= 0 p1=1111838976 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 0 p1=1111838976 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=0 obj=3696 op='TABLE ACCESS BY INDEX ROWID VWQUEUE1_359 '
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=3697 op='INDEX UNIQUE SCAN '