Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

Re: sort_area_size and hash_area_size

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: Oliver.Jost@xxxxxxxxxxxxxx
  • Date: Tue, 4 Jul 2006 21:54:24 +0100
oracle version?

On 04/07/06, Oliver.Jost@xxxxxxxxxxxxxx <Oliver.Jost@xxxxxxxxxxxxxx> 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?

Other related posts:

  • sort_area_size and hash_area_size
  • Re: sort_area_size and hash_area_size
  • Re: sort_area_size and hash_area_size




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.