DBMS_SYSTEM.SET_INT_PARAM_IN

DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION Procedure

This procedure sets an integer parameter in another session

Argument Name	Type	In/Out	Default?
SID	NUMBER	IN
SERIAL#	NUMBER	IN
PARNAM	VARCHAR2	IN
INTVAL	BINARY_INTEGER	IN

For example to set the SORT_AREA_SIZE parameter to 131072 in a session with SID 9, serial# 29 use:

EXECUTE dbms_system.set_int_param_in_session (9, 29, 'sort_area_size', 131072);

The SID and serial# for the other session can be obtained from V$SESSION e.g.:

DECLARE
    l_sid NUMBER;
    l_serial NUMBER;
BEGIN
    SELECT sid, serial#
    INTO l_sid, l_serial
    FROM v$session
    WHERE username = 'User1';

    dbms_system.set_int_param_in_session 
    (l_sid, l_serial, 'sort_area_size', 131072);
END;
/