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 , statistics freeze , trfcqstate , trfcqin , trfcqout , trfcqdata , trfc , cost based optimizer , sequential read , oracle , fixed statistics , qreftid , qrfc , smq2 , sm58 , smq1 , arfcsdata , arfcsstate , arfcrstate , dbstatc , performance, sequential read , pre-defined cbo 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.