I am an Oracle Integration Cloud (OIC) developer facing challenges with long-running PL/SQL procedures timing out. To mitigate this, I am considering using DBMS_SCHEDULER
to execute these procedures asynchronously, allowing OIC to regain control promptly.
I would appreciate insights on the potential maintenance overhead associated with this approach, particularly regarding:
- Effective job management and monitoring
- Resource allocation and its impact on database performance
- Strategies to handle maintenance windows and avoid conflicts
- Security considerations and privilege management
- Best practices for logging and auditing scheduled jobs
- How has been your experience with this approach?
Any advice or experiences shared would be greatly appreciated.
Thank you!