Solution : https://service.sap.com/sap/support/notes/564446 (SAP Service marketplace login required)
Summary :
When scheduling the BTCH_RSORAVSH background job for Oracle I/O subsystem statistics collection, multiple issues may arise, including the job's multiple concurrent executions, variant errors, manual scheduling queries, scheduling mechanics, and initiation restrictions post user deletion. The root of these problems includes programming errors, deleted necessary users, and dependencies on ST-PI and /SDF/ modules. Solutions involve job cancellation in SM37 except for one, variant deletion, and proper job setup using RSORAVSH or /SDF/RSORAVSH and ensuring the job's hourly schedule. This adjustment aids in maintaining effective database monitoring and troubleshooting.
Key words :
latest st-pi version, btch_rsoravsh background job runs, relevant background job manually, st-pi modules, btch_rsoravsh background job, background job btch_rsoravsh, btch_rsoravsh calling program, background job terminates, /sdf/get_db_ora_tables_growth modules, data collection runs
Related Notes :
| 1026796 | SAP_BASIS: Deleting obsolete Oracle analysis reports |
| 619188 | FAQ: Oracle wait events |
| 615168 | Jobs with temporary variant terminate after Support Package |
| 549298 | RSORAVSH: LOAD_PROGRAM_NOT FOUND during the run of RSCOLL00 |