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_HIST_SQLTEXT


1 to 7 of 7 results.


Database Reference, 12c Release 1 (12.1)

DBA_HIST_SQLTEXT

5.61 DBA_HIST_SQLTEXTDBA_HIST_SQLTEXT displays the text of SQL statements belonging to shared SQL cursors captured in

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

DBMS_XPLAN

Security ModelSELECT or READ privileges on DBA_HIST_SQL_PLAN, DBA_HIST_SQLTEXT, and V$DATABASE. Using the

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

DBMS_XPLAN

DISPLAY_AWR Functionappropriate value for the SQL statement of interest by querying the column SQL_ID in DBA_HIST_SQLTEXT … user must have SELECT or READ privilege on DBA_HIST_SQL_PLAN, DBA_HIST_SQLTEXT, and V$DATABASE … statements containing the string ' TOTO ': SELECT tf.* FROM DBA_HIST_SQLTEXT ht, table

Database Reference, 12c Release 1 (12.1)

DBA_HIST_SQLSTAT

5.60 DBA_HIST_SQLSTATview is used with the DBA_HIST_OPTIMIZER_ENV, DBA_HIST_SQLTEXT, and DBA_HIST_SQL_PLAN views to … : \" DBA_HIST_SNAPSHOT \" \" DBA_HIST_OPTIMIZER_ENV \" \" DBA_HIST_SQLTEXT \" \" DBA_HIST_SQL_PLAN \" Oracle Database PL

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_HIST_SQL_WORKAREA_HSTGRM 5.58 DBA_HIST_SQLBIND 5.59 DBA_HIST_SQLCOMMAND_NAME 5.60 DBA_HIST_SQLSTAT 5.61 DBA_HIST_SQLTEXT

Database Error Messages, 12c Release 1 (12.1)

ORA-12700 to ORA-19400

ORA-13774: insufficient privileges to select data from the workload repositoryviews DBA_HIST_BASELINE, DBA_HIST_SQLTEXT, DBA_HIST_SQLSTAT, DBA_HIST_SQLBIND, DBA_HIST_OPTIMIZER_ENV