/dborafiles/GEN/OSPGEN/admin/udump/ospgen_ora_13923.trc
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /dboracle/orabase/product/OSPGEN/10.1.0.5
System name:	SunOS
Node name:	osp2sec01-th
Release:	5.10
Version:	Generic_118833-02
Machine:	sun4u
Instance name: OSPGEN
Redo thread mounted by this instance: 1
Oracle process number: 11
Unix process pid: 13923, image: oracleOSPGEN@osp2sec01-th

*** 2010-01-14 13:48:20.449
*** SERVICE NAME:(SYS$USERS) 2010-01-14 13:48:20.447
*** SESSION ID:(977.40971) 2010-01-14 13:48:20.447
PARSING IN CURSOR #6 len=271 dep=0 uid=74 oct=2 lid=74 tim=35563503700556 hv=4028554908 ad='8e832a08'
INSERT INTO SAS_AUDIT_TRAIL_DETAIL (TRANS_ID, JOB_ID, TRANS_EXIT_CODE , TRANS_STEP, TRANS_REQUEST_XML, TRANS_RESPONSE_XML, TRANS_TIME, TRANS_CLIENT, TRANS_SERVER, COMMENTS, JEOPARDY_STATUS , JEOPARDY_RES_REMARK) VALUES (:1,  :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
END OF STMT
EXEC #6:c=250000,e=235100,p=1,cr=5,cu=23,mis=0,r=1,dep=0,og=1,tim=35563503700503
XCTEND rlbk=0, rd_only=0
WAIT #6: nam='log file sync' ela= 1247 p1=462 p2=0 p3=0
WAIT #6: nam='SQL*Net message to client' ela= 5 p1=1952673792 p2=1 p3=0
WAIT #6: nam='SQL*Net message from client' ela= 12866 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=137,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563503716299
WAIT #3: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=66,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563503716434
WAIT #3: nam='SQL*Net message from client' ela= 1105196 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=254,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563504822227
WAIT #3: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563504822380
WAIT #3: nam='SQL*Net message from client' ela= 14104 p1=1952673792 p2=1 p3=0
BINDS #7:
 bind 0: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=192 offset=0
   bfp=ffffffff7b86ddd0 bln=11 avl=11 flg=05
   value=
Dump of memory from 0xFFFFFFFF7B86DDD0 to 0xFFFFFFFF7B86DDDB
FFFFFFFF7B86DDD0 786E010E 0E311717 20690000           [xn...1.. i..]    
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=16
   bfp=ffffffff7b86dde0 bln=22 avl=01 flg=01
   value=0
 bind 2: dty=1 mxl=128(47) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=40
   bfp=ffffffff7b86ddf8 bln=128 avl=42 flg=01
   value="SI_MOC_QCBA__RESPONSE_SUCCESS_STATECODE_OK"
 bind 3: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=168
   bfp=ffffffff7b86de78 bln=22 avl=05 flg=01
   value=18298280
=====================
PARSING IN CURSOR #7 len=120 dep=0 uid=74 oct=6 lid=74 tim=35563504838079 hv=3537905758 ad='91dd3940'
UPDATE SAS_AUDIT_TRAIL_MASTER	SET LAST_TRANS_TIME = :1, LAST_TRANS_STATUS = :2, LAST_SUCCESS_STEP = :3 WHERE JOB_ID = :4
END OF STMT
EXEC #7:c=0,e=1316,p=0,cr=3,cu=4,mis=0,r=1,dep=0,og=1,tim=35563504838066
XCTEND rlbk=0, rd_only=0
WAIT #7: nam='log file sync' ela= 1876 p1=1503 p2=0 p3=0
WAIT #7: nam='SQL*Net message to client' ela= 5 p1=1952673792 p2=1 p3=0
WAIT #7: nam='SQL*Net message from client' ela= 23005 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=100,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563504864032
WAIT #3: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563504864153
WAIT #3: nam='SQL*Net message from client' ela= 18430 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=154,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563504882945
WAIT #3: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563504883072
WAIT #3: nam='SQL*Net message from client' ela= 12866 p1=1952673792 p2=1 p3=0
BINDS #7:
 bind 0: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=192 offset=0
   bfp=ffffffff7b86ddd0 bln=11 avl=11 flg=05
   value=
Dump of memory from 0xFFFFFFFF7B86DDD0 to 0xFFFFFFFF7B86DDDB
FFFFFFFF7B86DDD0 786E010E 0E31171A C3324000           [xn...1...2@.]    
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=16
   bfp=ffffffff7b86dde0 bln=22 avl=01 flg=01
   value=0
 bind 2: dty=1 mxl=128(47) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=40
   bfp=ffffffff7b86ddf8 bln=128 avl=31 flg=01
   value="SE_OVW_QUERYORDER_STATE_CODE_OK"
 bind 3: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=168
   bfp=ffffffff7b86de78 bln=22 avl=05 flg=01
   value=18298278
EXEC #7:c=0,e=1381,p=0,cr=3,cu=4,mis=0,r=1,dep=0,og=1,tim=35563504897582
XCTEND rlbk=0, rd_only=0
WAIT #7: nam='log file sync' ela= 2802 p1=1549 p2=0 p3=0
WAIT #7: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
WAIT #7: nam='SQL*Net message from client' ela= 12493 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=129,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563504913825
WAIT #3: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563504913951
WAIT #3: nam='SQL*Net message from client' ela= 22850 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=103,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563504937132
WAIT #3: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563504937242
WAIT #3: nam='SQL*Net message from client' ela= 12451 p1=1952673792 p2=1 p3=0
=====================
PARSING IN CURSOR #6 len=271 dep=0 uid=74 oct=2 lid=74 tim=35563555789189 hv=4028554908 ad='8e832a08'
INSERT INTO SAS_AUDIT_TRAIL_DETAIL (TRANS_ID, JOB_ID, TRANS_EXIT_CODE , TRANS_STEP, TRANS_REQUEST_XML, TRANS_RESPONSE_XML, TRANS_TIME, TRANS_CLIENT, TRANS_SERVER, COMMENTS, JEOPARDY_STATUS , JEOPARDY_RES_REMARK) VALUES (:1,  :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
END OF STMT
PARSE #6:c=10000,e=1325,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=35563555789179
BINDS #6:
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=200 offset=0
   bfp=ffffffff7b85a880 bln=22 avl=06 flg=05
   value=108451963
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=24
   bfp=ffffffff7b85a898 bln=22 avl=05 flg=01
   value=18298286
 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=48
   bfp=ffffffff7b85a8b0 bln=22 avl=01 flg=01
   value=0
 bind 3: dty=1 mxl=128(35) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=72
   bfp=ffffffff7b85a8c8 bln=128 avl=35 flg=01
   value="POSTING_TO_REQUEST_ORDER_SUCCESSFUL"
 bind 4: dty=1 mxl=4001(2147483647) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=4000 offset=0
   No bind buffers allocated
 bind 5: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=200 offset=0
   bfp=ffffffff7b85a7a0 bln=32 avl=00 flg=05
 bind 6: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=32
   bfp=ffffffff7b85a7c0 bln=11 avl=11 flg=01
   value=
Dump of memory from 0xFFFFFFFF7B85A7C0 to 0xFFFFFFFF7B85A7CB
FFFFFFFF7B85A7C0 786E010E 0E320F15 56A580FF           [xn...2..V...]    
 bind 7: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=48
   bfp=ffffffff7b85a7d0 bln=32 avl=03 flg=01
   value="SAS"
 bind 8: dty=1 mxl=32(08) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=80
   bfp=ffffffff7b85a7f0 bln=32 avl=08 flg=01
   value="CCMCMPAL"
 bind 9: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=112
   bfp=ffffffff7b85a810 bln=32 avl=00 flg=01
 bind 10: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=144
   bfp=ffffffff7b85a830 bln=22 avl=01 flg=01
   value=0
 bind 11: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=168
   bfp=ffffffff7b85a848 bln=32 avl=00 flg=01
WAIT #6: nam='SQL*Net more data from client' ela= 57 p1=1952673792 p2=37 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 32 p1=1952673792 p2=14 p3=0
WAIT #6: nam='direct path write' ela= 1 p1=5 p2=427476 p3=1
WAIT #6: nam='direct path write' ela= 2 p1=5 p2=427476 p3=1
WAIT #6: nam='direct path write' ela= 84 p1=5 p2=427476 p3=1
WAIT #6: nam='SQL*Net more data from client' ela= 94 p1=1952673792 p2=56 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 32 p1=1952673792 p2=33 p3=0
WAIT #6: nam='db file sequential read' ela= 36 p1=5 p2=427476 p3=1
WAIT #6: nam='direct path read' ela= 125 p1=5 p2=427476 p3=1
WAIT #6: nam='SQL*Net more data from client' ela= 57 p1=1952673792 p2=10 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=52 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=29 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=6 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 37 p1=1952673792 p2=48 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 28 p1=1952673792 p2=25 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=2 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=44 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 38 p1=1952673792 p2=21 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 33 p1=1952673792 p2=63 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=40 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 28 p1=1952673792 p2=17 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 115 p1=1952673792 p2=59 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 26 p1=1952673792 p2=36 p3=0
WAIT #6: nam='direct path write' ela= 1 p1=5 p2=427524 p3=1
WAIT #6: nam='direct path write' ela= 73 p1=5 p2=427524 p3=1
WAIT #6: nam='direct path write' ela= 0 p1=5 p2=427285 p3=1
WAIT #6: nam='direct path write' ela= 0 p1=5 p2=427285 p3=1
WAIT #6: nam='direct path write' ela= 35 p1=5 p2=427285 p3=1
EXEC #6:c=500000,e=494137,p=1,cr=8,cu=47,mis=1,r=1,dep=0,og=1,tim=35563556283540
XCTEND rlbk=0, rd_only=0
WAIT #6: nam='log file sync' ela= 1492 p1=1923 p2=0 p3=0
WAIT #6: nam='SQL*Net message to client' ela= 5 p1=1952673792 p2=1 p3=0
WAIT #6: nam='SQL*Net message from client' ela= 12696 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=212,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563556299094
WAIT #3: nam='SQL*Net message to client' ela= 1 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=83,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563556299243
WAIT #3: nam='SQL*Net message from client' ela= 16826 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=139,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563556316476
WAIT #3: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=64,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563556316605
WAIT #3: nam='SQL*Net message from client' ela= 12318 p1=1952673792 p2=1 p3=0
BINDS #7:
 bind 0: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=192 offset=0
   bfp=ffffffff7b85ded8 bln=11 avl=11 flg=05
   value=
Dump of memory from 0xFFFFFFFF7B85DED8 to 0xFFFFFFFF7B85DEE3
FFFFFFFF7B85DED0                   786E010E 0E321007          [xn...2..]
FFFFFFFF7B85DEE0 08898001                             [....]            
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=16
   bfp=ffffffff7b85dee8 bln=22 avl=01 flg=01
   value=0
 bind 2: dty=1 mxl=128(47) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=40
   bfp=ffffffff7b85df00 bln=128 avl=17 flg=01
   value="QC_REQUEST_POSTED"
 bind 3: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=168
   bfp=ffffffff7b85df80 bln=22 avl=05 flg=01
   value=18298344
EXEC #7:c=10000,e=1028,p=0,cr=3,cu=5,mis=0,r=1,dep=0,og=1,tim=35563556330260
XCTEND rlbk=0, rd_only=0
WAIT #7: nam='log file sync' ela= 1088 p1=26 p2=0 p3=0
WAIT #7: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #7: nam='SQL*Net message from client' ela= 11660 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=120,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563556343847
WAIT #3: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563556343969
WAIT #3: nam='SQL*Net message from client' ela= 24353 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=153,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563556368766
WAIT #3: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=74,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563556368905
WAIT #3: nam='SQL*Net message from client' ela= 12586 p1=1952673792 p2=1 p3=0
=====================
PARSING IN CURSOR #6 len=271 dep=0 uid=74 oct=2 lid=74 tim=35563556467239 hv=4028554908 ad='8e832a08'
INSERT INTO SAS_AUDIT_TRAIL_DETAIL (TRANS_ID, JOB_ID, TRANS_EXIT_CODE , TRANS_STEP, TRANS_REQUEST_XML, TRANS_RESPONSE_XML, TRANS_TIME, TRANS_CLIENT, TRANS_SERVER, COMMENTS, JEOPARDY_STATUS , JEOPARDY_RES_REMARK) VALUES (:1,  :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
END OF STMT
PARSE #6:c=0,e=329,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563556467229
WAIT #6: nam='SQL*Net more data from client' ela= 37 p1=1952673792 p2=53 p3=0
BINDS #6:
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=2304 offset=0
   bfp=ffffffff7b71d400 bln=22 avl=06 flg=05
   value=108451970
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=24
   bfp=ffffffff7b71d418 bln=22 avl=05 flg=01
   value=18298344
 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=48
   bfp=ffffffff7b71d430 bln=22 avl=01 flg=01
   value=0
 bind 3: dty=1 mxl=32(17) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=72
   bfp=ffffffff7b71d448 bln=32 avl=17 flg=01
   value="QC_REQUEST_POSTED"
 bind 4: dty=1 mxl=2000(1923) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=104
   bfp=ffffffff7b71d468 bln=2000 avl=1923 flg=01
   value="<ns:queryCustomerRequest xmlns:ns="http://capabilities.nat.bt.com/xsd/ManageCustomer/2008/07/28"><stan:standardHeader xmlns:stan="http://wsi.nat.bt.com/2005/06/StandardHeader/"><stan:e2e><stan:E2EDATA xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSc"...
 bind 5: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=2104
   bfp=ffffffff7b71dc38 bln=32 avl=00 flg=01
 bind 6: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=2136
   bfp=ffffffff7b71dc58 bln=11 avl=11 flg=01
   value=
Dump of memory from 0xFFFFFFFF7B71DC58 to 0xFFFFFFFF7B71DC63
FFFFFFFF7B71DC50                   786E010E 0E321009          [xn...2..]
FFFFFFFF7B71DC60 5BA14000                             [[.@.]            
 bind 7: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=2152
   bfp=ffffffff7b71dc68 bln=32 avl=03 flg=01
   value="SAS"
 bind 8: dty=1 mxl=32(08) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=2184
   bfp=ffffffff7b71dc88 bln=32 avl=08 flg=01
   value="CCMCMPAL"
 bind 9: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=2216
   bfp=ffffffff7b71dca8 bln=32 avl=00 flg=01
 bind 10: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=2248
   bfp=ffffffff7b71dcc8 bln=22 avl=01 flg=01
   value=0
 bind 11: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=2272
   bfp=ffffffff7b71dce0 bln=32 avl=00 flg=01
EXEC #6:c=10000,e=5342,p=0,cr=1,cu=17,mis=1,r=1,dep=0,og=1,tim=35563556472798
XCTEND rlbk=0, rd_only=0
WAIT #6: nam='log file sync' ela= 1063 p1=53 p2=0 p3=0
WAIT #6: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
WAIT #6: nam='SQL*Net message from client' ela= 11983 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=224,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563556486911
WAIT #3: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=92,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563556487082
WAIT #3: nam='SQL*Net message from client' ela= 617653 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=120,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563557105203
WAIT #3: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563557105331
WAIT #3: nam='SQL*Net message from client' ela= 14666 p1=1952673792 p2=1 p3=0
BINDS #7:
 bind 0: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=192 offset=0
   bfp=ffffffff7b71cff0 bln=11 avl=11 flg=05
   value=
Dump of memory from 0xFFFFFFFF7B71CFF0 to 0xFFFFFFFF7B71CFFB
FFFFFFFF7B71CFF0 786E010E 0E321037 50280000           [xn...2.7P(..]    
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=16
   bfp=ffffffff7b71d000 bln=22 avl=01 flg=01
   value=0
 bind 2: dty=1 mxl=128(47) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=40
   bfp=ffffffff7b71d018 bln=128 avl=19 flg=01
   value="BI_MPA_STATECODE_OK"
 bind 3: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=168
   bfp=ffffffff7b71d098 bln=22 avl=05 flg=01
   value=18298339
EXEC #7:c=0,e=1025,p=0,cr=3,cu=6,mis=0,r=1,dep=0,og=1,tim=35563557121223
XCTEND rlbk=0, rd_only=0
WAIT #7: nam='log file sync' ela= 1584 p1=270 p2=0 p3=0
WAIT #7: nam='SQL*Net message to client' ela= 5 p1=1952673792 p2=1 p3=0
WAIT #7: nam='SQL*Net message from client' ela= 13715 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=234,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563557137586
WAIT #3: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563557137733
WAIT #3: nam='SQL*Net message from client' ela= 23783 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=98,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563557161846
WAIT #3: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=54,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563557161958
WAIT #3: nam='SQL*Net message from client' ela= 13223 p1=1952673792 p2=1 p3=0
=====================
PARSING IN CURSOR #6 len=271 dep=0 uid=74 oct=2 lid=74 tim=35563832653810 hv=4028554908 ad='8e832a08'
INSERT INTO SAS_AUDIT_TRAIL_DETAIL (TRANS_ID, JOB_ID, TRANS_EXIT_CODE , TRANS_STEP, TRANS_REQUEST_XML, TRANS_RESPONSE_XML, TRANS_TIME, TRANS_CLIENT, TRANS_SERVER, COMMENTS, JEOPARDY_STATUS , JEOPARDY_RES_REMARK) VALUES (:1,  :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
END OF STMT
PARSE #6:c=0,e=202,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563832653797
BINDS #6:
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=136 offset=0
   bfp=ffffffff7b86dec8 bln=22 avl=06 flg=05
   value=108454092
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=24
   bfp=ffffffff7b86dee0 bln=22 avl=05 flg=01
   value=18298688
 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=48
   bfp=ffffffff7b86def8 bln=22 avl=01 flg=01
   value=0
 bind 3: dty=1 mxl=32(28) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=72
   bfp=ffffffff7b86df10 bln=32 avl=28 flg=01
   value="QC_RESPONSE_XML_STATECODE_OK"
 bind 4: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=104
   bfp=ffffffff7b86df30 bln=32 avl=00 flg=01
 bind 5: dty=1 mxl=4001(2147483647) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=4000 offset=0
   No bind buffers allocated
 bind 6: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=168 offset=0
   bfp=ffffffff7bb78a98 bln=11 avl=11 flg=05
   value=
Dump of memory from 0xFFFFFFFF7BB78A98 to 0xFFFFFFFF7BB78AA3
FFFFFFFF7BB78A90                   786E010E 0E363A1B          [xn...6:.]
FFFFFFFF7BB78AA0 F45F4000                             [._@.]            
 bind 7: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=16
   bfp=ffffffff7bb78aa8 bln=32 avl=03 flg=01
   value="SAS"
 bind 8: dty=1 mxl=32(08) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=48
   bfp=ffffffff7bb78ac8 bln=32 avl=08 flg=01
   value="CCMCMPAL"
 bind 9: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=80
   bfp=ffffffff7bb78ae8 bln=32 avl=00 flg=01
 bind 10: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=112
   bfp=ffffffff7bb78b08 bln=22 avl=01 flg=01
   value=0
 bind 11: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=136
   bfp=ffffffff7bb78b20 bln=32 avl=00 flg=01
WAIT #6: nam='SQL*Net more data from client' ela= 59 p1=1952673792 p2=30 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 30 p1=1952673792 p2=7 p3=0
WAIT #6: nam='direct path write' ela= 0 p1=24 p2=335666 p3=1
WAIT #6: nam='direct path write' ela= 2 p1=24 p2=335666 p3=1
WAIT #6: nam='direct path write' ela= 103 p1=24 p2=335666 p3=1
WAIT #6: nam='SQL*Net more data from client' ela= 81 p1=1952673792 p2=49 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=26 p3=0
WAIT #6: nam='db file sequential read' ela= 50 p1=24 p2=335666 p3=1
WAIT #6: nam='direct path read' ela= 88 p1=24 p2=335666 p3=1
WAIT #6: nam='SQL*Net more data from client' ela= 69 p1=1952673792 p2=3 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 34 p1=1952673792 p2=45 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 35 p1=1952673792 p2=22 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=64 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 40 p1=1952673792 p2=41 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=18 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 32 p1=1952673792 p2=60 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=37 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 38 p1=1952673792 p2=14 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 30 p1=1952673792 p2=56 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 33 p1=1952673792 p2=33 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=10 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 41 p1=1952673792 p2=52 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=29 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 35 p1=1952673792 p2=6 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 28 p1=1952673792 p2=48 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 35 p1=1952673792 p2=25 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 28 p1=1952673792 p2=2 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 27 p1=1952673792 p2=44 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 7494 p1=1952673792 p2=21 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 36 p1=1952673792 p2=63 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 65 p1=1952673792 p2=40 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 969 p1=1952673792 p2=17 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 43 p1=1952673792 p2=59 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 35 p1=1952673792 p2=36 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 28 p1=1952673792 p2=13 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 1177 p1=1952673792 p2=55 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=32 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=9 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 2202 p1=1952673792 p2=51 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 60 p1=1952673792 p2=28 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=5 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 35 p1=1952673792 p2=47 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 797 p1=1952673792 p2=24 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=1 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 27 p1=1952673792 p2=43 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 1121 p1=1952673792 p2=20 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=62 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=39 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 27 p1=1952673792 p2=16 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 4003 p1=1952673792 p2=58 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 37 p1=1952673792 p2=35 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 35 p1=1952673792 p2=12 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 818 p1=1952673792 p2=54 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 43 p1=1952673792 p2=31 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 26 p1=1952673792 p2=8 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 20 p1=1952673792 p2=50 p3=0
WAIT #6: nam='direct path write' ela= 1 p1=24 p2=335347 p3=1
WAIT #6: nam='direct path write' ela= 83 p1=24 p2=335347 p3=1
WAIT #6: nam='direct path write' ela= 0 p1=24 p2=335411 p3=1
WAIT #6: nam='direct path write' ela= 1 p1=24 p2=335411 p3=1
WAIT #6: nam='direct path write' ela= 41 p1=24 p2=335411 p3=1
EXEC #6:c=600000,e=605367,p=1,cr=19,cu=112,mis=1,r=1,dep=0,og=1,tim=35563833259425
XCTEND rlbk=0, rd_only=0
WAIT #6: nam='log file sync' ela= 1547 p1=940 p2=0 p3=0
WAIT #6: nam='SQL*Net message to client' ela= 9 p1=1952673792 p2=1 p3=0
WAIT #6: nam='SQL*Net message from client' ela= 12100 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=184,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563833275239
WAIT #3: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=90,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563833275404
WAIT #3: nam='SQL*Net message from client' ela= 646814 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=144,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563833922967
WAIT #3: nam='SQL*Net message to client' ela= 5 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=69,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563833923108
WAIT #3: nam='SQL*Net message from client' ela= 22614 p1=1952673792 p2=1 p3=0
BINDS #7:
 bind 0: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=192 offset=0
   bfp=ffffffff7b8560b0 bln=11 avl=11 flg=05
   value=
Dump of memory from 0xFFFFFFFF7B8560B0 to 0xFFFFFFFF7B8560BB
FFFFFFFF7B8560B0 786E010E 0E363C17 A9BD4000           [xn...6<...@.]    
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=16
   bfp=ffffffff7b8560c0 bln=22 avl=01 flg=01
   value=0
 bind 2: dty=1 mxl=128(47) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=40
   bfp=ffffffff7b8560d8 bln=128 avl=29 flg=01
   value="QCA_RESPONSE_XML_STATECODE_OK"
 bind 3: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=168
   bfp=ffffffff7b856158 bln=22 avl=05 flg=01
   value=18298690
EXEC #7:c=0,e=1257,p=0,cr=3,cu=4,mis=0,r=1,dep=0,og=1,tim=35563833947362
XCTEND rlbk=0, rd_only=0
WAIT #7: nam='log file sync' ela= 5364 p1=7 p2=0 p3=0
WAIT #7: nam='SQL*Net message to client' ela= 7 p1=1952673792 p2=1 p3=0
WAIT #7: nam='SQL*Net message from client' ela= 18878 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=161,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563833972739
WAIT #3: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=69,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563833972882
WAIT #3: nam='SQL*Net message from client' ela= 19642 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=143,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563833992951
WAIT #3: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=70,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563833993085
WAIT #3: nam='SQL*Net message from client' ela= 12380 p1=1952673792 p2=1 p3=0
=====================
PARSING IN CURSOR #6 len=271 dep=0 uid=74 oct=2 lid=74 tim=35563846769266 hv=4028554908 ad='8e832a08'
INSERT INTO SAS_AUDIT_TRAIL_DETAIL (TRANS_ID, JOB_ID, TRANS_EXIT_CODE , TRANS_STEP, TRANS_REQUEST_XML, TRANS_RESPONSE_XML, TRANS_TIME, TRANS_CLIENT, TRANS_SERVER, COMMENTS, JEOPARDY_STATUS , JEOPARDY_RES_REMARK) VALUES (:1,  :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
END OF STMT
PARSE #6:c=0,e=268,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563846769257
BINDS #6:
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=200 offset=0
   bfp=ffffffff7b86de88 bln=22 avl=06 flg=05
   value=108454206
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=24
   bfp=ffffffff7b86dea0 bln=22 avl=05 flg=01
   value=18298702
 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=48
   bfp=ffffffff7b86deb8 bln=22 avl=01 flg=01
   value=0
 bind 3: dty=1 mxl=128(29) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=72
   bfp=ffffffff7b86ded0 bln=128 avl=29 flg=01
   value="QCA_REQUEST_POSTED_SUCCESSFUL"
 bind 4: dty=1 mxl=4000(1341) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=4000 offset=0
   bfp=ffffffff7b868ae0 bln=4000 avl=1341 flg=05
   value="<ns:queryCustomerAssetRequest xmlns:ns="http://capabilities.nat.bt.com/xsd/ManageCustomerAsset/2009/02/12"><stan:standardHeader xmlns:stan="http://wsi.nat.bt.com/2005/06/StandardHeader/"><stan:e2e><stan:E2EDATA xsi:nil="true" xmlns:xsi="http://www.w3.org/"...
 bind 5: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=200 offset=0
   bfp=ffffffff7b855ff0 bln=32 avl=00 flg=05
 bind 6: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=32
   bfp=ffffffff7b856010 bln=11 avl=11 flg=01
   value=
Dump of memory from 0xFFFFFFFF7B856010 to 0xFFFFFFFF7B85601B
FFFFFFFF7B856010 786E010E 0E370D15 56A58000           [xn...7..V...]    
 bind 7: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=48
   bfp=ffffffff7b856020 bln=32 avl=03 flg=01
   value="SAS"
 bind 8: dty=1 mxl=32(08) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=80
   bfp=ffffffff7b856040 bln=32 avl=08 flg=01
   value="CCMCMPAL"
 bind 9: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=112
   bfp=ffffffff7b856060 bln=32 avl=00 flg=01
 bind 10: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=144
   bfp=ffffffff7b856080 bln=22 avl=01 flg=01
   value=0
 bind 11: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=168
   bfp=ffffffff7b856098 bln=32 avl=00 flg=01
EXEC #6:c=10000,e=2214,p=0,cr=1,cu=17,mis=0,r=1,dep=0,og=1,tim=35563846771678
XCTEND rlbk=0, rd_only=0
WAIT #6: nam='log file sync' ela= 835 p1=136 p2=0 p3=0
WAIT #6: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
WAIT #6: nam='SQL*Net message from client' ela= 13994 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=832,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563846788115
WAIT #3: nam='SQL*Net message to client' ela= 1 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=74,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563846788275
WAIT #3: nam='SQL*Net message from client' ela= 92688 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=138,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563846881384
WAIT #3: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563846881511
WAIT #3: nam='SQL*Net message from client' ela= 13546 p1=1952673792 p2=1 p3=0
BINDS #7:
 bind 0: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=192 offset=0
   bfp=ffffffff7b855ff8 bln=11 avl=11 flg=05
   value=
Dump of memory from 0xFFFFFFFF7B855FF8 to 0xFFFFFFFF7B856003
FFFFFFFF7B855FF0                   786E010E 0E370D27          [xn...7.']
FFFFFFFF7B856000 A3184000                             [..@.]            
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=16
   bfp=ffffffff7b856008 bln=22 avl=01 flg=01
   value=0
 bind 2: dty=1 mxl=128(47) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=40
   bfp=ffffffff7b856020 bln=128 avl=47 flg=01
   value="SE_OVW_QUERY_CUSTOMER_ASSET_FOR_MCSO_REQ_POSTED"
 bind 3: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=168
   bfp=ffffffff7b8560a0 bln=22 avl=05 flg=01
   value=18298703
EXEC #7:c=0,e=1084,p=0,cr=3,cu=5,mis=0,r=1,dep=0,og=1,tim=35563846896506
XCTEND rlbk=0, rd_only=0
WAIT #7: nam='log file sync' ela= 1377 p1=155 p2=0 p3=0
WAIT #7: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #7: nam='SQL*Net message from client' ela= 12454 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=156,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563846911180
WAIT #3: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=66,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563846911311
WAIT #3: nam='SQL*Net message from client' ela= 25118 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=166,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35563846936922
WAIT #3: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=67,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35563846937059
WAIT #3: nam='SQL*Net message from client' ela= 12477 p1=1952673792 p2=1 p3=0
=====================
PARSING IN CURSOR #6 len=271 dep=0 uid=74 oct=2 lid=74 tim=35564125084944 hv=4028554908 ad='8e832a08'
INSERT INTO SAS_AUDIT_TRAIL_DETAIL (TRANS_ID, JOB_ID, TRANS_EXIT_CODE , TRANS_STEP, TRANS_REQUEST_XML, TRANS_RESPONSE_XML, TRANS_TIME, TRANS_CLIENT, TRANS_SERVER, COMMENTS, JEOPARDY_STATUS , JEOPARDY_RES_REMARK) VALUES (:1,  :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
END OF STMT
PARSE #6:c=0,e=141,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35564125084936
BINDS #6:
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=200 offset=0
   bfp=ffffffff7b855ff0 bln=22 avl=06 flg=05
   value=108456162
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=24
   bfp=ffffffff7b856008 bln=22 avl=05 flg=01
   value=18299009
 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=48
   bfp=ffffffff7b856020 bln=22 avl=01 flg=01
   value=0
 bind 3: dty=1 mxl=128(36) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=72
   bfp=ffffffff7b856038 bln=128 avl=36 flg=01
   value="SI_GCD_RESPONSE_SUCCESS_STATECODE_OK"
 bind 4: dty=1 mxl=4001(5358) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=4000 offset=0
   No bind buffers allocated
 bind 5: dty=1 mxl=4001(2147483647) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=4000 offset=0
   No bind buffers allocated
 bind 6: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=168 offset=0
   bfp=ffffffff7b855f28 bln=11 avl=11 flg=05
   value=
Dump of memory from 0xFFFFFFFF7B855F28 to 0xFFFFFFFF7B855F33
FFFFFFFF7B855F20                   786E010E 0E3B3A18          [xn...;:.]
FFFFFFFF7B855F30 EA2C80FF                             [.,..]            
 bind 7: dty=1 mxl=32(06) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=16
   bfp=ffffffff7b855f38 bln=32 avl=06 flg=01
   value="Online"
 bind 8: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=48
   bfp=ffffffff7b855f58 bln=32 avl=03 flg=01
   value="SAS"
 bind 9: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=80
   bfp=ffffffff7b855f78 bln=32 avl=00 flg=01
 bind 10: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=112
   bfp=ffffffff7b855f98 bln=22 avl=01 flg=01
   value=0
 bind 11: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=136
   bfp=ffffffff7b855fb0 bln=32 avl=00 flg=01
WAIT #6: nam='SQL*Net more data from client' ela= 60 p1=1952673792 p2=36 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 32 p1=1952673792 p2=13 p3=0
WAIT #6: nam='direct path write' ela= 1 p1=5 p2=427517 p3=1
WAIT #6: nam='direct path write' ela= 1 p1=5 p2=427517 p3=1
WAIT #6: nam='direct path write' ela= 44 p1=5 p2=427517 p3=1
WAIT #6: nam='db file sequential read' ela= 66 p1=5 p2=427517 p3=1
WAIT #6: nam='direct path read' ela= 112 p1=5 p2=427517 p3=1
WAIT #6: nam='direct path write' ela= 1 p1=5 p2=427517 p3=1
WAIT #6: nam='direct path write' ela= 0 p1=5 p2=427517 p3=1
WAIT #6: nam='direct path write' ela= 39 p1=5 p2=427517 p3=1
WAIT #6: nam='SQL*Net more data from client' ela= 121 p1=1952673792 p2=39 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 37 p1=1952673792 p2=16 p3=0
WAIT #6: nam='direct path write' ela= 1 p1=24 p2=339220 p3=1
WAIT #6: nam='direct path write' ela= 3 p1=24 p2=339220 p3=1
WAIT #6: nam='direct path write' ela= 131 p1=24 p2=339220 p3=1
WAIT #6: nam='SQL*Net more data from client' ela= 122 p1=1952673792 p2=58 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 111 p1=1952673792 p2=35 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 36 p1=1952673792 p2=12 p3=0
WAIT #6: nam='db file sequential read' ela= 304309 p1=24 p2=339220 p3=1
WAIT #6: nam='direct path read' ela= 892 p1=24 p2=339220 p3=1
WAIT #6: nam='SQL*Net more data from client' ela= 116 p1=1952673792 p2=54 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 35 p1=1952673792 p2=31 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 32 p1=1952673792 p2=8 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=50 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 153 p1=1952673792 p2=27 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 36 p1=1952673792 p2=4 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 34 p1=1952673792 p2=46 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 36 p1=1952673792 p2=23 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 41 p1=1952673792 p2=1 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 36 p1=1952673792 p2=42 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 38 p1=1952673792 p2=19 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 34 p1=1952673792 p2=61 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 37 p1=1952673792 p2=38 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 33 p1=1952673792 p2=15 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 28 p1=1952673792 p2=57 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 33 p1=1952673792 p2=34 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 37 p1=1952673792 p2=11 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 37 p1=1952673792 p2=53 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 32 p1=1952673792 p2=30 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 35 p1=1952673792 p2=7 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 35 p1=1952673792 p2=49 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=26 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 30 p1=1952673792 p2=3 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 29 p1=1952673792 p2=45 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 34 p1=1952673792 p2=22 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 30 p1=1952673792 p2=64 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 30 p1=1952673792 p2=41 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 38 p1=1952673792 p2=18 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 41 p1=1952673792 p2=60 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 34 p1=1952673792 p2=37 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 30 p1=1952673792 p2=14 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 30 p1=1952673792 p2=56 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 36 p1=1952673792 p2=33 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 31 p1=1952673792 p2=10 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 58 p1=1952673792 p2=52 p3=0
WAIT #6: nam='SQL*Net more data from client' ela= 23 p1=1952673792 p2=29 p3=0
WAIT #6: nam='direct path write' ela= 0 p1=24 p2=339220 p3=1
WAIT #6: nam='direct path write' ela= 111 p1=24 p2=339220 p3=1
WAIT #6: nam='direct path write' ela= 0 p1=24 p2=339284 p3=1
WAIT #6: nam='direct path write' ela= 37 p1=24 p2=339284 p3=1
WAIT #6: nam='direct path write' ela= 0 p1=24 p2=339348 p3=1
WAIT #6: nam='direct path write' ela= 35 p1=24 p2=339348 p3=1
WAIT #6: nam='direct path write' ela= 1 p1=24 p2=339605 p3=1
WAIT #6: nam='direct path write' ela= 35 p1=24 p2=339605 p3=1
WAIT #6: nam='direct path write' ela= 0 p1=24 p2=339669 p3=1
WAIT #6: nam='direct path write' ela= 34 p1=24 p2=339669 p3=1
WAIT #6: nam='direct path write' ela= 1 p1=24 p2=339733 p3=1
WAIT #6: nam='direct path write' ela= 38 p1=24 p2=339733 p3=1
WAIT #6: nam='direct path write' ela= 1 p1=24 p2=339797 p3=1
WAIT #6: nam='direct path write' ela= 33 p1=24 p2=339797 p3=1
WAIT #6: nam='direct path write' ela= 0 p1=24 p2=339861 p3=1
WAIT #6: nam='direct path write' ela= 113 p1=24 p2=339861 p3=1
WAIT #6: nam='direct path write' ela= 1 p1=24 p2=339925 p3=1
WAIT #6: nam='direct path write' ela= 34 p1=24 p2=339925 p3=1
WAIT #6: nam='direct path write' ela= 1 p1=24 p2=339989 p3=1
WAIT #6: nam='direct path write' ela= 1 p1=24 p2=339989 p3=1
WAIT #6: nam='direct path write' ela= 72 p1=24 p2=339989 p3=1
EXEC #6:c=460000,e=1748404,p=2,cr=17,cu=86,mis=1,r=1,dep=0,og=1,tim=35564126833541
XCTEND rlbk=0, rd_only=0
WAIT #6: nam='log file sync' ela= 1848 p1=156 p2=0 p3=0
WAIT #6: nam='SQL*Net message to client' ela= 9 p1=1952673792 p2=1 p3=0
WAIT #6: nam='SQL*Net message from client' ela= 20852 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=230,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35564126858288
WAIT #3: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=80,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35564126858469
WAIT #3: nam='SQL*Net message from client' ela= 1682789 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=149,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35564128541785
WAIT #3: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=67,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35564128541925
WAIT #3: nam='SQL*Net message from client' ela= 19143 p1=1952673792 p2=1 p3=0
BINDS #7:
 bind 0: dty=180 mxl=11(11) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=192 offset=0
   bfp=ffffffff7b855ff8 bln=11 avl=11 flg=05
   value=
Dump of memory from 0xFFFFFFFF7B855FF8 to 0xFFFFFFFF7B856003
FFFFFFFF7B855FF0                   786E010E 0E3C0205          [xn...<..]
FFFFFFFF7B856000 8B114000                             [..@.]            
 bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=16
   bfp=ffffffff7b856008 bln=22 avl=01 flg=01
   value=0
 bind 2: dty=1 mxl=128(47) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800010 size=0 offset=40
   bfp=ffffffff7b856020 bln=128 avl=19 flg=01
   value="BI_MPA_STATECODE_OK"
 bind 3: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=800000 size=0 offset=168
   bfp=ffffffff7b8560a0 bln=22 avl=05 flg=01
   value=18299034
EXEC #7:c=0,e=1277,p=0,cr=3,cu=5,mis=0,r=1,dep=0,og=1,tim=35564128562688
XCTEND rlbk=0, rd_only=0
WAIT #7: nam='log file sync' ela= 920 p1=964 p2=0 p3=0
WAIT #7: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #7: nam='SQL*Net message from client' ela= 12253 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=131,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35564128576775
WAIT #3: nam='SQL*Net message to client' ela= 2 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35564128576900
WAIT #3: nam='SQL*Net message from client' ela= 26953 p1=1952673792 p2=1 p3=0
BINDS #3:
EXEC #3:c=0,e=230,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=35564128604434
WAIT #3: nam='SQL*Net message to client' ela= 4 p1=1952673792 p2=1 p3=0
FETCH #3:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=35564128604590
WAIT #3: nam='SQL*Net message from client' ela= 13060 p1=1952673792 p2=1 p3=0
=====================