Oracle | PRVT_SQLPROF

Oracle PRVT_SQLPROF_INFRA Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

      

      PL/SQL procedure successfully completed.