10.2.0.4 Database Performance Issues ( cursor: pin S wait on X ) on AIX 5.3
From: Balakrishna Y <krishna000_at_gmail.com>
Date: Tue, 24 Nov 2009 10:46:48 +0530
Message-ID: <e53436b70911232116h36ff995br59942eba89b16a6a_at_mail.gmail.com>
Hi All,
Date: Tue, 24 Nov 2009 10:46:48 +0530
Message-ID: <e53436b70911232116h36ff995br59942eba89b16a6a_at_mail.gmail.com>
Hi All,
We have recently upgraded our Production Database to 10.2.0.4 from 10.2.0.2 . It is observed that our performance is getting hampered with* latch: library cache, latch: library cache Lock , cursor: pin S wait on X .
**Did any one come accross these problems after upgrading to 10.2.0.4 . Your
comments is higly appreciated please.
Regards
Bala
*
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 23 2009 - 23:16:48 CST