Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

sort_area_size and hash_area_size

Oliver Jost

2006-07-04

Replies:


Hi All,
  I did some testing on this quite some time ago and was hoping to have a refresher.... I have an application with a particularly nasty view... given that I can not go in and fix the view without breaching protocol, I was going to increase the sort area size and hash area size at the session level.... Now that I'm revisiting this I remember there were some considerations for negatively impacting performance.  After failing to find any information on this negative impact... does anyone know of some considerations I should make before going forward?

Thank you,
    Oliver


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.