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: 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.
Was this information helpful?