DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: disk/memory reads question

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    Angry

    I calculated my disk reads in relation to memory reads and
    I received the results below:


    NAME VALUE
    -------------- -----
    sorts (memory) 6841
    sorts (disk) 100
    sorts (rows) 4695206

    When I calculted the percentage I received this answer
    101.46177459435755006577985674609

    Does it look good? I thought it's always supposed to be
    100% or below 100%

    Any comments, critiques are welcomed

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The sorts(disk)/sorts(memory) should not be > 5%, else you should increase the SORT_AREA_SIZE parameter. In your case, it is 100/6841 = 1.46% or OK by my standards.
    Jeff Hunter

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