Hi Diego,
If lock type is 'TX', rollback segment number = trunc(p2/65536)
and slot number = p2 - 65536*trunc(p2/65536).
May I know which table you are looking at to get the following
detailed info about enqueue waits?
Enqueue Stats
--
TY GETS WAITS
Thanks for the TX information Jeffery.
But my question about CI enqueue still remains.
Here's the query to get enqueue waits statistics, it's from Steve Adams'
site.
select
q.ksqsttyp type,
q.ksqstget gets,
q.ksqstwat waits
from
sys.x_$ksqst q
where
q.ksqstget 0
/
thanks again
of list ORACLE-L
Subject: RE: enqueue waits -- CI
Thanks for answering Unal, John.
John, you were right about the query. I've corrected it. And I'm not
getting
T[ and CK anymore,now I get TX and CI.
I've also done further investigation and I also know now what p2 and p3
mean
://www.christianity.net.au/
-Original Message-
From: Diego Cutrone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 May 2001 4:11
To: Multiple recipients of list ORACLE-L
Subject: RE: enqueue waits -- CI
Thanks for answering Unal, John.
John, you were right about the query. I've
Hi Diego,
No, those are block buffers. When a segment is dropped, truncated or shrunk
(normally a rollback segment) then a reuse block range cross instance call is
needed to flush the unwanted blocks from cache. Similarly, before a parallel
direct read a checkpoint block range or checkpoint