DBA
4 posts
DBMS_SCHEDULER
When you back in the day wanted to schedule or run something in the backgound you used DBMS_JOB. With the beginning of release 10g of the database…
Concurrent request output directory
In most cases the output files will be written to $COMMON_TOP/admin/out/_<ENV.NAME _. If you don't find anything there investgate the environment…
DBMS_JOB
Submitted/scheduled job can be found in: Running jobs can be found in: Remove a job: DBMS_JOB have been deprecated and replaced by DBMS_SCHEDULER…
Clear buffer cache
When you are working with performance issues you need to have an empty database cache to get a "real" result from your query. If you run a query…