Latch Free
- From: "syed jaffar hussain" <sjaffarhussain@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Apr 2004 17:40:51 +0300
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
