OraFAQ Forum: Performance Tuning » How to Best Performance Param of Oracle in Windows

Home » RDBMS Server » Performance Tuning » How to Best Performance Param of Oracle in Windows

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

How to Best Performance Param of Oracle in Windows [message #270750]

Thu, 27 September 2007 23:26

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

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

Report message to a moderator

Re: How to Best Performance Param of Oracle in Windows [message #270777 is a reply to message #270750]

Fri, 28 September 2007 00:27

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

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

Report message to a moderator