-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|