Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2003
    Posts
    4

    Question Unanswered: Waiting for an enqueue

    Hello:

    Oracle DB Version: 7.1.6.2
    SO=HP-UX 10.20

    There are moments that the db is running very slowly. I'm looking for some contention and I see this at the view x$ksqst:

    ADDR INDX KS KSQSTGET KSQSTWAT
    -------- ---------- -- ---------- ----------
    C3153198 69 CF 3486 8
    C3153210 84 CU 49171 14
    C31541F0 592 SQ 167184 463
    C3154208 595 ST 1851 8
    C3154328 631 TX 750737 197

    I have read that SQ is Secuence Number enqueue.
    What can I do to reduce the waiting for this lock?.

    Thank you very much!
    Mariam

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >What can I do to reduce the waiting for this lock?.
    Don't use sequences.

  3. #3
    Join Date
    Dec 2003
    Posts
    4

    Smile

    Originally posted by anacedent
    >What can I do to reduce the waiting for this lock?.
    Don't use sequences.
    Thank you!.

    The application use lots of sequences..Should I increase the cache value to improve my performance?. How can I see which sequence is causing the contention?.

    Regards,
    Mariam

  4. #4
    Join Date
    Dec 2003
    Location
    INDIA
    Posts
    3

    Re: Waiting for an enqueue

    Originally posted by mariam
    Hello:

    Oracle DB Version: 7.1.6.2
    SO=HP-UX 10.20

    There are moments that the db is running very slowly. I'm looking for some contention and I see this at the view x$ksqst:

    ADDR INDX KS KSQSTGET KSQSTWAT
    -------- ---------- -- ---------- ----------
    C3153198 69 CF 3486 8
    C3153210 84 CU 49171 14
    C31541F0 592 SQ 167184 463
    C3154208 595 ST 1851 8
    C3154328 631 TX 750737 197

    I have read that SQ is Secuence Number enqueue.
    What can I do to reduce the waiting for this lock?.

    Thank you very much!
    Mariam

  5. #5
    Join Date
    Dec 2003
    Location
    INDIA
    Posts
    3

    Re: Waiting for an enqueue

    Your base is very old, I recommend to migrate

    Bya



    Originally posted by mariam
    Hello:

    Oracle DB Version: 7.1.6.2
    SO=HP-UX 10.20

    There are moments that the db is running very slowly. I'm looking for some contention and I see this at the view x$ksqst:

    ADDR INDX KS KSQSTGET KSQSTWAT
    -------- ---------- -- ---------- ----------
    C3153198 69 CF 3486 8
    C3153210 84 CU 49171 14
    C31541F0 592 SQ 167184 463
    C3154208 595 ST 1851 8
    C3154328 631 TX 750737 197

    I have read that SQ is Secuence Number enqueue.
    What can I do to reduce the waiting for this lock?.

    Thank you very much!
    Mariam

  6. #6
    Join Date
    Dec 2003
    Posts
    4

    Unhappy

    Migration is not in my hands......so I try to improve the performance as much as I can.
    So....

    The application use lots of sequences..Should I increase the cache value to improve my performance?. How can I see which sequence is causing the contention?.

    Thank you very much for any help!.
    Regards,
    Mariam

  7. #7
    Join Date
    Dec 2003
    Location
    Argentina
    Posts
    5
    Originally posted by anacedent
    >What can I do to reduce the waiting for this lock?.
    Don't use sequences.
    Increase the sequence cache !

  8. #8
    Join Date
    Dec 2003
    Location
    Argentina
    Posts
    5
    Originally posted by mariam
    Migration is not in my hands......so I try to improve the performance as much as I can.
    So....

    The application use lots of sequences..Should I increase the cache value to improve my performance?. How can I see which sequence is causing the contention?.

    Thank you very much for any help!.
    Regards,
    Mariam
    Start watching which sequence is incrementing its value very often.

  9. #9
    Join Date
    Dec 2003
    Location
    INDIA
    Posts
    3
    May be are not an aid, but really I believe that version really has many problems if you have this in production environment sorry

  10. #10
    Join Date
    Dec 2003
    Location
    Argentina
    Posts
    5
    Originally posted by king_PMON
    May be are not an aid, but really I believe that version really has many problems if you have this in production environment sorry
    In release 7.2 and below of Oracle, sequence caches were kept in the rowcache. As of 7.3, they were moved to the library cache. To users and applications, the result of this change is that sequence caches are aged out faster in 7.3 (and this continues in Oracle8).

    John.

Posting Permissions

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