How to get Trace for dbms_scheduler job session
654268Aug 7 2009 — edited Aug 7 2009Hi,
I am facing issue with my scheduler job for Mview refresh. The refresh runs in 10s when i run it on sql prompt using dbms_refresh package. But when i schedule the job with dbms_scheduler the refresh takes around an hour to complete.
I need to generate sql_trace to see where scheduler session is waiting.
Kindly help me on how to enable trace on scheduler jobs.
Thanks
Rajesh