/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
This KBA describes the Oracle enabled minor maintenance jobs that are active by default in Oracle Database. For SAP systems, which do not use streams and which don't need bsln (baseline) stats unless SAP has a specific need for these jobs, the list of such minor maintenance jobs can be selected as follows:
- select job_name, owner, enabled, state from dba_scheduler_jobs where enabled = 'TRUE' order by job_name;
- Output could be :
| JOB_NAME | OWNER | ENABLED | STATE |
| BSLN_MAINTAIN_STATS_JOB | SYS | TRUE | SCHEDULED |
| DRA_REEVALUATE_OPEN_FAILURES | SYS | TRUE | SCHEDULED |
| ORA$AUTOTASK_CLEAN# | SYS | TRUE | SCHEDULED |
| PURGE_LOG | SYS | TRUE | SCHEDULED |
| RSE$CLEAN_RECOVERABLE_SCRIPT | SYS | TRUE | SCHEDULED |
| SM$CLEAN_AUTO_SPLIT_MERGE | SYS | TRUE | SCHEDULED |
Read more...
Product
SAP ERP 6.0
Keywords
DBMS_AUTO_TASK_ADMIN, Maintenance Jobs, Oracle, dba_scheduler_jobs. , KBA , BC-DB-ORA , Oracle , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)