Home » RDBMS Server » Performance Tuning » database configuration of SGA,shared pool size,redolog buffer and sort area size (merged)
database configuration of SGA,shared pool size,redolog buffer and sort area size (merged) [message #307200] Tue, 18 March 2008 02:22 Go to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Suppose my database size is 10 GB and Ram used is 512 MB Ram and Hard Disk used is 80 GB.I wanted to know what should be my size of SGA in bytes.In my database it is mentioned as SGA Size 135338868,shared pool size 50331648 ,db_block_size=8192 and db_block_buffers=0,sort_area_size=524288.can you please help me to estimate that this kind of configuration is correct for 10 GB database.IF not what should be SGA Size,db_block_buffers size,sort_area_size,db_block_size

[Updated on: Tue, 18 March 2008 05:01] by Moderator

Report message to a moderator

Re: database configuration of SGA,shared pool size,redolog buffer and sort area size [message #307215 is a reply to message #307200] Tue, 18 March 2008 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't rate your own question before there is any useful answer.

Now my answer is: this has been asked many times so ./fa/456/0/.

Now you can add 5 stars.

Regards
Michel
icon2.gif  Re: database configuration of SGA,shared pool size,redolog buffer and sort area size [message #307220 is a reply to message #307215] Tue, 18 March 2008 02:52 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
I know It has been asked many times.but Now Can you please help me on urgent basis to know what should be the size of SGA,redolog buffer,shared pool size,sort area size

[Updated on: Tue, 18 March 2008 03:01]

Report message to a moderator

Re: database configuration of SGA,shared pool size,redolog buffer and sort area size [message #307226 is a reply to message #307220] Tue, 18 March 2008 03:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I know It has been asked many times.

And what are the answers you found when you searched?

Regards
Michel

[Updated on: Tue, 18 March 2008 03:29]

Report message to a moderator

icon2.gif  Re: database configuration of SGA,shared pool size,redolog buffer and sort area size [message #307246 is a reply to message #307200] Tue, 18 March 2008 04:19 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
See According to me searching things will take a lot of time.Could you please tell me what should be the size of SGA I should estimate.Is 135338868 the proper estimate for estimate.Is 8192 the correct block size for Db_block_size,Is 0 the correct buffers for db_block_buffers,Is 50331648 the correct size for shared pool.Please note that the HDD is 80 Gb and the Ram is 512 MB and the database size is 10 GB
Re: database configuration of SGA,shared pool size,redolog buffer and sort area size [message #307255 is a reply to message #307246] Tue, 18 March 2008 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'd use 123456789 for all values.

Regards
Michel
Sending you a Database information details.Help to check whether any changes suppose to be done [message #307257 is a reply to message #307200] Tue, 18 March 2008 04:48 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
I am sending you the following database information of my database.can you please help to check whether the database is quite effective or any changes are suppose to be done.
Please check the database information details of my database.
If any changes are suppose to be done please let me know the impact of other.Please let me know
the database size is 10 GB
HDD is 80 Gb
Ram used is 512 MB

---------------------------------
Please check the below details

  • Attachment: dbinfo1.txt
    (Size: 451.00KB, Downloaded 622 times)
icon2.gif  Re: database configuration of SGA,shared pool size,redolog buffer and sort area size [message #307258 is a reply to message #307255] Tue, 18 March 2008 04:53 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Did you mean to say that the size of SGA should be 123456789 or Size of DB_block_buffers,db_block_size,shared_pool_size size,sort_area_size should be 123456789
Re: database configuration of SGA,shared pool size,redolog buffer and sort area size [message #307261 is a reply to message #307258] Tue, 18 March 2008 04:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes I like this value.

Regards
Michel
Re: database configuration of SGA,shared pool size,redolog buffer and sort area size [message #307262 is a reply to message #307258] Tue, 18 March 2008 05:01 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
How come the size of all the database parameters should be 123456789.I dont understand.You mean to say that the database parameters like i.e shared pool size,sort area size,db_block_size,db_block_buffers should be 123456789.How can this be possible.
icon2.gif  Re: Sending you a Database information details.Help to check whether any changes suppose to be done [message #307273 is a reply to message #307257] Tue, 18 March 2008 05:24 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Any update on the below mail.
Re: database configuration of SGA,shared pool size,redolog buffer and sort area size (merged) [message #307330 is a reply to message #307200] Tue, 18 March 2008 08:41 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
SELECT VIEW_NAME FROM DBA_VIEWS WHERE VIEW_NAME LIKE '%ADVICE%';

Query the returned views & adjust accordingly.

{corrected typo}

[Updated on: Tue, 18 March 2008 21:15] by Moderator

Report message to a moderator

Re: database configuration of SGA,shared pool size,redolog buffer and sort area size (merged) [message #307436 is a reply to message #307330] Tue, 18 March 2008 20:54 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
hmm, it seem to find the answer easily, on the menu with the button [/b]search[/b], write down "SGA_MAX_SIZE", you can find, find, and find many topics related it. Read them and test those values.

Anna, you miss one character (s) from the DBA_VIEW(s) not DBA_VIEW. Cool

But I like 1234567890 values than Michel's Laughing
icon2.gif  Re: database configuration of SGA,shared pool size,redolog buffer and sort area size (merged) [message #307484 is a reply to message #307330] Wed, 19 March 2008 00:27 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
After querying this query what I should find.I have recieved that views.Now what shall I do.Hey can you please help me check whether any changes are suppose to be made.if any changes are suppose to be made.Do tell me.My Database size is 10 Gb,HDD 80 GB.Ram used is 512 MB.
  • Attachment: dbinfo1.txt
    (Size: 451.00KB, Downloaded 740 times)
icon2.gif  Re: database configuration of SGA,shared pool size,redolog buffer and sort area size (merged) [message #307533 is a reply to message #307484] Wed, 19 March 2008 01:42 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Any update on the below mail
Re: database configuration of SGA,shared pool size,redolog buffer and sort area size [message #307667 is a reply to message #307261] Wed, 19 March 2008 06:56 Go to previous message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Hi Michel
Well Could you please tell how much should be SGA SIZE IN MB,SHARED POOL SIZE IN MB,DB BUFFER CACHE IN MB,REDOLOG BUFFER CACHE IN MB OF A 10 GB DATABASE.
Previous Topic: tablespace related
Next Topic: PERFORMANCE OF A QUERY ;
Goto Forum:
  


Current Time: Mon Dec 05 19:18:12 CST 2016

Total time taken to generate the page: 0.11384 seconds