Get GAJA's Book .. Oracle 101 Perf. Tunning.. U will find a Lot there .. HTH
Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 -----Original Message----- C.S.Venkata Subramanian Sent: Tuesday, April 01, 2003 2:04 PM To: Multiple recipients of list ORACLE-L where can one find the other myths about oracle? Venkat -- On Mon, 31 Mar 2003 06:18:35 Connor McDonald wrote: >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). > > _____________________________________________________________ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: C.S.Venkata Subramanian 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ganesh Raja 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).
