LoadRowForGBY, PTInsertURowForGBY
- From: przemolicc@xxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 1 Aug 2012 12:55:43 +0200
Hi all,
we have been facing some performance problems on Solaris 10 server running
Oracle 10.2.0.5.
There is high syscall time during the problems involving system page faults.
During these page faults I was able to catch stack of Oracle processes:
oracle`qeshsFindFreeSlot+0xe0
oracle`qeshfFindFreeSlot+0xc
oracle`qeshBufferAlloc+0x110
oracle`qeshPTInsertURowForGBY+0x1b4
oracle`qeshLoadRowForGBY+0x360
or
oracle`klmalf+0x48
oracle`kllcqas+0xc0
oracle`kcblasm1+0x34
oracle`kxhfFndFreeSlot+0xe4
oracle`kxhfNewBuffer+0x2c
oracle`qerhjGetNewBuffer+0x24
oracle`ksxb1bqb+0xd0
oracle`kxhrPack+0x450
oracle`qerhjSplitBuild+0x11c
oracle`qerixFetchUniqueIndex+0x36c
oracle`qerjotFetch+0xbc
oracle`rwsfcd+0x78
oracle`qerhjFetch+0x3f0
oracle`rwsfcd+0x78
oracle`qerhjFetch+0x3f0
oracle`rwsfcd+0x78
oracle`qerhjFetch+0x3f0
oracle`rwsfcd+0x78
oracle`qerhjFetch+0x3f0
or
oracle`klmalf+0x48
oracle`kllcqas+0xc0
oracle`kcblasm1+0x34
oracle`kxhfFndFreeSlot+0xe4
oracle`kxhfNewBuffer+0x2c
oracle`qerhjGetNewBuffer+0x24
oracle`ksxb1bqb+0xd0
oracle`kxhrPack+0x450
oracle`qerhjSplitBuild+0x11c
oracle`qerhjWalkHashBucket+0x13c
oracle`kdstf0000101km+0x190
oracle`kdsttgr+0x8f44
oracle`qertbFetch+0x2c4
oracle`rwsfcd+0x78
oracle`qerhjFetch+0x1b0
oracle`rwsfcd+0x78
oracle`qerhjFetch+0x3f0
oracle`rwsfcd+0x78
oracle`qerhjFetch+0x3f0
or
oracle`qerhjadf+0x44
oracle`qerhjBuildHashTable+0x54c
oracle`qerhjInnerProbeHashTable+0x274
oracle`qergsFetch+0x370
oracle`qervwFetch+0x98
oracle`rwsfcd+0x78
oracle`qerhjFetch+0x1b0
oracle`qerjotFetch+0x104
oracle`qerghFetch+0x500
oracle`rwsfcd+0x78
oracle`insfch+0x84
oracle`insdrv+0x240
oracle`inscovexe+0x32c
oracle`insExecStmtExecIniEngine+0x50
oracle`insexe+0x218
oracle`opiexe+0x2dc4
oracle`opipls+0x844
oracle`opiodr+0x600
oracle`rpidrus+0xc4
oracle`skgmstack+0xa8
Can abybody shed a light what it might be on Oracle ? Where should our DBA look
for ?
Regards
Przemyslaw Bak (przemol)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
