Sort_merge_passes increasing at 38 per minute...
Posted by:
phil yune
Date: December 18, 2011 09:15AM
This is my sort_merge_pass variable in 1 min:
| Sort_merge_passes | 6860588 |
| Sort_merge_passes | 6860626 |
My sort_buffer_size is set at 4m:
sort_buffer_size | 4194304
Should I be worried?
I know I'm running quite a few order_by queries...
Subject
Views
Written By
Posted
Sort_merge_passes increasing at 38 per minute...
2748
December 18, 2011 09:15AM
955
December 19, 2011 06:55AM
1010
December 19, 2011 07:36AM
1146
December 20, 2011 03:10AM
1001
December 20, 2011 04:07PM
1085
December 21, 2011 02:58AM
1266
December 21, 2011 07:25PM
987
December 22, 2011 02:34AM
1415
December 22, 2011 11:53PM
1112
December 23, 2011 07:14AM
1015
December 24, 2011 08:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.