OraFAQ Forum: Performance Tuning » database configuration of SGA,shared pool size,redolog buffer and sort area size (merged)

Home » RDBMS Server » Performance Tuning » database configuration of SGA,shared pool size,redolog buffer and sort area size (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database configuration of SGA,shared pool size,redolog buffer and sort area size (merged) [message #307200]

Tue, 18 March 2008 02:22

manoj12
Messages: 210
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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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 /forum/fa/456/0/

/forum/fa/456/0/

.

Now you can add 5 stars.

Regards
Michel

Report message to a moderator

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

manoj12
Messages: 210
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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

manoj12
Messages: 210
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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I'd use 123456789 for all values.

Regards
Michel

Report message to a moderator

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

manoj12
Messages: 210
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 1732 times)

Report message to a moderator

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

manoj12
Messages: 210
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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes I like this value.

Regards
Michel

Report message to a moderator

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

manoj12
Messages: 210
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.

Report message to a moderator

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

manoj12
Messages: 210
Registered: March 2008
Location: India

Senior Member

Any update on the below mail.

Report message to a moderator

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

BlackSwan
Messages: 26766
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

trantuananh24hg
Messages: 744
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

Cool

But I like 1234567890 values than Michel's Laughing

Laughing

Report message to a moderator

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

manoj12
Messages: 210
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 1844 times)

Report message to a moderator

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

manoj12
Messages: 210
Registered: March 2008
Location: India

Senior Member

Any update on the below mail

Report message to a moderator

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

manoj12
Messages: 210
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.

Report message to a moderator

Previous Topic:	tablespace related
Next Topic:	PERFORMANCE OF A QUERY ;

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 03:08:43 CST 2024