Database Reference
In-Depth Information
$ sqlplus hr/hr
SQL> VARIABLE result NUMBER
SQL> VARIABLE sort_area_size NUMBER
SQL> VARIABLE dummy VARCHAR2(255)
SQL> BEGIN
:result:=dbms_utility.get_parameter_value(parnam=>'sort_area_size',
intval=>:sort_area_size, strval=>:dummy);
END;
/
PL/SQL procedure successfully completed.
SQL> PRINT sort_area_size
SORT_AREA_SIZE
--------------
65536
Next, start another SQL*Plus session as user SYS, retrieve the SID and SERIAL# of the
session you want to modify, and increase SORT_AREA_SIZE to 1048576 bytes by calling the
package DBMS_SYSTEM .
$ sqlplus "/ as sysdba"
SQL> SELECT sid, serial# FROM v$session WHERE username='HR';
SID SERIAL#
---------- ----------
9 19
SQL> EXEC sys.dbms_system.set_int_param_in_session(9, 19, -
'sort_area_size', 1048576);
PL/SQL procedure successfully completed.
Now, back in the first session by HR, verify that the parameter SORT_AREA_SIZE has actually
changed.
SQL> BEGIN
:result:=dbms_utility.get_parameter_value(parnam=>'sort_area_size',
intval=>:sort_area_size, strval=>:dummy);
END;
/
PL/SQL procedure successfully completed.
SQL> PRINT sort_area_size
SORT_AREA_SIZE
--------------
1048576
Search WWH ::




Custom Search