Monitor the sorts in memory vs disk. Try to keep the disk/memory ratio to less than 1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Monitor the sorts in memory vs disk. Try to keep the disk/memory ratio to less than 1

  1. #1
    Join Date
    Jan 2001
    Posts
    32

    Unhappy

    i have a disk contention, the ratios in the database as well, but a physical disk is 100% busy, sqlplus send me a next message

    Monitor the sorts in memory vs disk. Try to keep the disk/memory ratio to less than .10 by increasin

    i think there are too many sorts (disk), the sorts are


    sorts (memory) 274045
    sorts (disk) 310

    how can i detect wich user is doing the sorts.

    the next step is increse the parameters SORT_AREA_SIZE.


  2. #2
    Join Date
    Oct 2000
    Posts
    139
    hi

    you can check v$sort_segment

  3. #3
    Join Date
    Oct 2000
    Posts
    80
    SELECT N.NAME, S.STATISTIC#, S.SID, S.VALUE FROM V$STATNAME N, V$SESSTAT S WHERE
    N.STATISTIC# IN(SELECT STATISTIC# FROM V$STATNAME WHERE NAME LIKE 'sort%') AND
    S.STATISTIC#=N.STATISTIC#;
    John Doyle

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    [QUOTE][i]Originally posted by fmedina [/i]
    [B]
    i think there are too many sorts (disk), the sorts are


    sorts (memory) 274045
    sorts (disk) 310
    [/B][/QUOTE]

    I don't think your real problems for disk contention are disk sorts. From the above figures, your ratio of disk_sorts/memory_sorts is 0.1%, which *usually* should not cause obvious performance degradation...

    You should check other areas of possible causes of disk contention, mainly physical db_datafiles and redo/arch_log_files layout....

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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