Re: V$session_wait question and rollback segments

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 4 May 2004 21:47:56 +0100
Message-ID: <003301c43219$17b58600$7102a8c0@Primary>

Slot number is:

id1 - 65536 * trunc(id1/ 65536)

Your analysis is perfectly reasonable.
Collision on unique indexes would cause
TX mode 4. The logic is identical to that for PKs and UKs.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Optimising Oracle Seminar
http://www.jlcomp.demon.co.uk/seminar.html

June 2004 UK Manchester
July 2004 Iceland
July 2004 USA California
Aug 2004 USA North Carolina
Sept 2004 UK Manchester
Sept 2004 USA NYC
Oct 2004 USA Boston

Original Message ----- From: "Diego Cutrone" <diegocutrone_at_yahoo.com.ar> To: <oracle-l_at_freelists.org> Sent: Wednesday, May 05, 2004 1:43 AM Subject: Re: V$session_wait question and rollback segments

Yeap, Sorry Jonathan.
This is the correct infomation from v$lock (ID1 and ID2):

SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
--------- -- --------- --------- --------- --------- --------- ---------

112 TX 196661 514403 0 6 439874 0

I know I can get rollback segment ID from "trunc(ID1/65536)". Do you know how to get the slot number?

BTW, I think I have finally found the cause of the problem from my other question: (the TX 4 enqueue wait --)

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 May 04 2004 - 15:46:50 CDT