How does one size the Oracle DB for WCC?

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

How does one size the Oracle DB for WCC? 

Question:

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? 

Environment:
Oracle
Answer:

Per our CA Wiki for WCC: 
https://docops.ca.com/ca-wla-ae-wcc/11-4-2/en/installing/ca-wcc-implementation/performance-tuning#PerformanceTuning-ReportingDatabaseSize 

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.