SAP Knowledge Base Article - Preview

2140916 - Performance issues in RFC processing (Oracle)

Symptom

  • Performance issues occur during the processing of Remote Function Calls. The processing in transactions SMQ1, SMQ2 or SM58 is slow.
  • Either the server system or the client system of the RFC is running on Oracle DB. The workprocess overview (transaction SM50 or SM66) shows long-running accesses to RFC related DB tables (TRFCQIN, TRFCQOUT, ARFCSSTATE, ARFCSDATA, etc).


Read more...

Environment

  • Oracle 10g or higher (11g, 12c ...)
  • SAP NetWeaver
  • SAP Web Application Server for SAP S/4 HANA
  • ABAP Platform

Product

ABAP platform all versions ; SAP NetWeaver all versions ; SAP Web Application Server for SAP S/4HANA all versions

Keywords

pre-defined CBO statistics, Cost Based Optimizer, Missing or incorrect database statistic for a SAP table, Delivery of Oracle statistics, Oracle statistics for RFC tables, DB statistics, ARFCSTATE , KBA , performance , oracle , smq1 , smq2 , sm58 , qreftid , qrfc , performance, sequential read , pre-defined cbo statistics , trfcqstate , trfcqin , trfcqout , trfcqdata , trfc , statistics freeze , sequential read , cost based optimizer , dbstatc , arfcsdata , arfcsstate , arfcrstate , fixed statistics , BC-MID-RFC-QT , Queued RFC (qRFC) and transactional RFC (tRFC) , BC-DB-ORA , Oracle , Problem

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.