Unfortunatly not, if using Oracle server < 9i, your only alternative (if it really is affecting performance is create a new database with a larger block_size). It depends on the impact of the system, sure it's very undesirable. How many records are in the table etc?




Reply With Quote