Scheduling Gather Siebel Statistics
Database version 11.2.0.3
I followed the procedures in the September 2015 Oracle White Paper: Performance Tuning Guidelines for Siebel CRM Applications on Oracle Database for collecting statistics. Everything went fine but I can't figure out how to schedule the stats collection as a job executing a PL/SQL Procedure. I've tried SQL Developer and I've tried TOAD, but nothing works. The GATHER_SIEBEL_STATS Procedure is part of the SIEBEL_STATS Package and there is no option for selecting a package in either of those tools.
How do I schedule a job to gather Siebel Stats?
Thanks.