Oracle PRVT_SMGUTIL

Oracle PRVT_SMGUTIL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

AUTHID DEFINER

Dependencies

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

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');

      BEGIN prvt_smgutil.check_pack_enabled('RAT'); END;

      *

      ERROR at line 1:

      ORA-13722: invalid input value for procedure argument PACK_NAME

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

      ORA-06512: at "SYS.PRVT_SMGUTIL", line 41

      ORA-06512: at line 1

      

      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);

      BEGIN prvt_smgutil.validate_arg_len('TEST', 'MORGAN', 1); END;

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

      ORA-06512: at "SYS.PRVT_SMGUTIL", line 137

      ORA-06512: at line 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.