Oracle | PRVT

Oracle PRVT_SMGUTIL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal support for Management Packs and Real Application Testing (RAT)

AUTHID DEFINER

Dependencies

DBMS_ADDM	DBMS_RAT_MASK_INTERNAL	PRVTEMX_ADMIN
DBMS_ADVISOR	DBMS_SQLPA	PRVTEMX_CELL
DBMS_ASH_INTERNAL	DBMS_SQLTUNE	PRVT_ADVISOR
DBMS_KEG_LIB	DBMS_SYS_ERROR	PRVT_AWR_VIEWER
DBMS_MANAGEMENT_PACKS	DBMS_WRR_PROTECTED	PRVT_HDM
DBMS_PERF

Documented No

Exceptions

Error Code	Reason
`ORA-13722`	`invalid input value for procedure argument PACK_NAME`

First Available Not Known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvssmgu.plb

Subprograms

CHECK_PACK_ENABLED	IS_PACK_ENABLED	PRVT_PACK_ENABLED
CHECK_RAT_OPTION	IS_RAT_OPTION_ENABLED	VALIDATE_ARG_LEN

CHECK_PACK_ENABLED

Completes successfully if the named pack is enabled prvt_smgutil.check_pack_enabled(pack_name IN VARCHAR2);

exec prvt_smgutil.check_pack_enabled('RAT');

           *

      ORA-13722: invalid input value for procedure argument PACK_NAME

      

      exec prvt_smgutil.check_pack_enabled('TUNING');

      

      PL/SQL procedure successfully completed.

CHECK_RAT_OPTION

Completes successfully if Real Application Clusters is a valid option prvt_smgutil.check_rat_option;

exec prvt_smgutil.check_rat_option;

      

      PL/SQL procedure successfully completed.

IS_PACK_ENABLED

Completes successfully if the named pack is enabled prvt_smgutil.is_pack_enabled(pack_name IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF prvt_smgutil.is_pack_enabled('DIAGNOSTIC') THEN

          dbms_output.put_line('Enabled');

        ELSE

          dbms_output.put_line('Disabled');

        END IF;

      END;

      /

      Enabled

      

      PL/SQL procedure successfully completed.

IS_RAT_OPTION_ENABLED

Completes successfully if Real Application Testing is enabled prvt_smgutil.is_rat_option_enabled RETURN BOOLEAN;

BEGIN

        IF prvt_smgutil.is_rat_option_enabled THEN

          dbms_output.put_line('Enabled');

        ELSE

          dbms_output.put_line('Disabled');

        END IF;

      END;

      /

      Enabled

      

      PL/SQL procedure successfully completed.

PRVT_PACK_ENABLED

Returns 1 of the identified pack is enabled prvt_smgutil.prvt_pack_enabled( pack_name IN BINARY_INTEGER, raise_error IN BINARY_INTEGER) RETURN BINARY_INTEGER;

DECLARE

       retVal BINARY_INTEGER;

      BEGIN

        retVal := prvt_smgutil.prvt_pack_enabled(2, 7445);

          dbms_output.put_line(retVal);

      END;

      /

      1

      

      PL/SQL procedure successfully completed.

VALIDATE_ARG_LEN

Undocumented prvt_smgutil.validate_arg_len( p_value IN VARCHAR2, p_name IN VARCHAR2, p_len IN NUMBER);

exec prvt_smgutil.validate_arg_len('TEST', 'MORGAN', 1);

          
      *

      ORA-13723: input value for procedure argument MORGAN exceeds maximum allowed length of 1

      

      -- note that the following is also a violation of ORA-13723

      -- likely an invalid exception message as a P_LEN of 3 also fails

      

      exec prvt_smgutil.validate_arg_len('TEST', 'MORGAN', 4);

      

      PL/SQL procedure successfully completed.