How does one size the Oracle DB for WCC?

Document ID : KB000013609
Last Modified Date : 14/02/2018
Show Technical Document Details

How does one size the Oracle DB for WCC? 


How does one know what size the table space must be? 
How many processes need to be defined? 
How many sessions need to be defined? 


Per our CA Wiki for WCC: 

There is a table that includes the number of jobs and job runs. 

There is nothing documented that states how many sessions or processes are recommended. 
We will need 10 at the bare minimum and 50 as the max sessions.The processes and sessions 
may need to be tuned by the DBA. But this rarely happens. There is no known formula that CA gives 
for how many sessions and processes are required.