使用DBMS_UTILITY.get_parameter_value查看session的parameter-CSDN博客

alter session set parallel_instance_group = 'denglt';
set SERVEROUTPUT on;
DECLARE
   parnam   VARCHAR2 (256);
   intval   BINARY_INTEGER;
   strval   VARCHAR2 (256);
   partyp   BINARY_INTEGER;
BEGIN
   partyp :=
      DBMS_UTILITY.get_parameter_value ('parallel_instance_group', intval, strval);
   DBMS_OUTPUT.put ('parameter value is: ');

   IF partyp = 1
   THEN
      DBMS_OUTPUT.put_line (strval);
   ELSE
      DBMS_OUTPUT.put_line (intval);
   END IF;

   IF partyp = 1
   THEN
      DBMS_OUTPUT.put ('parameter value length is: ');
      DBMS_OUTPUT.put_line (intval);
   END IF;

DBMS_OUTPUT.put ('parameter type is: ');

   IF partyp = 1
   THEN
      DBMS_OUTPUT.put_line ('string');
   ELSE
      DBMS_OUTPUT.put_line ('integer');
   END IF;
END;
/

结果：

Session altered.
parameter value is: denglt
parameter value length is: 6
parameter type is: string
PL/SQL procedure successfully completed.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/195110/viewspace-710119/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/195110/viewspace-710119/