RE: cursor: pin S - mutex Wait - in Benchmark
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Nov 2006 14:51:54 +0530
Folks
As part of a 2 node RAC performance benchmark, DB Server nodes are
choking at 100% CPU Usage, when 3000 dedicated server sessions are doing
OLTP transactions
Config:-
DB Servers - 2 RAC Nodes - 8 CPUs HP Itanium 2,1.6 Ghz with 48GB Memory
HP-UX ver B11.23
Storage XP12000 - 512 Disks
Disk 146 GB - 15 RPM
RAID 0/1
Oracle 10.2.0.2
Qs 1 - Do we need to Tune the below TOP resource consuming SQL Queries?
Qs 2 - Will Data partitioning Help i.e. Manually segregate Transactions
so that they access Different oracle BLOCKS from different RAC Nodes ?
Qs 3 - Any init.ora parameters advisable? Will setting
shared_pool_reserved_size help? (shared_pool_size = 1610612736)
Qs 4 - Any other ideas, Links / Docs for the same?
Thanks indeed
statspack parts (node 2)
Top 5 Timed Events
Avg %Total
~~~~~~~~~~~~~~~~~~
wait Call
Event Waits Time (s)
(ms) Time
----------------------------------------- ------------ -----------
------ ------
cursor: pin S 7,344,257 18,803
3 33.1
row cache lock 6,966 9,349
1342 16.5
latch: cache buffers chains 179,722 9,074
50 16.0
gc buffer busy 41,444 4,434
107 7.8
enq: US - contention 11,925 3,153
264 5.6
-------------------------------------------------------------
(Will share the detailed Statspack report, if needed.)
http://www.archivesat.com/oracle-l/thread654297.htm
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is not
liable for any damage you may sustain as a result of any virus in this e-mail.
You should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Other related posts:
