Tag Archives: 11g

Managing the Oracle DB 11g Scheduler Windows (DBMS_SCHEDULER)

To display existing scheduler windows, you should query the “dba_scheduler_windows” table: e.g. SELECT WINDOW_NAME,REPEAT_INTERVAL,DURATION,ENABLED FROM dba_scheduler_windows In my case, I needed to disable a window, so that it doesn’t run any scheduled jobs, so I had to run the following: … Continue reading

Posted in Oracle | Tagged , , , , , , | Leave a comment

How to compile all Oracle DB 11gR2 Invalid Objects

Login to SQLPlus Run the following statement: “@?/rdbms/admin/utlrp.sql”

Posted in Oracle | Tagged , , , , , , | Leave a comment