You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DBA_SQL_PROFILES


1 to 6 of 6 results.


Database Reference, 12c Release 1 (12.1)

DBA_SQL_PROFILES

5.324 DBA_SQL_PROFILESDBA_SQL_PROFILES displays information about SQL profiles currently created for specific SQL

Database SQL Tuning Guide, 12c Release 1 (12.1)

Managing SQL Profiles

Listing SQL ProfilesThe data dictionary view DBA_SQL_PROFILES stores SQL profiles persistently in the database. The … , and then query the DBA_SQL_PROFILES view. For example, execute the following query: COLUMN category … FORMAT a10 COLUMN sql_text FORMAT a20 SELECT NAME, SQL_TEXT, CATEGORY, STATUS FROM DBA_SQL_PROFILES … = 'internet' group by p.promo_na

Database Error Messages, 12c Release 1 (12.1)

ORA-12700 to ORA-19400

ORA-13842: no SELECT privilege on DBA_SQL_PROFILESDBA_SQL_PROFILES view. Action: Either perform the operation as another user or get the privilege

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_SQLTUNE

SQLTEXT_TO_SIGNATURE Functiondba_sql_profiles. See Also: SQL Profile Subprograms for other subprograms in this group Syntax

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_SQLTUNE

REPORT_SQL_DETAIL FunctionDBA_HIST_SQL_BIND_METADATA DBA_HIST_SQLTEXT DBA_SQL_PLAN_BASELINES DBA_SQL_PROFILES DBA_ADVISOR_TASKS

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsDBA_SQL_PLAN_DIR_OBJECTS 5.323 DBA_SQL_PLAN_DIRECTIVES 5.324 DBA_SQL_PROFILES 5.325 DBA_SQL_TRANSLATION_PROFILES