Oracle PRVT_SQLPROF_INFRA
Version 20c

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.

Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.
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
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);

Related Topics
Built-in Functions
Built-in Packages
DBMS_SQLPA
DBMS_SQLTUNE
PRVT_SQLSET_INFRA
What's New In 19c
What's New In 20c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx