TX Enqueues - mode 4

From: Fedock, John (KAM.RHQ) <John.Fedock_at_us.kline.com>
Date: Wed, 7 Apr 2004 09:01:48 -0400
Message-ID: <5042FDC675779848A113F70D54F587490702B02D@KAMRICEXCLUS.us.kline.com>

 I know I have TX enqueues, with a mode = 4. From all my research, I bet it is ITL related. I know I can increase initrans and/or freelists, but the issue is what object(s) is this needed most?  

I understand in v9, you can use segment level statistics. In my version (8.1.7.4 - HP-UX), I do not know how to narrow this down to an object. I bet if I can work this out, the enqueues will go away. Any ideas on how to narrow this down? I have very heavy OLTP system.  

TIA,   John  

John Fedock
"K" Line America, Inc.
www.kline.com

---

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 Wed Apr 07 2004 - 13:42:11 CDT