936977 wrote:For your Oracle version & newer Oracle RDBMS by default collects statistics once every 24 hours for all objects that would benefit from having their statistics updated.
I want to schedule a job which runs every monday to gather statistics for a particular tables of a schema.
Can you please suggest as which one to use for scheduling a job ..either dbms_jobs or dbms_scheduler_jobs and why?
Database version --Oracle 10.2.0.4.0.
OS version -- Linux 2.4.