Home » RDBMS Server » Performance Tuning » Check and telll whether the following configuration is correct or not
Check and telll whether the following configuration is correct or not [message #308414] Mon, 24 March 2008 04:40 Go to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
Suppose my database size is 6.5 GB,Hard disk size=144 GB,Ram size=4 GB.Could you please tell me whether the following configuration is correct
shared_pool_size=400 MB
shared_pool_reserved_size=40 MB
pga_aggregate_target=200 MB
sort_area_size=50 Mb
sort_area_retained_size=5 MB
db_block_size=8192
db_cache_size=500 Mb
SGA_max_size=1536 MB
sessions=1000
open_cursors=500
processess=800
Could you please tell me whether the following configuration is correct for this 6.5 GB Database
The application is ASP.NET
PROCESSORS=1
OPERATING SYSTEM=WINDOWS/XP 2000

Could you please tell me whether the following configuration is correct for this 6.5 GB Database
iF ANY CHANGES ARE SUPPOSE TO BE MADE.DO TELL ME ?

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #308425 is a reply to message #308414] Mon, 24 March 2008 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activity parameters don't depend on database size but on what you do with the database.
So there is no answer to your question.

Regards
Michel

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #308427 is a reply to message #308425] Mon, 24 March 2008 05:05 Go to previous messageGo to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
Well my question to you is can you check and tell whether the following parameters being set are correct for 4 GB RAM.
I have an application made in ASP.NET WHICH IS HAVING A BANK DATA GETTING INSERTED,UPDATED,DELETED in A DATABASE IN lakhs.Suppose there are 300 users accessing THE application and data is getting inserted,updated,and deleted in a database through THAT APPLICATION.ARE THESE PARAMETERS SUFFICIENT FOR 4 GB RAM.

[Updated on: Mon, 24 March 2008 05:13]

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #308433 is a reply to message #308427] Mon, 24 March 2008 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know and noone but you can know.
You have to measure (use StatsPack for instance) and see where are the bottenecks.

Regards
Michel

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #308460 is a reply to message #308414] Mon, 24 March 2008 07:33 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Hi,

You can start the database with your settings. StatsPack should solve your problem. You can also refer to attached textfile tune.sql (run from sql prompt) to see the SGA cache stats (not all parameters).

Regards,

MSMallya
  • Attachment: Tune.sql
    (Size: 2.90KB, Downloaded 1164 times)

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #308476 is a reply to message #308460] Mon, 24 March 2008 08:10 Go to previous messageGo to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
I have runned the below SQL
It has given me the below output.The below output is listed below.Can I ask you one question.Can you check and telll whether the following parameters I have set in init.ora is correct.
  • Attachment: tun1.txt
    (Size: 44.04KB, Downloaded 1140 times)

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #308685 is a reply to message #308476] Tue, 25 March 2008 03:43 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
It seems DB Cache hit ratio is below expected (89%), There is a scope for increasing DB_Cache_Size parameter. You have to take care that your total SGA size should be atleast 15% less than Physical Memory of the box ( as per my experience ), i.e say physical memory is 512Mb, then SGA should be <=435Mb.

Regards,

MSMallya

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #308691 is a reply to message #308685] Tue, 25 March 2008 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
It seems DB Cache hit ratio is below expected (89%),

This goal is silly. Explain why you should have at least 89% (and why 89 and not 90 or 88?!).

Quote:
You have to take care that your total SGA size should be atleast 15% less than Physical Memory of the box

What does "at least less than" means?

Regards
Michel

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #308724 is a reply to message #308691] Tue, 25 March 2008 05:18 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Quote:
This goal is silly. Explain why you should have at least 89% (and why 89 and not 90 or 88?!).



No doubt, you can have any %ge, but to have good DB_Cache_hit% I consider as minimum 89%, and above is very good.

Quote:
What does "at least less than" means?



I mean, it is better not to allocate SGA above 85% of physical memory.

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #308729 is a reply to message #308724] Tue, 25 March 2008 05:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
No doubt, you can have any %ge, but to have good DB_Cache_hit% I consider as minimum 89%, and above is very good

Good relative to what? to hit ratio? hmm, obvioulsy yes.
Regarding instance sanity? I doubt it. (I'm even sure he does not indicate anything)

Quote:
I mean, it is better not to allocate SGA above 85% of physical memory.

It depends on your memory and what you does with your server.
15% of 32Gb is almost 5GB which is far too big to let free in a pure database server.

Regards
Michel

Report message to a moderator

Re: Check and telll whether the following configuration is correct or not [message #309282 is a reply to message #308729] Thu, 27 March 2008 00:19 Go to previous message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
I will generate a STATSPACK REPORT AND WILL DISPLAY IT TO YOU.

Report message to a moderator

Previous Topic: Summary table Update statement.
Next Topic: CAN ANY ONE PROVIDE ME THE STATSPACK SCRIPTS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 10:39:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.