The GET_RPM stored procedure is used to calculate throughput and return Rows Per Minute (RPM). This can be used to quantify the throughput of an operation when measuring the duration and number of rows affected.
| Parameter | Description | |
|---|---|---|
| ROWS | Type: | INPUT |
| Datatype: | NUMBER | |
| Default Value: | None | |
| Description | The number of rows affected. | |
| SECONDS | Type: | INPUT |
| Datatype: | NUMBER | |
| Default Value: | None | |
| Description | Elapsed Seconds. | |
Examples
EXEC IN_DB_UTIL.GET_RPM(V_TOTAL_ROWS, V_TOTAL_SECS, V_ROWS_PER_MINUTE); SET SERVEROUTPUT ON; DECLARE V_TOTAL_ROWS NUMBER := 123456; V_TOTAL_SECS NUMBER := 5; V_RPM NUMBER := 0; BEGIN IN_DB_UTIL.GET_RPM(V_TOTAL_ROWS, V_TOTAL_SECS, V_RPM); DBMS_OUTPUT.PUT_LINE(CHR(10)||'Rows Per Minute: '||TRIM(TO_CHAR(V_RPM, '999,999,999'))); END; /
Example Output
Rows Per Minute: 1,481,472 PL/SQL procedure successfully completed.