Oracle Myth #1745 "When u set the sort_area_size for a database, it will allocate that much memory PER USER for any sort operation being performed on the database"
--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote: > Arvind, > > When u set the sort_area_size for a database, it > will allocate that much > memory PER USER > for any sort operation being performed on the > database. In practice, it > means that if u allocate > too high a value for the sort_area_size and multiple > users are performing > multiple sorts, the Unix > system may run out of memory and Oracle will return > u a process memory > error. > > For eg. if u have ur sort_area_size as 100MB and u > have 10 users performing > sort operations > on the database, Oracle will take up 100*10 MB > memory. This might degrade ur > system performance. > > Samir > > Samir Sarkar > Oracle DBA > SchlumbergerSema > Email : [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > > -----Original Message----- > Sent: 31 March 2003 11:04 > To: Multiple recipients of list ORACLE-L > > > hello all, > > how does increasing the value of SORT_AREA_SIZE > affect the unix system > perfomance. > > > Thanks > Arvind > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Arvind Kumar > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > _________________________________________________________ > This email is confidential and intended solely for > the use of the > individual to whom it is addressed. Any views or > opinions presented are > solely those of the author and do not necessarily > represent those of > SchlumbergerSema. > If you are not the intended recipient, be advised > that you have received > this email in error and that any use, dissemination, > forwarding, printing, > or copying of this email is strictly prohibited. > > If you have received this email in error please > notify the > SchlumbergerSema Helpdesk by telephone on +44 (0) > 121 627 5600. > _________________________________________________________ > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: SARKAR, Samir > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
