Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get Trace for dbms_scheduler job session

654268Aug 7 2009 — edited Aug 7 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2009
Added on Aug 7 2009
3 comments
2,190 views