SGA question

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

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

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

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 .

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.

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

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

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

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

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

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

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

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

RE: SGA QUESTION

rozen." 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

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

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,

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

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

RE: SGA QUESTION

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

SGA QUESTION

Hi GURUS,I HAVE A QUESTION. I will newly create a database and I have 8 GB RAM. I will create mySGA as 1 GB . IS it a good Idea? I see that there is avariable size for the SGA , How can I arrange that? How much must be log buffers for a 1GB SGA? Thanks . BUNYAMIN STARTUP ORACLE instance

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.

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:

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?