 | | | sort_area_size and hash_area_size | sort_area_size and hash_area_size 2006-07-04 - By David Sharples
Back
oracle version?
On 04/07/06, Oliver.Jost@(protected) <Oliver.Jost@(protected)> wrote:
>
>
> 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?
>
oracle version?<br><br>
<div><span class="gmail_quote">On 04/07/06, <b class="gmail_sendername"><a href
="mailto:Oliver.Jost@(protected)">Oliver.Jost@(protected)</a></b> <<a
href="mailto:Oliver.Jost@(protected)">Oliver.Jost@(protected)
</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div><br><font face="sans-serif" size="2">Hi All,</font> <br><font face="sans
-serif" size="2"> 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?
</font> </div></blockquote></div>
|
|
|