SAP Knowledge Base Article - Preview

2574466 - How to obtain top SQL statements for long running background job

Symptom

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.“

A background job is long running and an ST12 trace does not capture the SQL performance due to it's maximum trace time limitation.
The background job may also be difficult to reproduce so historical analysis is required.


Read more...

Environment

  • SAP NETWEAVER(ALL)
  • Oracle 11 all versions
  • Oracle 12c all versions

Product

SAP ERP 6.0

Keywords

Oracle, Performance, Batch, Background, ASH, expensive, SQL, Issue, RSORASTT , KBA , SV-PERF , Performance Problems , SV-PERF-DB-ORA , Oracle related performance issues , 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.