latches

From: syed jaffar hussain <sjaffarhussain_at_hotmail.com>
Date: Tue, 27 Apr 2004 18:29:27 +0300
Message-ID: <006501c42c6c$6d0dd650$840a010a@app02test>

Hello List,

We have ePayment system and we use TIBCO application. An adaptor has a update sql statements that runs continuously. I found the following top 5 waits events for this session

Log file sysn(redo allocation retries + Avergae redo wirte size = are very high)
Latch free (Cache buffers chains + Library cache)

I know that latch free(cache buffers chains) accessing the same block/buffers again & again. How can I avoid hot block/buffers problem?

Best Regards,

Syed Jaffar Hussain

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Apr 27 2004 - 11:19:40 CDT