| What is recommended size of SGA (Merged) [message #124080] |
Thu, 16 June 2005 06:09  |
faisalhanif
Messages: 11
Registered: May 2005
Location: Saudi Arabia
|
Junior Member |
|
|
What is the recomended size of SGA.
MY SGA Size is the following:
Shared Pool = 80 MB
Buffer Cache= 0 MB
Large Pool = 8 MB
Total SGA = 89.751
When i am running my scipt the following error araise
ORA-04030 out of process memory when trying to allocate 6672 bytes.
What sould be the standard size of =SGA
Thanks
Thanks
[Updated on: Fri, 17 June 2005 18:35] by Moderator Report message to a moderator |
|
|
|
| What is recomended size of SGA [message #124084 is a reply to message #124080] |
Thu, 16 June 2005 06:31  |
sohailnawaz
Messages: 40
Registered: April 2005
Location: Saudi Arabia
|
Member |
|
|
What is the recomended size of SGA.
MY SGA Size is the following:
Shared Pool = 80 MB
Buffer Cache= 0 MB
Large Pool = 8 MB
Total SGA = 89.751
When i am running my scipt the following error araise
ORA-04030 out of process memory when trying to allocate 6672 bytes.
What sould be the standard size of =SGA
Thanks
|
|
|
|
| Re: What is recomended size of SGA [message #124094 is a reply to message #124084] |
Thu, 16 June 2005 07:21 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Shoail
The problem lies in size of buffer cache.
Sincerely i believe that before configuring this SGA, u must not have gone thru docs... or was it that u were just experimenting?
Well.. ideally SGA should range anywhere from 30 to 70% of ur total RAM capacity. Then in the defined sga... around 45% for shared pool, 45% for data buffer & 5% for redo log buffer...
Again its not a hard-n-fast thing that these components have to be sized this way... U may have differing sizes of these, duly judged on basis of performance of ur database.
...Girish
|
|
|
|
|
|
| Re: What is recomended size of SGA [message #124104 is a reply to message #124080] |
Thu, 16 June 2005 07:42 |
dmitry.nikiforov
Messages: 723
Registered: March 2005
|
Senior Member |
|
|
ORA-04030 is not an SGA problem. It's a lack of OS memory,
available for Oracle processes.
| Quote: |
ORA-04030: out of process memory when trying to allocate num bytes str,str
Cause: Operating system process private memory has been exhausted.
Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.
|
Check whether you application performs memory expensive
operations like bulk collect into or something like that.
Rgds.
|
|
|
|
|
|
| Re: What is recomended size of SGA [message #124221 is a reply to message #124094] |
Thu, 16 June 2005 21:19 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Girishji.... as per your reply
>>In the defined sga... around 45% for shared pool, 45% for data buffer & 5% for redo log buffer...
Can you tell me why you selected size of redo buffer as 5% of SGA and database buffer AS 45 %.?
==>sohailnawaz... Girishji is correct as problem lies in size of buffer cach... I think you should read the working of Background process DBWR and importance of Buffer cache in SGA...you will know why buffer cach should not be Zero.
Thank you
From:- Sunil
[Updated on: Thu, 16 June 2005 21:33] Report message to a moderator |
|
|
|
| Re: What is recomended size of SGA [message #124233 is a reply to message #124221] |
Fri, 17 June 2005 00:41 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Sunil
Tats a generalized convention. But again its not hard n fast thing that u have to do this configuration only. To begin with a database, if no sizing of components is coming to mind.. u can have this sizing convention. As per this rest 5% of sga is for configuring other dsefault components like large pool java pool etc..
Regds
Girish
|
|
|
|
| Re: What is recomended size of SGA [message #124378 is a reply to message #124233] |
Fri, 17 June 2005 15:56 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Girishji ... I am giving you one example can u help me out by telling me what should be the default size of component of SGA.
---------------------------------------------------------------
Example:---
-User can connect to the databse.
-User can do only select on the tables of database
-There are many Users nearly 100 who are trying to execute same SQL.
Note:- User dont do any update or insert or delete on table in database
---------------------------------------------------------------
My Question here is ... what should be the better size of every componet of SGA for above senario?
Thank you
From:- Sunil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
