Shulou(Shulou.com)06/01 Report--

Background of the question:

Today, when the company's OA system is running, users sometimes report that they can't log in when they log on to the OA platform. The OA administrator checks and finds that there is no problem with the application, but sometimes an error is reported when connecting to the database

Sure enough, when I logged in to OEM cloudcontrol, I found that there was a corresponding error message in the database, and immediately checked the corresponding error report.

Database version: 11.2.0.1 64-bit

Operating system version: centos5.9

Error message:

Trace file / data/oracle/diag/rdbms/ekpj/ekpj/trace/ekpj_ora_6576.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = / data/oracle/oracle11

System name: Linux

Node name: ekpdb01

Release: 2.6.18-348.el5

Version: # 1 SMP Tue Jan 8 17:53:53 EST 2013

Machine: x86_64

Instance name: ekpj

Redo thread mounted by this instance: 1

Oracle process number: 141

Unix process pid: 6576, image: oracle@ekpdb01

* * 2014-03-17 10 Fran 09MAV 34.361

* SESSION ID: (647.3487) 2014-03-17 10 purl 09purl 34.361

* CLIENT ID: () 2014-03-17 10 purl 09purl 34.361

* SERVICE NAME: (SYS$USERS) 2014-03-17 10 purl 09purl 34.361

* MODULE NAME: (JDBC Thin Client) 2014-03-17 10 purl 09purl 34.361

* ACTION NAME: () 2014-03-17 10 purl 09purl 34.361

-PROTOCOL VIOLATION DETECTED

-Dump Cursor sql_id=9svnzn8h7ac59 xsc=0x2b28a614b380 cur=0x2b28a5ae2d20-

LibraryHandle: Address=3f296060 Hash=206530a9 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD

