-
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.
-
hi
you can check v$sort_segment
-
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
-
[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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|