OraFAQ Forum: Performance Tuning » Server Specification

Home » RDBMS Server » Performance Tuning » Server Specification (Capacity Building)

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

Server Specification [message #574455]

Thu, 10 January 2013 10:29

emorka
Messages: 4
Registered: January 2013
Location: Africa

Junior Member

pls can any body help me with a server specification for IBM Power series. I need to load 15Milion record per day. about 4 billion records for 3 years. Oracle 11G. I Need this info asap. cpu, ram,hdd

Report message to a moderator

Re: Server Specification [message #574458 is a reply to message #574455]

Thu, 10 January 2013 10:41

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The highest CPU you can buy
The more RAM you can buy
The more disk you can buy.

Buy them asap.

Regards
Michel

Report message to a moderator

Re: Server Specification [message #574459 is a reply to message #574458]

Thu, 10 January 2013 10:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

more bigger is more better

Report message to a moderator

Re: Server Specification [message #574460 is a reply to message #574458]

Thu, 10 January 2013 10:47

emorka
Messages: 4
Registered: January 2013
Location: Africa

Junior Member

micheal pls be serious with me .

i need statistics to justify the server spec you will be

helpng me out with please..

Report message to a moderator

Re: Server Specification [message #574461 is a reply to message #574459]

Thu, 10 January 2013 10:57

emorka
Messages: 4
Registered: January 2013
Location: Africa

Junior Member

Please i need exact emperical specification

from any professional that is Good at Capacity Planning.

Thank You.

Report message to a moderator

Re: Server Specification [message #574462 is a reply to message #574461]

Thu, 10 January 2013 11:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please i need exact emperical specification
Just like the "empirical" values that you provided us?

>I need to load 15Milion record per day
>about 4 billion records for 3 years.
is record only 80 bytes long or Gigabyte BLOB?


SQL> select 15000000/(24*60*60) per_sec from dual;

   PER_SEC
----------
173.611111

more disk is more better

Report message to a moderator

Re: Server Specification [message #574493 is a reply to message #574462]

Fri, 11 January 2013 03:54

emorka
Messages: 4
Registered: January 2013
Location: Africa

Junior Member

Thank You for your Reply.

record are 80 bytes long

from your calculation of record per sec

what is your suggestion.

Futher Info.

This is actually an Oracle EBS R12 GL Module Server. for both db and application

XLA/FAH is been implemeted also and we are to take 3yrs data from the legaccy system

into the application.

kindly help me out here futher.

i will upload the current server speck for you to see.

please tell me how to send send you the .doc file

Report message to a moderator

Re: Server Specification [message #576891 is a reply to message #574493]

Sat, 09 February 2013 10:31

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Check the following whether it is useful for you.
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS3346
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/5cb5ed706d254a8186256c71006d2e0a/2f204a0a4cc21f6f862574c8008088fc/$FILE/ORA%20FSA H%20Power%20Systems%20091208.pdf

By
Vamsi

Report message to a moderator

Previous Topic:	ADDM Report
Next Topic:	Oracle Statistics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 29 15:25:55 CST 2025