enqueue wait event 
Author Message
 enqueue wait event

Hi,
I have the following output in a tk_waits file.

                                          **                        enqueue

                       HW Excl SYS.I_TS#     7070    97.00   383.99    80.56
                        Transaction Excl              150      2.06
91.33    19.16
                       Transaction Share               46      0.63
0.85      0.18
                      HW Excl SYS.I_OBJ#        23      0.32       0.49
0.10

                         ** Sub Total **            7289
476.66

What does HW mean. I did not find it in the Enqueue wait description.

Thanks in advance,
Michael



Sun, 08 Jun 2003 22:06:35 GMT
 enqueue wait event

HW is the 'high watermark' lock.  You don't
usually see them.   You must have been doing
a lot of space management in the period to make
those ones appear significant.

What are headings to the columns in your report,
I am not familiar with the tool you mention.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html

Quote:

>Hi,
>I have the following output in a tk_waits file.

>                                          **                        enqueue

>                       HW Excl SYS.I_TS#     7070    97.00   383.99
80.56
>                        Transaction Excl              150      2.06
>91.33    19.16
>                       Transaction Share               46      0.63
>0.85      0.18
>                      HW Excl SYS.I_OBJ#        23      0.32       0.49
>0.10

>                         ** Sub Total **            7289
>476.66

>What does HW mean. I did not find it in the Enqueue wait description.

>Thanks in advance,
>Michael



Sun, 08 Jun 2003 23:55:59 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. enqueue waits

2. Waited Too Long For Row Cache Enqueue Lock

3. waited too long for row cache enqueue lock

4. DBMS_AQ.Enqueue gives incorrect enqueue time

5. Disk Space Transaction wait event

6. Trace SQL in a session with bind and wait events 8i

7. wait events

8. Wait events

9. Event: parallel query dequeue wait on Oracle 7.3.4

10. How can i get this wait event from the trace file

11. Common large wait events

12. SQL*Net message from client wait event


 
Powered by phpBB® Forum Software