How to Run the job Manually
By default the job runs once a week, on Sunday at 8:00PM (database time). However it can be started manually at any time.
• Log in to your schema with the Codebeamer Oracle account
• Run the following script to start the job asynchronously:
BEGIN
DBMS_SCHEDULER.RUN_JOB(
JOB_NAME => 'GATHER_MANUAL_STATS_FOR_USER',
USE_CURRENT_SESSION => FALSE);
END;
/
• Running the job can take a few minutes depending on the database size. To see the job result check the GATHER_STATS_LOG table.