Following last night's presso from Nathan and Andre (thanks very much for another interesting night) -
Yesterday one of our DBAs was complaining about IO performance and supplied two PIDs to look at from the OS. (Thanks!) Although vxstat/iostat on the diskgroup/associated LUNs showed a consistently large number of write IOPS, response times were always low. The oracle processes had >200 LWPs, and running a prstat -mL -p <PID> showed that at all times, every thread bar one spent 98% of its time in LCK. Any speculation? Regards, Alex Disclaimer: The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your computer. Privacy: If you are responding to this email or providing personal information to the SRO for the purposes of one of the Acts it administers, such information is used only for the purpose for which it was collected (administration of SRO legislation ) and is protected by the Information Privacy Act 2000 and secrecy provisions contained in legislation administered by SRO. It is not disclosed otherwise than in accordance with the law. If you would like a copy of the SRO Privacy Policy please refer to SRO website (www.sro.vic.gov.au) or contact SRO on 13 21 61 and request a copy. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.opensolaris.org/pipermail/ug-msosug/attachments/20090917/36bfcc80/attachment.html>
