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 release independent

Product

SAP NetWeaver all versions

Keywords

pre-defined CBO statistics, Cost Based Optimizer , KBA , performance , oracle , sm58 , smq1 , smq2 , qrfc , qreftid , performance, sequential read , performance; sequential read , trfcqout , trfcqin , trfc , trfcqdata , trfcqstate , pre-defined cbo statistics , sequential read , statistics freeze , dbstatc , cost based optimizer , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.