Home » RDBMS Server » Performance Tuning » How to Best Performance Param of Oracle in Windows
How to Best Performance Param of Oracle in Windows [message #270750] Thu, 27 September 2007 23:26 Go to next message
Oyunbold
Messages: 21
Registered: September 2007
Location: MGL
Junior Member
Dear all,
I am new in Oracle db admin. For a production database of about 250 users simultaneously connecting to it. How
to calculate the all parameters ?
Windows 2003 Datacenter Edition x86 4GB Ram 3Ghz Cpu
Oracle v9i
Dedicated Server
DataBase size = 20GB

[Updated on: Fri, 28 September 2007 00:13]

Report message to a moderator

Re: How to Best Performance Param of Oracle in Windows [message #270755 is a reply to message #270750] Thu, 27 September 2007 23:35 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I am new in Oracle db admin.
How did you end up in such a position & have to ask such BASIC question(s)?
Re: How to Best Performance Param of Oracle in Windows [message #270777 is a reply to message #270750] Fri, 28 September 2007 00:27 Go to previous messageGo to next message
Oyunbold
Messages: 21
Registered: September 2007
Location: MGL
Junior Member
Im config it
Parameter config

sga_max_size=747708396
shared_pool_size=159383552
db_cache_size=478150656
db_block_size=8192
log_buffer=524288
large_pool_size=8388608
java_pool_size=75497472
pga_aggregate_target=4294967296
pga_max_size=268435456
enqueue_resources=1936
workarea_size_policy=true
transactions=429
sessions=390
processes=350
parallel_max_servers=5
parallel_execution_message_size=2148
open_cursors=400
job_queue_processes=10

connect user > 50 or One user big sql runnig Oracle very long run why ?

[Updated on: Fri, 28 September 2007 00:34]

Report message to a moderator

Re: How to Best Performance Param of Oracle in Windows [message #270779 is a reply to message #270750] Fri, 28 September 2007 00:35 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>connect user > 50 Oracle very long run why ?
1 or more things need to be better
Please hire a local Oracle consultant who knows more than to post pleas on this forum.
Re: How to Best Performance Param of Oracle in Windows [message #270856 is a reply to message #270750] Fri, 28 September 2007 03:23 Go to previous messageGo to next message
Oyunbold
Messages: 21
Registered: September 2007
Location: MGL
Junior Member
Big Sql runnig
Hit Ratio
Index - 73%
Body - 90%
Sql Area - 80%
Other - 98-100%
Re: How to Best Performance Param of Oracle in Windows [message #270861 is a reply to message #270856] Fri, 28 September 2007 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is "hit ratio"?

Regards
Michel
Re: How to Best Performance Param of Oracle in Windows [message #270864 is a reply to message #270750] Fri, 28 September 2007 03:37 Go to previous messageGo to next message
Oyunbold
Messages: 21
Registered: September 2007
Location: MGL
Junior Member
Library cache statistics
Re: How to Best Performance Param of Oracle in Windows [message #270872 is a reply to message #270864] Fri, 28 September 2007 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And then?

Regards
Michel
Re: How to Best Performance Param of Oracle in Windows [message #271212 is a reply to message #270750] Sun, 30 September 2007 20:07 Go to previous messageGo to next message
Oyunbold
Messages: 21
Registered: September 2007
Location: MGL
Junior Member
How increase this hit ratio?
Re: How to Best Performance Param of Oracle in Windows [message #271213 is a reply to message #271212] Sun, 30 September 2007 20:19 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello Oyunbold,

Maybe this helps:
http://www.oracle-base.com/articles/9i/MemoryManagement9i.php

Regards,

mson77

Re: How to Best Performance Param of Oracle in Windows [message #271216 is a reply to message #270750] Sun, 30 September 2007 20:47 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/
icon14.gif  Re: How to Best Performance Param of Oracle in Windows [message #271310 is a reply to message #270750] Mon, 01 October 2007 04:19 Go to previous message
Oyunbold
Messages: 21
Registered: September 2007
Location: MGL
Junior Member
Tnx All
Previous Topic: What is the number of cost?
Next Topic: row_locking
Goto Forum:
  


Current Time: Fri Dec 09 21:26:54 CST 2016

Total time taken to generate the page: 0.09846 seconds