LoadRowForGBY, PTInsertURowForGBY
From: <przemolicc_at_poczta.fm>
Date: Wed, 1 Aug 2012 12:55:43 +0200
Message-ID: <20120801105543.GA8842_at_host.pgf.com.pl>
Hi all,
Date: Wed, 1 Aug 2012 12:55:43 +0200
Message-ID: <20120801105543.GA8842_at_host.pgf.com.pl>
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)
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 01 2012 - 05:55:43 CDT