SAP Knowledge Base Article - Preview

1831623 - Oracle enabled Maintenance Jobs

Symptom

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 , 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.