Home » RDBMS Server » Server Administration » Can i increase the sort_area_size
Can i increase the sort_area_size [message #51370] Sat, 18 May 2002 02:04 Go to next message
yram
Messages: 75
Registered: February 2001
Member
hi

is it is possiable to increase the sort_area_size ?

what is the use of sort_area_size?

do send me some information.

bye
yram

Report message to a moderator

Re: Can i increase the sort_area_size [message #51376 is a reply to message #51370] Sun, 19 May 2002 16:14 Go to previous messageGo to next message
coby
Messages: 2
Registered: May 2002
Junior Member
From Oracle Doc,

SORT_AREA_SIZE specifies the maximum amount, in bytes, of memory to use for a sort. Increasing SORT_AREA_SIZE size improves the efficiency of large sorts. Multiple allocations never exist; there is only one memory area of SORT_AREA_SIZE for each user process at any time.

Use Alter session or Alter system to increase the size.

Hope that helps,
coby

Report message to a moderator

Re: Can i increase the sort_area_size [message #51398 is a reply to message #51370] Tue, 21 May 2002 09:43 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
In your init.ora file, modify or add the following

# sort area size of 1 M
sort_area_size = 1048576

then recycle the database.

Report message to a moderator

Previous Topic: format of data in tables
Next Topic: OPEN_CURSORS in init.ora file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 16 18:57:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.