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 USER_ADVISOR_SQLPLANS


1 to 4 of 4 results.


Database Reference, 12c Release 1 (12.1)

USER_ADVISOR_SQLPLANS

6.270 USER_ADVISOR_SQLPLANSUSER_ADVISOR_SQLPLANS displays the different SQL execution plans owned by the current user

Database Reference, 12c Release 1 (12.1)

DBA_ADVISOR_SQLPLANS

4.34 DBA_ADVISOR_SQLPLANSanalysis. Related View USER_ADVISOR_SQLPLANS displays the different SQL execution plans owned by the … of optimizer hints that can be used to regenerate the same plan See Also: \" USER_ADVISOR_SQLPLANS \"

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsUSER_ADVISOR_SQLA_WK_STMTS 6.270 USER_ADVISOR_SQLPLANS 6.271 USER_ADVISOR_SQLSTATS 6.272 USER_ADVISOR_SQLW_JOURNAL 6.273

Database Testing Guide, 12c Release 1 (12.1)

Using SQL Performance Analyzer Views

6.2.7 Using SQL Performance Analyzer Viewsand USER_ADVISOR_SQLPLANS views display a list of all execution plans. The DBA_ADVISOR_SQLSTATS and