Re: Pin S wit on X
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Message-ID | <[email protected]> |
> Hi, > > Could somebody help me with deal with PIN S WAIT ON X. This wait event has > too high values and is impacting with my normal operation. > > > SLES9 and Oracle 10GR2. There is a lot of bugs reported on this event if you query Metalink. Many of the bugs has something to do with gathering optimizer statistics. Just by entering the event name I get 81 hits - most of them bug and many problem describtions refering to bugs. Given the bug-centric result I can only recommend that you query Metalink and compare the bug scenarios with your environment - or even create a SR. (Had the query result been more directed towards tuning tasks it would have been easier to give you some suggestions for the process to follow for investigation) Martin Berg Martin Berg Consult ApS mobile: +45 30 35 58 68 web: www.berg-consult.com _______________________________________________ suse-sles-e mailing list [email protected] http://listx.novell.com/mailman/listinfo/suse-sles-e