RE: PGA

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"

><Samir.SARKAR_at_nottingham.sema.slb.com> 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  :  ssarkar2_at_slb.com 

>> 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: arvindk_at_sqlstarintl.com

>> 

>> 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: ListGuru_at_fatcity.com (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: Samir.SARKAR_at_nottingham.sema.slb.com

>> 

>> 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: ListGuru_at_fatcity.com (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: connor_mcdonald_at_yahoo.com

>

>"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: hamcdc_at_yahoo.co.uk

>

>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: ListGuru_at_fatcity.com (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: csvenkata_at_lycos.com

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: ListGuru_at_fatcity.com (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: gans_r_at_rediffmail.com

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: ListGuru_at_fatcity.com (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).