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).

Reply via email to