Home » RDBMS Server » Performance Tuning » Server Specification (Capacity Building)
Server Specification [message #574455] Thu, 10 January 2013 10:29 Go to next message
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
Re: Server Specification [message #574458 is a reply to message #574455] Thu, 10 January 2013 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Server Specification [message #574459 is a reply to message #574458] Thu, 10 January 2013 10:47 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
more bigger is more better
Re: Server Specification [message #574460 is a reply to message #574458] Thu, 10 January 2013 10:47 Go to previous messageGo to next message
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..
Re: Server Specification [message #574461 is a reply to message #574459] Thu, 10 January 2013 10:57 Go to previous messageGo to next message
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.

Re: Server Specification [message #574462 is a reply to message #574461] Thu, 10 January 2013 11:05 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
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
Re: Server Specification [message #574493 is a reply to message #574462] Fri, 11 January 2013 03:54 Go to previous messageGo to next message
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
Re: Server Specification [message #576891 is a reply to message #574493] Sat, 09 February 2013 10:31 Go to previous message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
Previous Topic: ADDM Report
Next Topic: Oracle Statistics
Goto Forum:
  


Current Time: Sat Aug 30 03:31:07 CDT 2014

Total time taken to generate the page: 0.09102 seconds