Home » RDBMS Server » Performance Tuning » How increase OLTP regarding more CPU?
How increase OLTP regarding more CPU? [message #129376] Sun, 24 July 2005 22:38 Go to next message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member

How update high performance OLTP regarding more CPU?
Re: How increase OLTP regarding more CPU? [message #129446 is a reply to message #129376] Mon, 25 July 2005 05:19 Go to previous messageGo to next message
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
Re: How increase OLTP regarding more CPU? [message #129584 is a reply to message #129446] Mon, 25 July 2005 19:25 Go to previous messageGo to next message
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?





Re: How increase OLTP regarding more CPU? [message #129724 is a reply to message #129376] Tue, 26 July 2005 07:37 Go to previous message
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
Previous Topic: statspack-buffer waits
Next Topic: dbms_stats
Goto Forum:
  


Current Time: Fri May 27 01:07:24 CDT 2022