ObjectName: Name=select joecostpay0_.fd_id as col_0_0_ from ekpj.joe_cost_payment_tem joecostpay0_ left outer join ekpj.joe_payment_tem_areader authallrea1_ on joecostpay0_.fd_id=authallrea1_.fd_doc_id left outer join ekpj.sys_org_element sysorgelem2_ on authallrea1_.fd_org_id=sysorgelem2_.fd_id where joecostpay0_.fd_parent_id=:1 and (joecostpay0_.auth_reader_flag=1 or sysorgelem2_.fd_id in (: 2,: 3,: 4,: 5,: 6 : 7,: 8,: 9,: 10,: 11,: 12)

FullHashValue=e67bc57b362e0f859c6e9fa2206530a9 Namespace=SQL AREA (00) Type=CURSOR (00) Identifier=543502505 OwnerIdn=85

Statistics: InvalidationCount=2 ExecutionCount=1066 LoadCount=33 ActiveLocks=1 TotalLockCount=1001 TotalPinCount=1

Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=5 KeepHandle=5 BucketInUse=1000 HandleInUse=1000

Concurrency: DependencyMutex=3f296110 (0,0,0,0) Mutex=3f296188 (647,0,0,6)

Flags=RON/PIN/TIM/PN0/DBN/ [10012841]

WaitersLists:

Lock=3f2960f0 [3f2960f0,3f2960f0]

Pin=3f296100 [3f2960d0,3f2960d0]

Timestamp: Current=03-03-2014 08:47:44

LibraryObject: Address=db0db418 HeapMask=0000-0001-0001 Flags=EXS [0000] Flags2= [0000] PublicFlags= [0000]

ChildTable: size='16'

Child: id='0' Table=db0dc318 Reference=db0dbd68 Handle=3ce65f10

Child: id='1' Table=db0dc318 Reference=db0dc168 Handle=3f11fe28

Child: id='2' Table=db0dc318 Reference=dbe58aa0 Handle=3fab70a0

Child: id='3' Table=db0dc318 Reference=dbe58e18 Handle=3ebec730

Child: id='4' Table=db0dc318 Reference=a271eed0 Handle=3e7ef458

Child: id='5' Table=db0dc318 Reference=a271f220 Handle=3e477970

Children:

Child: childNum='0'

LibraryHandle: Address=3ce65f10 Hash=0 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD

Name: Namespace=SQL AREA (00) Type=CURSOR (00)

Statistics: InvalidationCount=1 ExecutionCount=2 LoadCount=9 ActiveLocks=0 TotalLockCount=75 TotalPinCount=78

Counters: BrokenCount=2 RevocablePointer=2 KeepDependency=0 KeepHandle=0 BucketInUse=0 HandleInUse=0

Concurrency: DependencyMutex=3ce65fc0 (0,0,0,0) Mutex=3f296188 (647,0,0,6)

Flags=RON/PIN/PN0/EXP/ [10012111]

WaitersLists:

Lock=3ce65fa0 [3ce65fa0,3ce65fa0]

Pin=3ce65fb0 [3ce65f80,3ce65f80]

LibraryObject: Address=a1e87c58 HeapMask=0000-0001-0001 Flags=EXS/RIV [0200] Flags2= [0000] PublicFlags= [0000]

NamespaceDump:

Child Cursor: Heap0=0x3a1e87d40 Heap6=0x43ce65f10 Heap0 Load Time=03-16-2014 11:18:12 Heap6 Load Time=03-16-2014 11:18:12

Child: childNum='1'

LibraryHandle: Address=3f11fe28 Hash=0 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD

Name: Namespace=SQL AREA (00) Type=CURSOR (00)

Statistics: InvalidationCount=1 ExecutionCount=69 LoadCount=8 ActiveLocks=0 TotalLockCount=268 TotalPinCount=283

Counters: BrokenCount=3 RevocablePointer=3 KeepDependency=0 KeepHandle=0 BucketInUse=0 HandleInUse=0

Concurrency: DependencyMutex=3f11fed8 (0,0,0,0) Mutex=3f296188 (647,0,0,6)

Flags=RON/PIN/PN0/EXP/ [10012111]

WaitersLists:

Lock=3f11feb8 [3f11feb8,3f11feb8]

Pin=3f11fec8 [3f11fe98,3f11fe98]

LibraryObject: Address=a27e8c58 HeapMask=0000-0001-0001 Flags=EXS/RIV [0200] Flags2= [0000] PublicFlags= [0000]

NamespaceDump:

Child Cursor: Heap0=0x3a27e8d40 Heap6=0x3658a19c8 Heap0 Load Time=03-14-2014 13:10:31 Heap6 Load Time=03-15-2014 09:27:44

Child: childNum='2'

LibraryHandle: Address=3fab70a0 Hash=0 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD

Name: Namespace=SQL AREA (00) Type=CURSOR (00)

Statistics: InvalidationCount=0 ExecutionCount=2 LoadCount=7 ActiveLocks=0 TotalLockCount=375 TotalPinCount=408

Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 KeepHandle=0 BucketInUse=0 HandleInUse=0

Concurrency: DependencyMutex=3fab7150 (0,0,0,0) Mutex=3f296188 (647,0,0,6)

Flags=RON/PIN/PN0/EXP/ [10012111]

WaitersLists:

Lock=3fab7130 [3fab7130,3fab7130]

Pin=3fab7140 [3fab7110,3fab7110]

LibraryObject: Address=a095ca00 HeapMask=0000-0001-0001 Flags=EXS/RIV [0200] Flags2= [0000] PublicFlags= [0000]

NamespaceDump:

Child Cursor: Heap0=0x3a095cae8 Heap6=0x3646999c8 Heap0 Load Time=03-15-2014 09:12:52 Heap6 Load Time=03-15-2014 09:12:52

Child: childNum='3'

LibraryHandle: Address=3ebec730 Hash=0 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD

Name: Namespace=SQL AREA (00) Type=CURSOR (00)

Statistics: InvalidationCount=0 ExecutionCount=22 LoadCount=5 ActiveLocks=0 TotalLockCount=238 TotalPinCount=254

Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 KeepHandle=0 BucketInUse=0 HandleInUse=0

Concurrency: DependencyMutex=3ebec7e0 (0,0,0,0) Mutex=3f296188 (647,0,0,6)

Flags=RON/PIN/PN0/EXP/ [10012111]

WaitersLists:

Lock=3ebec7c0 [3ebec7c0,3ebec7c0]

Pin=3ebec7d0 [3ebec7a0,3ebec7a0]

LibraryObject: Address=db4a1060 HeapMask=0000-0001-0001 Flags=EXS [0000] Flags2= [0000] PublicFlags= [0000]

NamespaceDump:

Child Cursor: Heap0=0x3db4a1148 Heap6=0x37aa71590 Heap0 Load Time=03-16-2014 12:08:07 Heap6 Load Time=03-17-2014 10:09:33

Child: childNum='4'

LibraryHandle: Address=3e7ef458 Hash=0 LockMode=N PinMode=S LoadLockMode=0 Status=VALD

Name: Namespace=SQL AREA (00) Type=CURSOR (00)

Statistics: InvalidationCount=0 ExecutionCount=1 LoadCount=2 ActiveLocks=1 TotalLockCount=22 TotalPinCount=25

Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 KeepHandle=0 BucketInUse=0 HandleInUse=0

Concurrency: DependencyMutex=3e7ef508 (0,0,0,0) Mutex=3f296188 (647,0,0,6)

Flags=RON/PIN/PN0/EXP/ [10012111]

WaitersLists:

Lock=3e7ef4e8 [3e7ef4e8,3e7ef4e8]

Pin=3e7ef4f8 [3e7ef4c8,3e7ef4c8]

LibraryObject: Address=d9412938 HeapMask=0000-0001-0001 Flags=EXS [0000] Flags2= [0000] PublicFlags= [0000]

DataBlocks:

Block: # ='0' name= CCR ^ 206530a9 pins=0 Change=NONE

Heap=73b473c0 Pointer=d9412a20 Extent=d9412908 Flags=I/-/P/A/-/-

FreedLocation=0 Alloc=7.085938 Size=7.898438 LoadTime=6566111700

Block: # ='6' name= SQL ^ 206530a9 pins=0 Change=NONE

Heap=a271ed70 Pointer=6490fc90 Extent=6490f030 Flags=I/-/P/A/-/E

FreedLocation=0 Alloc=23.523438 Size=23.742188 LoadTime=0

NamespaceDump:

Child Cursor: Heap0=0x3d9412a20 Heap6=0x36490fc90 Heap0 Load Time=03-17-2014 10:09:33 Heap6 Load Time=03-17-2014 10:09:33

Child: childNum='5'

LibraryHandle: Address=3e477970 Hash=0 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD

Name: Namespace=SQL AREA (00) Type=CURSOR (00)

Statistics: InvalidationCount=0 ExecutionCount=112 LoadCount=1 ActiveLocks=0 TotalLockCount=104 TotalPinCount=115

Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 KeepHandle=0 BucketInUse=0 HandleInUse=0

Concurrency: DependencyMutex=3e477a20 (0,0,0,0) Mutex=3f296188 (647,0,0,6)

Flags=RON/PIN/PN0/EXP/ [10010110]

WaitersLists:

Lock=3e477a00 [3e477a00,3e477a00]

Pin=3e477a10 [3e4779e0,3e4779e0]

ObjectFreed=last freed from HPD addn data CBK

NamespaceDump:

Child Cursor: Heap0=0xa99d540 Heap6=0x43e477970 Heap0 Load Time=20-70 Mustang 5947 254 Heap6 Load Time=00 1 Heap6 Load Time=00-00 Mustang 100-100-1

NamespaceDump:

Parent Cursor: sql_id=9svnzn8h7ac59 parent=0x3db0db500 maxchild=6 plk=y ppn=n

Current Cursor Sharing Diagnostics Nodes:

Child Node: 1 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 1 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1394899703

Ksugctm (): 1394939892

Child Node: 5 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 5 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1394501245

Ksugctm (): 1394501311

Child Node: 3 ID=40 reason=Bind mismatch (33) size=2x4

Init ranges in first pass: 1

Selectivity: 0

Child Node: 0 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 2 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Aged Out Cursor Sharing Diagnostic Nodes:

Child Node: 4 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1394417045

Ksugctm (): 1394417200

Child Node: 4 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 3 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1394769934

Ksugctm (): 1394772759

Child Node: 3 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 0 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 2 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 1 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1394645200

Ksugctm (): 1394669548

Child Node: 1 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 0 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 3 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1394249253

Ksugctm (): 1394249311

Child Node: 3 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 2 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1394590329

Ksugctm (): 1394590342

Child Node: 2 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 1 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 0 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 2 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 1 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1394334468

Ksugctm (): 1394348237

Child Node: 1 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 0 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 2 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1394167585

Ksugctm (): 1394167981

Child Node: 2 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 1 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 0 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 2 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 1 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 0 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 2 ID=34 reason=Rolling Invalidate Window Exceeded (3) size=2x4

Invalidation window (kglobitm): 1393907782

Ksugctm (): 1393910621

Child Node: 2 ID=34 reason=Rolling Invalidate Window Exceeded (2) size=0x0

Already processed:

Child Node: 1 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing:

Child Node: 0 ID=40 reason=Bind mismatch (25) size=0x0

Extended cursor sharing: kkscs=0x3db0dba08 nxt=0x3db0dbed8 flg=1b cld=0 hd=0x43ce65f10 par=0x3db0db500

Mutex 0x3db0dba08 (0,0) idn 3000000000

Ct=1e hsh=0 unp= (nil) unn=0 hvl=a271fbd0 nhv=0 ses= (nil)

Hep=0x3db0dba98 flg=80 ld=0 ob= (nil) ptr= (nil) fex= (nil)

Kkscs=0x3db0dbed8 nxt=0x3dbe58810 flg=18 cld=1 hd=0x43f11fe28 par=0x3db0db500

Mutex 0x3db0dbed8 (0,0) idn 0

Ct=1d hsh=0 unp= (nil) unn=0 hvl=a271fbb0 nhv=0 ses= (nil)

Hep=0x3db0dbf68 flg=80 ld=1 ob=0x3a27e8c58 ptr=0x3658a19c8 fex=0x3658a0d68

Kkscs=0x3dbe58810 nxt=0x3dbe58b88 flg=1a cld=2 hd=0x43fab70a0 par=0x3db0db500

Mutex 0x3dbe58810 (0,0) idn 300000000

Ct=1c hsh=0 unp= (nil) unn=0 hvl=dbe58fe8 nhv=0 ses= (nil)

Hep=0x3dbe588a0 flg=80 ld=1 ob=0x3a095ca00 ptr=0x3646999c8 fex=0x364698d68

Kkscs=0x3dbe58b88 nxt=0x3a271ec40 flg=14 cld=3 hd=0x43ebec730 par=0x3db0db500

Mutex 0x3dbe58b88 (0,0) idn 300000000

Ct=20 hsh=0 unp= (nil) unn=0 hvl=db0dc3b0 nhv=1 ses=0x448859c30

Hsv [0] = 0

Hep=0x3dbe58c18 flg=80 ld=1 ob=0x3db4a1060 ptr=0x37aa71590 fex=0x37aa70930

Kkscs=0x3a271ec40 nxt=0x3a271ef90 flg=18 cld=4 hd=0x43e7ef458 par=0x3db0db500

Mutex 0x3a271ec40 (0,0) idn 300000000

Ct=21 hsh=0 unp= (nil) unn=0 hvl=db0dc2f8 nhv=0 ses= (nil)

Hep=0x3a271ecd0 flg=80 ld=1 ob=0x3d9412938 ptr=0x36490fc90 fex=0x36490f030

Kkscs=0x3a271ef90 nxt= (nil) flg=19 cld=5 hd=0x43e477970 par=0x3db0db500

Mutex 0x3a271ef90 (0,0) idn 300000000

Ct=13 hsh=0 unp= (nil) unn=0 hvl=db0dc2d8 nhv=0 ses= (nil)

Hep=0x3a271f020 flg=80 ld=0 ob= (nil) ptr= (nil) fex= (nil)

Cursor instantiation=0x2b28a614b380 used=1395022173 exec_id=16778281 exec=1

Child#4 (0x43e7ef458) pcs=0x3a271ec40

Clk=0x43a967e08 ci=0x3d9412a20 pn=0x43ba9a118 ctx=0x36490fc90

Kgsccflg=0 llk [0x2b28a614b388,0x2b28a614b388] idx=0

Xscflg=c0110676 fl2=5d000008 fl3=42222008 fl4=180

Sharing failure (s) = 800000040000

-Bind Info (kkscoacd)-

Bind#0

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=1536 off=0

Kxsbbbfp=2b28a60537f0 bln=128 avl=00 flg=05

Bind#1

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=128

Kxsbbbfp=2b28a6053870 bln=128 avl=00 flg=01

Bind#2

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=256

Kxsbbbfp=2b28a60538f0 bln=128 avl=00 flg=01

Bind#3

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=384

Kxsbbbfp=2b28a6053970 bln=128 avl=00 flg=01

Bind#4

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=512

Kxsbbbfp=2b28a60539f0 bln=128 avl=00 flg=01

Bind#5

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=640

Kxsbbbfp=2b28a6053a70 bln=128 avl=00 flg=01

Bind#6

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=768

Kxsbbbfp=2b28a6053af0 bln=128 avl=00 flg=01

Bind#7

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=896

Kxsbbbfp=2b28a6053b70 bln=128 avl=00 flg=01

Bind#8

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=1024

Kxsbbbfp=2b28a6053bf0 bln=128 avl=00 flg=01

Bind#9

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=1152

Kxsbbbfp=2b28a6053c70 bln=128 avl=00 flg=01

Bind#10

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=1280

Kxsbbbfp=2b28a6053cf0 bln=128 avl=00 flg=01

Bind#11

Oacdty=01 mxl=128 (64) mxlc=00 mal=00 scl=00 pre=00

Oacflg=03 fl2=1000010 frm=01 csi=852 siz=0 off=1408

Kxsbbbfp=2b28a6053d70 bln=128 avl=00 flg=01

Frames pfr 0x2b28a5b09500 siz=10080 efr 0x2b28a5b09440 siz=10064

Kxscphp=0x2b28a5f0df68 siz=984 inu=552 nps=328

Kxscbhp=0x2b28a5f7e5f8 siz=2544 inu=2032 nps=1560

Kxscwhp=0x2b28a5f2e508 siz=4056 inu=56 nps=0

Starting SQL statement dump

SQL Information

User_id=85 user_name=EKPJ module=JDBC Thin Client action=

Sql_id=9svnzn8h7ac59 plan_hash_value=-892795830 problem_type=4

-Current SQL Statement for this session (sql_id=9svnzn8h7ac59)-

Select joecostpay0_.fd_id as col_0_0_ from ekpj.joe_cost_payment_tem joecostpay0_ left outer join ekpj.joe_payment_tem_areader authallrea1_ on joecostpay0_.fd_id=authallrea1_.fd_doc_id left outer join ekpj.sys_org_element sysorgelem2_ on authallrea1_.fd_org_id=sysorgelem2_.fd_id where joecostpay0_.fd_parent_id=:1 and (joecostpay0_.auth_reader_flag=1 or sysorgelem2_.fd_id in (: 2,: 3,: 4,: 5,: 6 : 7,: 8,: 9,: 10,: 11,: 12)

Sql_text_length=448

Sql=select joecostpay0_.fd_id as col_0_0_ from ekpj.joe_cost_payment_tem joecostpay0_ left outer join ekpj.joe_payment_tem_areader authallrea1_ on joecostpay0_.fd_id=authallrea1_.fd_doc_id left outer join ekpj.sys_org_element sysorgelem2_ on authallrea1_.fd_or

Sql=g_id=sysorgelem2_.fd_id where joecostpay0_.fd_parent_id=:1 and (joecostpay0_.auth_reader_flag=1 or sysorgelem2_.fd_id in (: 2,: 3,: 4,: 5,: 6,: 7,: 8,: 9,: 10,: 11,: 12)

Compilation Environment Dump

Optimizer_mode_hinted = false

Optimizer_features_hinted = 0.0.0

Parallel_execution_enabled = true

Parallel_query_forced_dop = 0

Parallel_dml_forced_dop = 0

Parallel_ddl_forced_degree = 0

Parallel_ddl_forced_instances = 0

_ query_rewrite_fudge = 90

Optimizer_features_enable = 11.1.0.7

_ optimizer_search_limit = 5

Cpu_count = 16

Active_instance_count = 1

Parallel_threads_per_cpu = 2

Hash_area_size = 131072

Bitmap_merge_area_size = 1048576

Sort_area_size = 65536

Sort_area_retained_size = 0

_ sort_elimination_cost_ratio = 0

_ optimizer_block_size = 8192

_ sort_multiblock_read_count = 2

_ hash_multiblock_io_count = 0

_ db_file_optimizer_read_count = 8

_ optimizer_max_permutations = 2000

Pga_aggregate_target = 5701632 KB

_ pga_max_size = 1140320 KB

_ query_rewrite_maxdisjunct = 257

_ smm_auto_min_io_size = 56 KB

_ smm_auto_max_io_size = 248KB

_ smm_min_size = 1024 KB

_ smm_max_size = 570160 KB

_ smm_px_max_size = 2850816 KB

_ cpu_to_io = 0

_ optimizer_undo_cost_change = 11.1.0.7

Parallel_query_mode = enabled

Parallel_dml_mode = disabled

Parallel_ddl_mode = enabled

Optimizer_mode = all_rows

Sqlstat_enabled = false

_ optimizer_percent_parallel = 101

_ always_anti_join = choose

_ always_semi_join = choose

_ optimizer_mode_force = true

_ partition_view_enabled = true

_ always_star_transformation = false

_ query_rewrite_or_error = false

_ hash_join_enabled = true

Cursor_sharing = exact

_ b_tree_bitmap_plans = true

Star_transformation_enabled = false

_ optimizer_cost_model = choose

_ new_sort_cost_estimate = true

_ complex_view_merging = true

_ unnest_subquery = true

_ eliminate_common_subexpr = true

_ pred_move_around = true

_ convert_set_to_join = false

_ push_join_predicate = true

_ push_join_union_view = true

_ fast_full_scan_enabled = true

_ optim_enhance_nnull_detection = true

_ parallel_broadcast_enabled = true

_ px_broadcast_fudge_factor = 100

_ ordered_nested_loop = true

_ no_or_expansion = false

Optimizer_index_cost_adj = 100

Optimizer_index_caching = 0

_ system_index_caching = 0

_ disable_datalayer_sampling = false

Query_rewrite_enabled = true

Query_rewrite_integrity = enforced

_ query_cost_rewrite = true

_ query_rewrite_2 = true

_ query_rewrite_1 = true

_ query_rewrite_expression = true

_ query_rewrite_jgmigrate = true

_ query_rewrite_fpc = true

_ query_rewrite_drj = true

_ full_pwise_join_enabled = true

_ partial_pwise_join_enabled = true

_ left_nested_loops_random = true

_ improved_row_length_enabled = true

_ index_join_enabled = true

_ enable_type_dep_selectivity = true

_ improved_outerjoin_card = true

_ optimizer_adjust_for_nulls = true

_ optimizer_degree = 0

_ use_column_stats_for_function = true

_ subquery_pruning_enabled = true

_ subquery_pruning_mv_enabled = false

_ or_expand_nvl_predicate = true

_ like_with_bind_as_equality = false

_ table_scan_cost_plus_one = true

_ cost_equality_semi_join = true

_ default_non_equality_sel_check = true

_ new_initial_join_orders = true

_ oneside_colstat_for_equijoins = true

_ optim_peek_user_binds = true

_ minimal_stats_aggregation = true

_ force_temptables_for_gsets = false

Workarea_size_policy = auto

_ smm_auto_cost_enabled = true

_ gs_anti_semi_join_allowed = true

_ optim_new_default_join_sel = true

Optimizer_dynamic_sampling = 2

_ pre_rewrite_push_pred = true

_ optimizer_new_join_card_computation = true

_ union_rewrite_for_gs = yes_gset_mvs

_ generalized_pruning_enabled = true

_ optim_adjust_for_part_skews = true

_ force_datefold_trunc = false

Statistics_level = typical

_ optimizer_system_stats_usage = true

Skip_unusable_indexes = true

_ remove_aggr_subquery = true

_ optimizer_push_down_distinct = 0

_ dml_monitoring_enabled = true

_ optimizer_undo_changes = false

_ predicate_elimination_enabled = true

_ nested_loop_fudge = 100

_ project_view_columns = true

_ local_communication_costing_enabled = true

_ local_communication_ratio = 50

_ query_rewrite_vop_cleanup = true

_ slave_mapping_enabled = true

_ optimizer_cost_based_transformation = linear

_ optimizer_mjc_enabled = true

_ right_outer_hash_enable = true

_ spr_push_pred_refspr = true

_ optimizer_cache_stats = false

_ optimizer_cbqt_factor = 50

_ optimizer_squ_bottomup = true

_ fic_area_size = 131072

_ optimizer_skip_scan_enabled = true

_ optimizer_cost_filter_pred = false

_ optimizer_sortmerge_join_enabled = true

_ optimizer_join_sel_sanity_check = true

_ mmv_query_rewrite_enabled = true

_ bt_mmv_query_rewrite_enabled = true

_ add_stale_mv_to_dependency_list = true

_ distinct_view_unnesting = false

_ optimizer_dim_subq_join_sel = true

_ optimizer_disable_strans_sanity_checks = 0

_ optimizer_compute_index_stats = true

_ push_join_union_view2 = true

_ optimizer_ignore_hints = false

_ optimizer_random_plan = 0

_ query_rewrite_setopgrw_enable = true

_ optimizer_correct_sq_selectivity = true

_ disable_function_based_index = false

_ optimizer_join_order_control = 3

_ optimizer_cartesian_enabled = true

_ optimizer_starplan_enabled = true

_ extended_pruning_enabled = true

_ optimizer_push_pred_cost_based = true

_ optimizer_null_aware_antijoin = true

_ optimizer_extend_jppd_view_types = true

_ sql_model_unfold_forloops = run_time

_ enable_dml_lock_escalation = false

_ bloom_filter_enabled = true

_ update_bji_ipdml_enabled = 0

_ optimizer_extended_cursor_sharing = udo

_ dm_max_shared_pool_pct = 1

_ optimizer_cost_hjsmj_multimatch = true

_ optimizer_transitivity_retain = true

_ px_pwg_enabled = true

Optimizer_secure_view_merging = true

_ optimizer_join_elimination_enabled = true

Flashback_table_rpi = non_fbt

_ optimizer_cbqt_no_size_restriction = true

_ optimizer_enhanced_filter_push = true

_ optimizer_filter_pred_pullup = true

_ rowsrc_trace_level = 0

_ simple_view_merging = true

_ optimizer_rownum_pred_based_fkr = true

_ optimizer_better_inlist_costing = all

_ optimizer_self_induced_cache_cost = false

_ optimizer_min_cache_blocks = 10

_ optimizer_or_expansion = depth

_ optimizer_order_by_elimination_enabled = true

_ optimizer_outer_to_anti_enabled = true

_ selfjoin_mv_duplicates = true

_ dimension_skip_null = true

_ force_rewrite_enable = false

_ optimizer_star_tran_in_with_clause = true

_ optimizer_complex_pred_selectivity = true

_ optimizer_connect_by_cost_based = true

_ gby_hash_aggregation_enabled = true

_ globalindex_pnum_filter_enabled = true

_ px_minus_intersect = true

_ fix_control_key = 0

_ force_slave_mapping_intra_part_loads = false

_ force_tmp_segment_loads = false

_ query_mmvrewrite_maxpreds = 10

_ query_mmvrewrite_maxintervals = 5

_ query_mmvrewrite_maxinlists = 5

_ query_mmvrewrite_maxdmaps = 10

_ query_mmvrewrite_maxcmaps = 20

_ query_mmvrewrite_maxregperm = 512

_ query_mmvrewrite_maxmergedcmaps = 50

_ query_mmvrewrite_maxqryinlistvals = 500

_ disable_parallel_conventional_load = false

_ trace_virtual_columns = false

_ replace_virtual_columns = true

_ virtual_column_overload_allowed = true

_ kdt_buffering = true

_ first_k_rows_dynamic_proration = true

_ optimizer_sortmerge_join_inequality = true

_ optimizer_aw_stats_enabled = true

_ bloom_pruning_enabled = true

Result_cache_mode = MANUAL

_ px_ual_serial_input = true

_ optimizer_skip_scan_guess = false

_ enable_row_shipping = true

_ row_shipping_threshold = 80

_ row_shipping_explain = false

Transaction_isolation_level = read_commited

_ optimizer_distinct_elimination = true

_ optimizer_multi_level_push_pred = true

_ optimizer_group_by_placement = true

_ optimizer_rownum_bind_default = 10

_ enable_query_rewrite_on_remote_objs = true

_ optimizer_extended_cursor_sharing_rel = simple

_ optimizer_adaptive_cursor_sharing = true

_ direct_path_insert_features = 0

_ optimizer_improve_selectivity = true

Optimizer_use_pending_statistics = false

_ optimizer_enable_density_improvements = true

_ optimizer_aw_join_push_enabled = true

_ optimizer_connect_by_combine_sw = true

_ enable_pmo_ctas = 0

_ optimizer_native_full_outer_join = force

_ bloom_predicate_enabled = true

_ optimizer_enable_extended_stats = true

_ is_lock_table_for_ddl_wait_lock = 0

_ pivot_implementation_method = choose

Optimizer_capture_sql_plan_baselines = false

Optimizer_use_sql_plan_baselines = true

_ optimizer_star_trans_min_cost = 0

_ optimizer_star_trans_min_ratio = 0

_ with_subquery = OPTIMIZER

_ optimizer_fkr_index_cost_bias = 10

_ optimizer_use_subheap = true

Parallel_degree_policy = manual

Parallel_degree = 0

Parallel_min_time_threshold = 10

_ parallel_time_unit = 10

_ optimizer_or_expansion_subheap = true

_ optimizer_free_transformation_heap = true

_ optimizer_reuse_cost_annotations = true

_ result_cache_auto_size_threshold = 100

_ result_cache_auto_time_threshold = 1000

_ optimizer_nested_rollup_for_gset = 100

_ nlj_batching_enabled = 1

Parallel_query_default_dop = 0

Is_recur_flags = 0

Optimizer_use_invisible_indexes = false

Flashback_data_archive_internal_cursor = 0

_ optimizer_extended_stats_usage_control = 224

_ parallel_syspls_obey_force = true

Cell_offload_processing = true

_ rdbms_internal_fplib_enabled = false

Db_file_multiblock_read_count = 128,

_ bloom_folding_enabled = true

_ mv_generalized_oj_refresh_opt = true

Cell_offload_compaction = ADAPTIVE

Parallel_degree_limit = 65535

Parallel_force_local = false

Parallel_max_degree = 32

Total_cpu_count = 16

Cell_offload_plan_display = AUTO

_ optimizer_coalesce_subqueries = false

_ optimizer_fast_pred_transitivity = false

_ optimizer_fast_access_pred_analysis = false

_ optimizer_unnest_disjunctive_subq = false

_ optimizer_unnest_corr_set_subq = false

_ optimizer_distinct_agg_transform = false

_ aggregation_optimization_settings = 32

_ optimizer_connect_by_elim_dups = false

_ optimizer_eliminate_filtering_join = false

_ connect_by_use_union_all = old_plan_mode

Dst_upgrade_insert_conv = true

Advanced_queuing_internal_cursor = 0

_ optimizer_unnest_all_subqueries = true

_ bloom_predicate_pushdown_to_storage = true

_ bloom_vector_elements = 0

_ bloom_pushing_max = 524288

Parallel_autodop = 0

Parallel_ddldml = 0

_ parallel_cluster_cache_policy = adaptive

_ parallel_scalability = 50

Iot_internal_cursor = 0

_ optimizer_instance_count = 0

_ optimizer_connect_by_cb_whr_only = false

_ suppress_scn_chk_for_cqn = nosuppress_1466

_ optimizer_join_factorization = false

_ optimizer_use_cbqt_star_transformation = false

_ optimizer_table_expansion = false

_ and_pruning_enabled = false

_ deferred_constant_folding_mode = DEFAULT

_ optimizer_distinct_placement = false

Partition_pruning_internal_cursor = 0

Parallel_hinted = none

_ sql_compatibility = 0

_ optimizer_use_feedback = false

_ optimizer_try_st_before_jppd = false

= = END SQL Statement Dump = =

Ttcdrvdmplocation: msg-32 ln-1004 reporting 12333

Dumping 'Buffer dump info:' addr=0x1e66bda0 size=713 bytes

Dump of memory from 0x1e66bda0 to 0x1e66c06c

01E66BDA0 02005E03 01002980 01BF0102 00000D01 [.^...)]

01E66BDB0 FFFFFF04 040A01FF FFFFFF7F 000C0101 [.]

01E66BDC0 00000000 00000000 00000001 40FE0000 [. @]

01E66BDD0 656C6573 6A207463 6F63656F 61707473 [select joecostpa]

01E66BDE0 2E5F3079 695F6466 73612064 6C6F6320 [y0_.fd_id as col]

01E66BDF0 305F305F 7266205F 65206D6F 2E6A706B [_ 0_0_ from ekpj.]

01E66BE00 5F656F6A 74736F63 7961705F 746E656D [joe_cost_payment]

01E66BE10 65745F40 6F6A206D 736F6365 79617074 [@ _ tem joecostpay]

01E66BE20 6C205F30 20746665 6574756F 6F6A2072 [0_ left outer jo]

01E66BE30 65206E69 2E6A706B 5F656F6A 6D796170 [in ekpj.joe_paym]

01E66BE40 5F746E65 5F6D6574 61657261 20726564 [ent_tem_areader]

01E66BE50 74754061 6C6C6168 31616572 6E6F205F [axiuthallrea1 _ on]

01E66BE60 656F6A20 74736F63 30796170 64662E5F [joecostpay0_.fd]

01E66BE70 3D64695F 68747561 726C6C61 5F316165 [_ id=authallrea1_]

Problem analysis:

Use the prompts on Metalink to get the possible cause of the error:

1. Some versions of the JDBC driver will cause this error:

Bug 9445675 NO MORE DATA TO READ FROM SOCKET WHEN USING END-TO-END METRICS

This bug does affect the JDBC driver. This bug may be the cause when all of the following conditions are met:

You are using the 10.1.x.x or the 11.2.0.1 JDBC driver; the bug does not affect 10.2.x.x, or 11.1.x.x versions of the driver, nor versions 11.2.0.2 or aboveYou are using end-to-end metrics in your Java codeThe server side ORA-3137 [12333] error is accompanied by the client side Java exception "No more data to read from socket"

This bug is fixed in the 11.2.0.2 version of the JDBC driver and above. It is discussed in the following notes:

Note 9445675.8 Bug 9445675-"No more data" / ORA-3137 using end to end metrics with JDBC Thin

Note 1081275.1 "java.sql.SQLRecoverableException: No more data to read from socket" is Thrown When End-to-end Metrics is Used

2. The BUG of the database itself will also cause this error:

Unpublished Bug:9703463-ORA-3137 [12333] or ORA-600 [kpobav-1] When Using Bind Peeking

This bug affects versions 11.1.0.6, 11.1.0.7, and 11.2.0.1 of the RDBMS. It is fixed in version 11.2.0.2 of the database.

It can also occur intermittently; similarly to unpublished Bug:8625762, this is a bind peeking bug.

=

Unpublished Bug 9373370 DATA BASE RETURNS WRONG CURSORID WHEN THERE IS AN ORA-01013

This bug affects the 10.2, 11.1, 11.2.0.1, and 11.2.0.2 databases. It is discussed in the following note:

Note 9373370.8 Bug 9373370-The wrong cursor may be executed by JDBC thin following a query timeout / ORA-3137 [12333]

While the bug primarily manifests in ORA-1006 or ORA-1008 errors, the problem may also result in ORA-600 [12333] or ORA-3137 [12333] errors appearing on the server side.

Solution:

It is preliminarily judged that the current error is caused by jdbc. It just so happens that the company still has a database of 11.2.0.3, so go to the directory / u01/app/oracle/product/OraDb11g_home1/jdbc/lib, then download ojdbc6.jar and update it.

-

IT technician's ideal development curve: technician-technical management-operation management-enterprise strategy

Personal concept: not to do simple technology, technology to do management technology

ORACLE Technical Management QQ Group: 367875324

-

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.