ASSM & Freelists
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ASSM & Freelists

  1. #1
    Join Date
    Sep 2005
    Posts
    278

    ASSM & Freelists

    With top wait event is DB file Sequential Read & Buffer busy waits I thought to increase the Freelists for index & tables.
    Event Waits Time (s) % of Ela Time
    ------------------------------------ ------------ ----------- --------------
    db file sequential read 32,866,091 347,809 84.26
    CPU time 38,869 9.42
    buffer busy waits 2,781,396 8,088 1.96
    db file parallel write 114,175 6,266 1.52
    db file scattered read 649,540 4,564 1.11
    All the tablespaces have Segment Space Managemnt as AUTO, Is it worth to increase the freelists with ASSM?? Please Advice.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    no effects if you do, there are more things which can cause buffer busy waits

  3. #3
    Join Date
    Sep 2005
    Posts
    278
    Can you explain all those other reasons which cause the buffer busy waits.

    Thanks in advance.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

  5. #5
    Join Date
    Sep 2005
    Posts
    278
    Thanks for the link

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