Home » RDBMS Server » Server Administration » SORT_AREA_SIZE
SORT_AREA_SIZE [message #159118] Thu, 16 February 2006 05:08 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
1) Can anyone explain,For sorting we used to create a temporary tablespace,then what is the need and use of setting the parameter SORT_AREA_SIZE?

2) What is the use of SORT_AREA_RETAINED_SIZE?

Report message to a moderator

Re: SORT_AREA_SIZE [message #159121 is a reply to message #159118] Thu, 16 February 2006 05:16 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Can this help

http://web.njit.edu/info/oracle/DOC/server.920/a96536/ch1198.htm

Report message to a moderator

Re: SORT_AREA_SIZE [message #159327 is a reply to message #159118] Fri, 17 February 2006 06:49 Go to previous message
airother
Messages: 27
Registered: February 2006
Junior Member
SORT_AREA_SIZE parameter is used to do sorting in memory, if sorting required more size spcify in above parameter then oracle makes the chunks of sort and and store intermidiate result in temp. tablespace.

Report message to a moderator

Previous Topic: How to migrate from oracle 7.3.4 to 8.1.7 manually?
Next Topic: Redo log Group & Members
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:31:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.