How Many Sort merge passes per day is too much?
Posted by:
dbv
Date: August 23, 2005 10:17PM
In order to allow as many simultaneous connections as possible, I am trying to lower the per-connection variable sort_buffer_size as much as possible while making sure that the "Sort merge passes" statistic doesn't increase too much. I was wondering how big this stat can increase every day which is reasonable such that the sort buffer doesn't need to be raised. I am using 4.1.12 Thanks.
Subject
Views
Written By
Posted
How Many Sort merge passes per day is too much?
2546
August 23, 2005 10:17PM
2716
August 24, 2005 08:54AM
2588
August 24, 2005 07:16PM
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.