Purpose
The purpose of this wiki is to provide information on how to check if note 1020260 has been applied.
Overview
This wiki will provide details on how to verify if Oracle stats on the following RFC tables are up to date: ARFCRSTATE, ARFCSDATA, ARFCSSTATE, TRFCQDATA, TRFCQIN,
TRFCQOUT, TRFCQSTATE.
Performance problems
If you experience performance problems when processing tRFC or qRFC calls, the issue may be occurring because it take a long time to read the RFC tables. If this is the case, you would see long sequential read times in transaction SM50 or in transaction SM66. See the following example, showing a sequential read issue reading table TRFCQOUT:
In this case it would be advised to check if the statistics are up to date. As per note 1020260.
How to check?
Call transaction DB20 and enter table TRFCQOUT (or ARFCSSTATE or TRFCQIN or any tqRFC table) and click on the Refresh button.
Make sure the statistics are set to Inactive (Active Flag = ‘I’ “DBSTATC settings” section at the end of the screen). See example below:
And just above it, check the 2 numbers listed (Under Number of Table Rows section) - "Old Number" and "New Number".
The "Old number" should correspond to the number delivered in the note 1020260. The new number should be as close to old number as possible.
Example: TRFCQOUT
The script in 1020260 sets the old number for TRFCQOUT to 331796 (if you look for statement EXECUTE DBMS_STATS.SET_TABLE_STATS(:OWNER, '"TRFCQOUT"' in the script). From the script:
So, the "Old number" should correspond to the number delivered in the note 1020260 which is 331796. In the example below this is the case indicating that the note has been applied:
The Old Number for the other tables is as follows:
Table TRFCQOUT the Old Number is 331796
Table TRFCQSTATE the Old Number is 29575
Table TRFCQDATA the Old NUmber is 71165
Table TRFCQIN the Old Number is 20994
Table ARFCRSTATE the Old Number is 3390
Table ARFCSDATA the Old Number is 419227
Table ARFCSSTATE the Old Number is 331849
Just above the Old Number in the Last Refresh section, the Date and Time should be closer to the current date. If it is very far (more than half an year), then the script from Note 1020260 should be run again. As per note 1020260:
"It is usually sufficient to execute the script once. However, to allow for continuous adjustments to the script, you can import the latest version in regular intervals (for example, once per quarter). It may also be useful to execute the script again after SAP upgrades.
Related Content
Related Documents
Related Notes
742950 Performance affected on Oracle DB with Supplement 11
932975 Oracle statistics for RFC tables
1485789 QRFC: Long running processes in SM50
1484197 ARFCSDATA for one LUW was read by 100 DIA processes
1528988 Queue scheduler uses a wrong index to access
1623430 Outbound queue (qout) scheduler does not process a
1573359 tRFC Idoc delay processing in BW
1493644 Long running process reading TRFCQIN blocking execution
1497510 Experiencing deadlocks, lock & waits in inbound processing
1500048 SMQ2 inbound Queue remains in READY state