what does "enqueue" in the stats pack result mean?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: what does "enqueue" in the stats pack result mean?

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    what does "enqueue" in the stats pack result mean?

    hi,

    I have the following "Top 5 Waits" from statpack result:
    I wonder wat does "Enqueue" means and will appreciate anyone will throw me any light on reducing it as it is increasing week by week during peak sessioin.

    thanks in advance


    Top 5 Wait Events
    ~~~~~~~~~~~~~~~~~ Wait % Total
    Event Waits Time (cs) Wt Time
    -------------------------------------------- ------------ ------------ -------
    enqueue 14,172 2,269,089 38.75

    log file sync 19,403 1,112,922 19.00

    row cache lock 2,707 777,184 13.27

    buffer busy waits 6,253 704,752 12.03

    db file sequential read 171,996 257,038 4.39
    -------------------------------------------------------

  2. #2
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    An enqueue is a lock that protects a shared resource....data in a record...it includes a enqueuing mechanism, which is first in first out(FIFO). (Note that latching mechanism is not FIFO)


    I see alot of traffic in your DB, therefor the possible enqueue activity.

    Anything else?
    Able was I ere I saw Elba

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width