How to create the Gathering Statistics Job
The gathering statistics job consists of two parts: a log table where gathering history is stored and the job itself.
1. The log table is created automatically by Codebeamer.
2. For creating the job, download the job creation script,
oracle_gather_schema_stats_job.sql, and run the script as Oracle DBA. The script uses one parameter:
Codebeamer's schema name which should be passed from sqlplus
sqlplus sys/<your_connection> as sysdba @./oracle_gather_schema_stats_job.sql <your_schema_name>
e.g
sqlplus sys/Oradoc_db1@ORCLCDB as sysdba @./oracle_gather_schema_stats_job.sql CBROOT