10.2.0.4 Patch + CPU 24
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Nov 2009 14:15:51 -0600
Hey guys/gals,
We patched to 10.2.0.4 this weekend and CPU patch 24.
Today, we had a query go into a spin. It said it was waiting on SQL*Net
message to Client, but the I/O [Consistent Gets] were spinning upward at a
dizzying pace while it was "waiting".
The query was a simple join with a "WHERE EXISTS" statement.
We had 2 Function based indexes involved in the query - one with a SUBSTR and
one with a TRUNC.
I dropped both of those after verifying a different execution plan and
performance went back to normal (1-2 second total time).
Anyone run into performance problems with latches or anything when going to
10.2.0.4 from 10.2.0.3?
I've been poking around on Metalink but having a hard time find any useful
information.
Any suggestions on what to look for?
I did see a couple of waits for "Latch: Cache Buffer Chains" that I'm still
investigating but no specific bugs with 10.2.0.4.
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
Other related posts:
