DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2001
    Singapore(Asia)-WebCentre business company

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


    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
    Pretoria, Rep of South Africa
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.