OraFAQ Forum: Performance Tuning » How increase OLTP regarding more CPU?

Home » RDBMS Server » Performance Tuning » How increase OLTP regarding more CPU?

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

How increase OLTP regarding more CPU? [message #129376]

Sun, 24 July 2005 22:38

enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia

Member

How update high performance OLTP regarding more CPU?

Report message to a moderator

Re: How increase OLTP regarding more CPU? [message #129446 is a reply to message #129376]

Mon, 25 July 2005 05:19

Frank Naude
Messages: 4571
Registered: April 1998

Senior Member

I don't know what you are asking. Please rephrase your question and provide more detail?

Best regards.

Frank

Report message to a moderator

Re: How increase OLTP regarding more CPU? [message #129584 is a reply to message #129446]

Mon, 25 July 2005 19:25

enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia

Member

I have Oracle 9i under Windows 2003 at 4 CPU server. Server's RAM is 8GB.

My question is how increase transaction process in the server?
How use all CPU and all memory?

Report message to a moderator

Re: How increase OLTP regarding more CPU? [message #129724 is a reply to message #129376]

Tue, 26 July 2005 07:37

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Your question still seems vague, and I'm not sure what you are asking. You use memory by allocating it to oracle, for example setting sga_target init parameter. You use cpus by running things, in parallel if appropriate but in oltp parallel often isn't. Suggest you read the concepts guide and performance tuning guide in their entireties, and specifically the following:

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/build_db.htm#20152

Report message to a moderator

Previous Topic:	statspack-buffer waits
Next Topic:	dbms_stats

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 03 03:53:09 CST 2023