How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
79 DBMS_ILM → ) strategies using Automatic Data Optimization (ADO) policies. See Also: Oracle Database VLDB and
END_SQL_BLOCK Procedure → Statement Queuing with Resource Manager\" in Oracle Database VLDB and Partitioning Guide.
36 DBMS_COMPRESSION → Oracle Database SQL Language Reference Oracle Database Data Warehousing Guide Oracle Database VLDB and
BEGIN_SQL_BLOCK Procedure → Parallel Statement Queuing with Resource Manager\" in Oracle Database VLDB and Partitioning Guide.
C.3.128 resmgr:pq queued → degree of parallelism Parameter Description location Location of the wait See Also: Oracle Database VLDB
About the Database Buffer Cache → statements Oracle Database VLDB and Partitioning Guide for information about parallel execution
5.1.3 Using Partitioned Spatial Indexes → and partitioned indexes, see Oracle Database VLDB and Partitioning Guide. A partitioned spatial index
Overview of Partitions → quarter. See Also: Oracle Database VLDB and Partitioning Guide for an introduction to partitioning
In range partitioning, the database maps rows to partitions based on ranges of values of the partitioning… → Partitioned Index Description of \"Figure 4-6 Global Partitioned Index\" See Also: Oracle Database VLDB and
20.2.9 Consider Using Attribute-Clustered Tables → See Oracle Database VLDB and Partitioning Guide. Attribute clustering is ignored for conventional DML
Examples illustrate online redefinition of tables. → … Likewise for mapping tables. See Also: The section \"Exchanging Partitions\" in Oracle Database VLDB
You use the CREATE_PLAN_DIRECTIVE procedure to create resource plan directives. Each directive belongs… → Statement Queuing Using Parallel Server Limit \" Oracle Database VLDB and Partitioning Guide for information about parallel statement queuing
20.12.1 What Are Index-Organized Tables? → Concepts for a more thorough description of index-organized tables Oracle Database VLDB and Partitioning
Table 19-1 Data Warehouses and OLTP Systems → Warehousing Guide for a more detailed description of a database warehouse Oracle Database VLDB and
An example illustrates managing parallel statements using directive attributes. → Database VLDB and Partitioning Guide for more information about parallel statement queuing Note
About Dropping Partitioned Tables → Oracle Database processes a DROP TABLE statement for a partitioned table in the same way that it processes the statement for a nonpartitioned table. One exception is when you use the PURGE keyword. To avoid running into resource constraints, the DROP TABLE... PURGE statement for a partitioned table drops the table in multiple transactions, where each transaction drops a subset of the partitions or
About Merging Partitions and Subpartitions → Use the ALTER TABLE MERGE PARTITION statement to merge the contents of two partitions into one partition. The two original partitions are dropped, as are any corresponding local indexes. You cannot use this statement for a hash partitioned table or for hash subpartitions of a composite *-hash partitioned table. You cannot merge partitions for a reference-partitioned table. Instead, a merge operation
PARALLEL_MIN_PERCENT → This parameter enables users to wait for an acceptable DOP, depending on the application in use. The recommended value for the PARALLEL_MIN_PERCENT parameter is 0 (zero). Setting this parameter to values other than 0 (zero) causes Oracle Database to return an error when the requested DOP cannot be satisfied by the system at a given time. For example, if you set PARALLEL_MIN_PERCENT to 50, which translates
Partitioning Restrictions for Multiple Block Sizes → Use caution when creating partitioned objects in a database with tablespaces of different block sizes. The storage of partitioned objects in such tablespaces is subject to some restrictions. Specifically, all partitions of the following entities must reside in tablespaces of the same block size: Conventional tables Indexes Primary key index segments of index-organized tables Overflow segments of index-organized
Partition Pruning → Partition pruning is the simplest and also the most substantial means to improve performance using partitioning. Partition pruning can often improve query performance by several orders of magnitude. For example, suppose an application contains an Orders table containing a historical record of orders, and that this table has been partitioned by week. A query requesting orders for a single week would