RE: SGA question
Don't do it. You should try to avoid "paging". Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Sai Selvaganesan Sent: Tuesday, July 15, 2003 11:49 AM To: Multiple recipients of list ORACLE-L hi is it possible to have a sga bigger than the rela memory available? suppose i have a 1gb ram can i start an instance with sga 2gb. does virtual memeory play a part in this memory allocation? thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan 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: Igor Neyman 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).
Re: SGA question
you will end up doing swap/paging . -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 15, 2003 9:49 AM > hi > > is it possible to have a sga bigger than the rela > memory available? > > suppose i have a 1gb ram can i start an instance with > sga 2gb. does virtual memeory play a part in this > memory allocation? > > thanks > sai > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sai Selvaganesan > 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: AK 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).
Re: SGA question
surely i will not do it. but my question is whether it is possible at all to do it. will oracle when allocating shared memory space take virtual memory into consideration or only real memory into consideration. thanks sai --- AK <[EMAIL PROTECTED]> wrote: > you will end up doing swap/paging . > > -ak > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Tuesday, July 15, 2003 9:49 AM > > > > hi > > > > is it possible to have a sga bigger than the rela > > memory available? > > > > suppose i have a 1gb ram can i start an instance > with > > sga 2gb. does virtual memeory play a part in this > > memory allocation? > > > > thanks > > sai > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: Sai Selvaganesan > > 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: AK > 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: Sai Selvaganesan 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).
Re: SGA question
If it take only real mem in consideration why would pageing happen at all ? -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 15, 2003 11:19 AM > surely i will not do it. but my question is whether it > is possible at all to do it. > > will oracle when allocating shared memory space take > virtual memory into consideration or only real memory > into consideration. > > thanks > sai > > --- AK <[EMAIL PROTECTED]> wrote: > > you will end up doing swap/paging . > > > > -ak > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Sent: Tuesday, July 15, 2003 9:49 AM > > > > > > > hi > > > > > > is it possible to have a sga bigger than the rela > > > memory available? > > > > > > suppose i have a 1gb ram can i start an instance > > with > > > sga 2gb. does virtual memeory play a part in this > > > memory allocation? > > > > > > thanks > > > sai > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > > -- > > > Author: Sai Selvaganesan > > > 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: AK > > 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: Sai Selvaganesan > 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: AK 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).
Re: SGA question
Hi! I believe that you can allocate more virtual memory to Oracle than you got physical. Never cared enough to try, though. There's a init.ora parameter LOCK_SGA, if you set it to true, then Oracle tries to hard lock all pages to physical memory, in that case you would probably get error on startup. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 15, 2003 9:49 PM > If it take only real mem in consideration why would pageing happen at all ? > > -ak > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, July 15, 2003 11:19 AM > > > > surely i will not do it. but my question is whether it > > is possible at all to do it. > > > > will oracle when allocating shared memory space take > > virtual memory into consideration or only real memory > > into consideration. > > > > thanks > > sai > > > > --- AK <[EMAIL PROTECTED]> wrote: > > > you will end up doing swap/paging . > > > > > > -ak > > > > > > > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" > > > <[EMAIL PROTECTED]> > > > Sent: Tuesday, July 15, 2003 9:49 AM > > > > > > > > > > hi > > > > > > > > is it possible to have a sga bigger than the rela > > > > memory available? > > > > > > > > suppose i have a 1gb ram can i start an instance > > > with > > > > sga 2gb. does virtual memeory play a part in this > > > > memory allocation? > > > > > > > > thanks > > > > sai > > > > -- > > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.net > > > > -- > > > > Author: Sai Selvaganesan > > > > 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: AK > > > 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: Sai Selvaganesan > > 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: AK > 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: Tanel Poder 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
RE: SGA question
> surely i will not do it. but my question is whether it > is possible at all to do it. > > will oracle when allocating shared memory space take > virtual memory into consideration or only real memory > into consideration. > > thanks > sai I believe that the answer is, as of 9i, it depends. Generally speaking yes you can over allocate memory and kill your instance performance. As of 9i the parameter LOCK_SGA enforces that the SGA is kept in real memory, presumably killing startup if sufficient real memory is unavailable. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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).
Re: SGA QUESTION
Hoo boy! That's a pretty healthy SGA you got there. Why do you think you need to dedicate that much RAM to your SGA? Why not start with something more reasonable, like say, 200 meg for shared pool and 200 more for the database buffers? A large shared pool can actually impede performance. Jared On Saturday 23 June 2001 12:20, Bunyamin K. Karadeniz wrote: > Hi GURUS,I HAVE A QUESTION. > > I will newly create a database and I have 8 GB RAM. > > I will create my SGA as 1 GB . IS it a good Idea? > I see that there is a variable size for the SGA , How can I arrange that? > How much must be log buffers for a 1GB SGA? > Thanks . > BUNYAMIN > > STARTUP > ORACLE instance started. > Total System Global Area 51168524 bytes > Fixed Size 70924 bytes > Variable Size34242560 bytes > Database Buffers 16777216 bytes > Redo Buffers77824 bytes Content-Type: text/html; charset="iso-8859-9"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: SGA QUESTION
Jared, If he has 8GB of memory, why not allocate 4GB to the data buffer instead of 200MB? I realize simply adding memory is not the solution for fixing a poorly tuned database, but on the other hand, if you have a lot of memory why not use it? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: SGA QUESTION
On Saturday 23 June 2001 15:15, Greg Moore wrote: > If he has 8GB of memory, why not allocate 4GB to the data buffer instead of > 200MB? I realize simply adding memory is not the solution for fixing a > poorly tuned database, but on the other hand, if you have a lot of memory > why not use it? Because it my just be a waste of memory. Really, he hasn't given any information about his database, number of users, type of queries, etc. So I am guessing at a size, and using up 4 gig for data base block buffers is a *LOT* of memory that would probably be more useful elsewhere. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: SGA QUESTION
And there is no formula for setting Log Buffers based on the Size of the SGA. What you have got is okay. I would suggest monitoring v$system_event for log buffer space wait event, and increase log buffer size if there are consistent waits for this event. Regards, - Kirti > -Original Message- > From: Jared Still [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, June 23, 2001 3:30 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: SGA QUESTION > > > > Hoo boy! That's a pretty healthy SGA you got there. > > Why do you think you need to dedicate that much RAM > to your SGA? > > Why not start with something more reasonable, like say, > 200 meg for shared pool and 200 more for the database > buffers? > > A large shared pool can actually impede performance. > > Jared > > > On Saturday 23 June 2001 12:20, Bunyamin K. Karadeniz wrote: > > Hi GURUS,I HAVE A QUESTION. > > > > I will newly create a database and I have 8 GB RAM. > > > > I will create my SGA as 1 GB . IS it a good Idea? > > I see that there is a variable size for the SGA , How can I arrange > that? > > How much must be log buffers for a 1GB SGA? > > Thanks . > > BUNYAMIN > > > > STARTUP > > ORACLE instance started. > > Total System Global Area 51168524 bytes > > Fixed Size 70924 bytes > > Variable Size34242560 bytes > > Database Buffers 16777216 bytes > > Redo Buffers77824 bytes > > > Content-Type: text/html; charset="iso-8859-9"; name="Attachment: 1" > Content-Transfer-Encoding: quoted-printable > Content-Description: > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: SGA QUESTION
Hi Jared, I think like Greg . Why not use 2-4 gb of 8 gb memory for SGA. ? If It has bad results ,Then How can I understand it? Thank you Greg and Jared and All others. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Sunday, June 24, 2001 1:15 AM > Jared, > > If he has 8GB of memory, why not allocate 4GB to the data buffer instead of > 200MB? I realize simply adding memory is not the solution for fixing a > poorly tuned database, but on the other hand, if you have a lot of memory > why not use it? > > - Greg > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Greg Moore > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: SGA QUESTION
> Hi Jared, > I think like Greg . Oh, we're in trouble now - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: SGA QUESTION
HERE IS THE KNOWLEDGE, my database is nearly 700 tables where 2 of it is 3 gb growing per year. My total disk is 400 GB. Total number physical users which will connect to database is 1000 but will be 2 for 2 years. Total number of database users is 30. Oracle is on NT. Oracle Version is 8.1.7 My RAM is 8 GB. Thank you . - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Sunday, June 24, 2001 2:15 AM > On Saturday 23 June 2001 15:15, Greg Moore wrote: > > If he has 8GB of memory, why not allocate 4GB to the data buffer instead of > > 200MB? I realize simply adding memory is not the solution for fixing a > > poorly tuned database, but on the other hand, if you have a lot of memory > > why not use it? > > Because it my just be a waste of memory. > > Really, he hasn't given any information about his database, number > of users, type of queries, etc. > > So I am guessing at a size, and using up 4 gig for data base block > buffers is a *LOT* of memory that would probably be more useful > elsewhere. > > Jared > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: SGA QUESTION
>>Oracle is on NT. >>My RAM is 8 GB. Is it a good (VALID) combination ;-) Rajesh -Original Message- Karadeniz Sent: Monday, June 25, 2001 1:55 PM To: Multiple recipients of list ORACLE-L HERE IS THE KNOWLEDGE, my database is nearly 700 tables where 2 of it is 3 gb growing per year. My total disk is 400 GB. Total number physical users which will connect to database is 1000 but will be 2 for 2 years. Total number of database users is 30. Oracle is on NT. Oracle Version is 8.1.7 My RAM is 8 GB. Thank you . - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Sunday, June 24, 2001 2:15 AM > On Saturday 23 June 2001 15:15, Greg Moore wrote: > > If he has 8GB of memory, why not allocate 4GB to the data buffer instead of > > 200MB? I realize simply adding memory is not the solution for fixing a > > poorly tuned database, but on the other hand, if you have a lot of memory > > why not use it? > > Because it my just be a waste of memory. > > Really, he hasn't given any information about his database, number > of users, type of queries, etc. > > So I am guessing at a size, and using up 4 gig for data base block > buffers is a *LOT* of memory that would probably be more useful > elsewhere. > > Jared > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: SGA QUESTION
I believe that you can have 8 Gig's, but don't you have to apply a patch in order for it to work? KK -Original Message- Dayal Sent: Monday, June 25, 2001 6:36 AM To: Multiple recipients of list ORACLE-L >>Oracle is on NT. >>My RAM is 8 GB. Is it a good (VALID) combination ;-) Rajesh -Original Message- Karadeniz Sent: Monday, June 25, 2001 1:55 PM To: Multiple recipients of list ORACLE-L HERE IS THE KNOWLEDGE, my database is nearly 700 tables where 2 of it is 3 gb growing per year. My total disk is 400 GB. Total number physical users which will connect to database is 1000 but will be 2 for 2 years. Total number of database users is 30. Oracle is on NT. Oracle Version is 8.1.7 My RAM is 8 GB. Thank you . - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Sunday, June 24, 2001 2:15 AM > On Saturday 23 June 2001 15:15, Greg Moore wrote: > > If he has 8GB of memory, why not allocate 4GB to the data buffer instead of > > 200MB? I realize simply adding memory is not the solution for fixing a > > poorly tuned database, but on the other hand, if you have a lot of memory > > why not use it? > > Because it my just be a waste of memory. > > Really, he hasn't given any information about his database, number > of users, type of queries, etc. > > So I am guessing at a size, and using up 4 gig for data base block > buffers is a *LOT* of memory that would probably be more useful > elsewhere. > > Jared > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: SGA QUESTION
Under some circumstances (which look scary to me) it is valid combination. See http://www.microsoft.com/HWDEV/PAE/default.htm and "Oracle8i Support for Very Large Memory (VLM) Configurations" in the release notes for 8.1.7 on WinNT. Whether it is GOOD combination, I cannot tell. May be under the influence of good doses of Laphroaig and Rachel's chocolate mousse cake I could be inclined to try it. Dr. Nikolay Kumanov MIS Manager, Zeitungsgruppe Bulgarien GmbH 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 mailto:[EMAIL PROTECTED] "Show me a completely smooth operation and I'll show you someone who's covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune" -Original Message- Posted At: Monday, June 25, 2001 1:36 PM Posted To: Oracle Conversation: SGA QUESTION >>Oracle is on NT. >>My RAM is 8 GB. Is it a good (VALID) combination ;-) Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikolay Kumanov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: SGA QUESTION
Who knows. Perhaps your database is 100K perhaps it is 1000Pb. Perhaps it is DSS, DW, or even OLTP. I would say use a 8Gb sga and buy more memory, should be perfect for what your trying to do. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Saturday, June 23, 2001 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: SGA QUESTION Hi GURUS,I HAVE A QUESTION. I will newly create a database and I have 8 GB RAM. I will create my SGA as 1 GB . IS it a good Idea? I see that there is a variable size for the SGA , How can I arrange that? How much must be log buffers for a 1GB SGA? Thanks . BUNYAMIN STARTUP ORACLE instance started.Total System Global Area 51168524 bytesFixed Size 70924 bytesVariable Size 34242560 bytesDatabase Buffers 16777216 bytesRedo Buffers 77824 bytes
RE: SGA QUESTION
Hi all, >If he has 8GB of memory, why not allocate 4GB to the data >buffer instead of I don't remember the limit, but there *is* an upper limit on the amount of memory that a single process can address in NT (was it 2Gb?). Since the architecture of Oracle on NT is a single-process-multi-threaded one, and all of the SGA and PGA is actually within this process space, I believe that you may be bumping this upper limit Maybe someone with a deeper understanding of NT can chip in (Anita?) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: SGA QUESTION
Hello, The upper limit for a server running NT is 2gb, because usually only 4gb of memory can be installed. However, I believe that with the patch installed, enabling NT to go above 4gb of ram, it will also increase the upper limit. KK -Original Message- Kanagaraj Sent: Monday, June 25, 2001 2:18 PM To: Multiple recipients of list ORACLE-L Hi all, >If he has 8GB of memory, why not allocate 4GB to the data >buffer instead of I don't remember the limit, but there *is* an upper limit on the amount of memory that a single process can address in NT (was it 2Gb?). Since the architecture of Oracle on NT is a single-process-multi-threaded one, and all of the SGA and PGA is actually within this process space, I believe that you may be bumping this upper limit Maybe someone with a deeper understanding of NT can chip in (Anita?) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: SGA QUESTION
Does anyone have an idea of what percentage of total memory should be reserved for NT? Say I had 600m of memory available. How big could my SGA be and still have NT run properly? Ron Smith Database Administration [EMAIL PROTECTED] -Original Message- Sent: Monday, June 25, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Hello, The upper limit for a server running NT is 2gb, because usually only 4gb of memory can be installed. However, I believe that with the patch installed, enabling NT to go above 4gb of ram, it will also increase the upper limit. KK -Original Message- Kanagaraj Sent: Monday, June 25, 2001 2:18 PM To: Multiple recipients of list ORACLE-L Hi all, >If he has 8GB of memory, why not allocate 4GB to the data >buffer instead of I don't remember the limit, but there *is* an upper limit on the amount of memory that a single process can address in NT (was it 2Gb?). Since the architecture of Oracle on NT is a single-process-multi-threaded one, and all of the SGA and PGA is actually within this process space, I believe that you may be bumping this upper limit Maybe someone with a deeper understanding of NT can chip in (Anita?) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: SGA QUESTION
You suck up half of that memory easy for Oracle and NT would run just fine, as long as there aren't a whole bunch of other applications running on the server! Kev -Original Message- L. Sent: Monday, June 25, 2001 3:54 PM To: Multiple recipients of list ORACLE-L Does anyone have an idea of what percentage of total memory should be reserved for NT? Say I had 600m of memory available. How big could my SGA be and still have NT run properly? Ron Smith Database Administration [EMAIL PROTECTED] -Original Message- Sent: Monday, June 25, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Hello, The upper limit for a server running NT is 2gb, because usually only 4gb of memory can be installed. However, I believe that with the patch installed, enabling NT to go above 4gb of ram, it will also increase the upper limit. KK -Original Message- Kanagaraj Sent: Monday, June 25, 2001 2:18 PM To: Multiple recipients of list ORACLE-L Hi all, >If he has 8GB of memory, why not allocate 4GB to the data >buffer instead of I don't remember the limit, but there *is* an upper limit on the amount of memory that a single process can address in NT (was it 2Gb?). Since the architecture of Oracle on NT is a single-process-multi-threaded one, and all of the SGA and PGA is actually within this process space, I believe that you may be bumping this upper limit Maybe someone with a deeper understanding of NT can chip in (Anita?) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: SGA QUESTION
I had read from a paper that . NEVER EXCEED 55% of totaL memORY FOR NT . but I KNOW THAT YOU CAN NOT EXCEED 2 GB TOO. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, June 25, 2001 10:53 PM > Does anyone have an idea of what percentage of total memory should be > reserved for NT? Say I had 600m of memory available. How big could my SGA > be and still have NT run properly? > > Ron Smith > Database Administration > [EMAIL PROTECTED] > > > -Original Message- > Sent: Monday, June 25, 2001 2:33 PM > To: Multiple recipients of list ORACLE-L > > > Hello, > The upper limit for a server running NT is 2gb, because usually only > 4gb of > memory can be installed. However, I believe that with the patch installed, > enabling NT to go above 4gb of ram, it will also increase the upper limit. > KK > > -Original Message- > Kanagaraj > Sent: Monday, June 25, 2001 2:18 PM > To: Multiple recipients of list ORACLE-L > > > Hi all, > > >If he has 8GB of memory, why not allocate 4GB to the data > >buffer instead of > > I don't remember the limit, but there *is* an upper limit on the amount of > memory that a single process can address in NT (was it 2Gb?). Since the > architecture of Oracle on NT is a single-process-multi-threaded one, and all > of the SGA and PGA is actually within this process space, I believe that you > may be bumping this upper limit > > Maybe someone with a deeper understanding of NT can chip in (Anita?) > > John Kanagaraj > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: Kevin Kostyszyn > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: SGA QUESTION
My database will be growing 20 GB per year. Anyway . Forget it . Thank you All. Bunyamin - Original Message - From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Monday, June 25, 2001 6:32 PM Subject: RE: SGA QUESTION Who knows. Perhaps your database is 100K perhaps it is 1000Pb. Perhaps it is DSS, DW, or even OLTP. I would say use a 8Gb sga and buy more memory, should be perfect for what your trying to do. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Saturday, June 23, 2001 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: SGA QUESTION Hi GURUS,I HAVE A QUESTION. I will newly create a database and I have 8 GB RAM. I will create my SGA as 1 GB . IS it a good Idea? I see that there is a variable size for the SGA , How can I arrange that? How much must be log buffers for a 1GB SGA? Thanks . BUNYAMIN STARTUP ORACLE instance started.Total System Global Area 51168524 bytesFixed Size 70924 bytesVariable Size 34242560 bytesDatabase Buffers 16777216 bytesRedo Buffers 77824 bytes
RE: SGA QUESTION
Kevin and John, The original limit was 2GB on NT, but since service pack 3 and above this can be extended to 3GB by changing a few settings. There is also a special driver that can be obtained to allow access up to 8GB. I have never tried this driver since I don't have any boxes with > 4GB, but I suspect that versions prior to 8i might have problems since they were released before this driver was. I As with most memory issues on NT related to Oracle, I find the following docs invaluable: Note: 46053.1 "Windows NT Memory Architecture Overview" Note: 46001.1 "Oracle Database and the Windows NT memory architecture, Technical Bulletin" I'm sure these restrictions have been removed or at least greatly enlarged in Win2K. HTH, -- Anita --- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Hello, > The upper limit for a server running NT is 2gb, > because usually only 4gb of > memory can be installed. However, I believe that > with the patch installed, > enabling NT to go above 4gb of ram, it will also > increase the upper limit. > KK > > -Original Message- > Kanagaraj > Sent: Monday, June 25, 2001 2:18 PM > To: Multiple recipients of list ORACLE-L > > > Hi all, > > >If he has 8GB of memory, why not allocate 4GB to > the data > >buffer instead of > > I don't remember the limit, but there *is* an upper > limit on the amount of > memory that a single process can address in NT (was > it 2Gb?). Since the > architecture of Oracle on NT is a > single-process-multi-threaded one, and all > of the SGA and PGA is actually within this process > space, I believe that you > may be bumping this upper limit > > Maybe someone with a deeper understanding of NT can > chip in (Anita?) > > John Kanagaraj __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: SGA QUESTION
> > 200MB? I realize simply adding memory is not the solution for fixing a > > poorly tuned database, but on the other hand, if you have a lot of memory > > why not use it? > > > > - Greg -- > Hi Jared, > I think like Greg . Why not use 2-4 gb of 8 gb memory for SGA. ? > If It has bad results ,Then How can I understand it? > Thank you Greg and Jared and All others. > Bunyamin No one said this is a poorly performing system, as it isn't even built yet. Allocating 50% of your memory may be possible, but also may be a bad idea, it really depends on the system, which we know nothing about other than it has 8 gig of memory. If it's a data warehouse, it's probably a bad idea. There's usually a lot of full tables scans and little need for a large data block buffer size or a large shared pool. On a DW though, there is a need for a lot of system memory to satisfy the parallel processes and sort_area_size requirements. If it's OLTP, it really depends on the # of users and the application, as well as considerations such as MTS, etc. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).