Oracle | PRVT_SQLPROF

Oracle PRVT_SQLPROF_INFRA 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 package called by DBMS_SQLTUNE.

AUTHID DEFINER

Dependencies

DBMS_MANAGEMENT_PACKS	DBMS_SQLTUNE	DBMS_SQLTUNE_INTERNAL
DBMS_SQLDIAG

Documented No

Exceptions

Error Code	Reason
ORA-13833	SQL profile or patch named UWSQLPROF doesn't exist

First Available Not Known

Security Model Owned by SYS with no privileges granted

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

Subprograms

ACCEPT_SQL_PROFILE	DROP_ALL_SQL_PROFILES	DROP_SQL_PROFILE
ALTER_SQL_PROFILE

ACCEPT_SQL_PROFILE

Accept the named SQL profile corresponding with the input criteria

Called by DBMS_SQLTUNE ACCEPT_SQL_PROFILE prv_sqlprof_infra.accept_sql_profile( task_name IN VARCHAR2, advisor_name IN VARCHAR2, object_id IN NUMBER, name IN VARCHAR2, description IN VARCHAR2, category IN VARCHAR2, task_owner IN VARCHAR2, replace IN BOOLEAN, FORCE_MATCH IN BOOLEAN, is_patch IN BOOLEAN, profile_type IN VARCHAR2, profile_creator IN VARCHAR2) RETURN VARCHAR2;

Follow the DBMS_SQLTUNE link at page bottom

ALTER_SQL_PROFILE

Alters the named SQL Profile

Called by DBMS_SQLTUNE ALTER_SQL_PROFILE prv_sqlprof_infra.alter_sql_profile( name IN VARCHAR2, attribute_name IN VARCHAR2, value IN VARCHAR2, is_patch IN BOOLEAN);

Follow the DBMS_SQLTUNE link at page bottom

DROP_ALL_SQL_PROFILES

Drops all SQL Profiles prvt_sqlprof_infra.drop_all_sql_profiles;

exec prvt_sqlprof_infra.drop_all_sql_profiles;

      

      PL/SQL procedure successfully completed.

DROP_SQL_PROFILE

Drops the named SQL Profile

Called by DBMS_SQLTUNE DROP_SQL_PROFILE prvt_sqlprof_infra.drop_sql_profile( name IN VARCHAR2, ignore IN BOOLEAN, is_patch IN BOOLEAN);

exec prvt_sqlprof_infra.drop_sql_profile('emp_dept_profile', FALSE, FALSE);