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
Contents → Related Documents Conventions Changes in This Release for Oracle Database VLDB and Partitioning Guide … Partitioning VLDB and Partitioning Partitioning As the Foundation for Information Lifecycle Management
VLDB and Partitioning → A very large database has no minimum absolute size. Although a VLDB is a database like smaller … databases, there are specific challenges in managing a VLDB. These challenges are related to the sheer … challenges surrounding backup and recovery for a VLDB. Storage is a key component of a very large … database. Storage Management
4.9 Oracle Database VLDB and Partitioning Guide → Note the following changes in Oracle Database VLDB and Partitioning Guide: It was incorrectly
PQ_CONCURRENT_UNION Hint → UNION and UNION ALL operations. See Also: \"NO_PQ_CONCURRENT_UNION Hint\" Oracle Database VLDB and Partitioning Guide for information about using this hint
NO_PQ_CONCURRENT_UNION Hint → processing of UNION and UNION ALL operations. See Also: \"PQ_CONCURRENT_UNION Hint\" Oracle Database VLDB
ENABLE_PARALLEL_DML Hint → ALTER SESSION ENABLE PARALLEL DML statement. See Also: Oracle Database VLDB and Partitioning Guide
Changes in This Release for Oracle Database VLDB and Partitioning Guide → This chapter describes changes to Oracle Database VLDB and Partitioning Guide. Changes for Very
21.2.9 Consider Parallelizing Index Creation → creation. See Also: Oracle Database VLDB and Partitioning Guide for information about using parallel execution
Partitioned Indexes → \" Oracle Database VLDB and Partitioning Guide and Oracle Database SQL Tuning Guide for more information
Use the PARALLEL_SERVER_LIMIT directive attribute to specify the maximum percentage of the parallel… → degree of parallelism for a consumer group. See Also: Oracle Database VLDB and Partitioning Guide for
20.2.2 Specify the Type of Table to Create → administration. Partitioned tables are discussed in Oracle Database VLDB and Partitioning Guide.
In range partitioning, the database maps rows to partitions based on ranges of values of the partitioning… → , whereas a query that uses a local nonprefixed index might not. See Also: Oracle Database VLDB and
20.6.1 Reasons for Using the ALTER TABLE Statement → subpartitions at a time, such as split partition and merge partitions operations. See Oracle Database VLDB
Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1 (18.104.22.168) → The following are changes in Very Large Databases and Partitioning for Oracle Database 12 c Release 1 (22.214.171.124). New Features
Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1 (126.96.36.199) → Automatic Big Table Caching Automatic big table caching enhances in-memory query capabilities of Oracle Database in both single instance and Oracle Real Application Clusters (Oracle RAC) environments using a temperature based algorithm with the big table cache. In Oracle RAC environments, this feature is supported only with parallel queries. In single instance environments, this feature is supported
20.7.9 Online Redefinition of One or More Partitions → subpartition that is being moved. See \" Moving a Table to a New Segment or Tablespace \". See Also: Oracle Database VLDB and Partitioning Guide
20.3.3 Parallelizing Table Creation → number of parallel execution servers when creating the table. See Also: Oracle Database VLDB and
5.6.1 About Parallel Execution Servers → Database SQL Tuning Guide for information about using parallel hints Oracle Database VLDB and
Oracle Database includes the following components: the Oracle Database instance, which is a collection… → UPDATE INDEXES ONLINE; See Also: Oracle Database VLDB and Partitioning Guide Oracle Database SQL Language Reference
Secondary Indexes on Index-Organized Tables → index-organized table Oracle Database VLDB and Partitioning Guide to learn about creating secondary indexes on indexed-organized table partitions
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
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
The Importance of Nonprefixed Indexes → Nonprefixed indexes are particularly useful in historical databases. In a table containing historical data, it is common for an index to be defined on one column to support the requirements of fast access by that column. However, the index can also be partitioned on another column (the same column as the underlying table) to support the time interval for rolling out old data and rolling in new data.
Extract, Transform, and Load → The ETL process uses several Oracle features and a combination of methods to load (re-load) data into a data warehouse. These features consist of: Transportable tablespaces Transportable tablespaces allow users to quickly move a tablespace across Oracle Databases. It is the most efficient way to move bulk data between databases. Oracle Database provides the ability to transport tablespaces across
Incremental Data Loading in Parallel → Parallel DML combined with the updatable join views facility provides an efficient solution for refreshing the tables of a data warehouse system. To refresh tables is to update them with the differential data generated from the OLTP production system. In the following example, assume a refresh of a table named customers that has columns c_key, c_name, and c_addr. The differential data contains either
Creating List-Partitioned Index-Organized Tables → The other option for partitioning index-organized tables is to use the list method. In the following example, the sales index-organized table is partitioned by the list method. Example 4-24 uses the example tablespace, which is part of the sample schemas in your seed database. Normally you would specify different tablespace storage for different partitions. Example 4-24 Creating a list-partitioned
About Modifying List Partitions: Adding Values → List partitioning enables you to optionally add literal values from the defining value list. This section contains the following topics: Adding Values for a List Partition Adding Values for a List Subpartition
Partition Placement → Partition placement is not a concern if you stripe across all available devices and distribute the load across all available resources. If you cannot stripe data files across all available devices, then consider partition placement to optimize the use of all available hardware resources (physical disk spindles, disk controllers, and channels to disk). I/O-intensive queries or DML operations should
Enabling and Disabling Heat Map → You can enable and disable heat map tracking at the system or session level with the ALTER SYSTEM or ALTER SESSION statement using the HEAT_MAP clause. For example, the following SQL statement enables Heat Map tracking for the database instance. ALTER SYSTEM SET HEAT_MAP = ON; When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX
Impact of a Partition Maintenance Operation on a Partitioned Table with Local Indexes → When a partition maintenance operation takes place, Oracle Database locks the affected table partitions for any DML operation, except in the case of an ONLINE MOVE. Data in the affected partitions, except a DROP or TRUNCATE operation, is still fully accessible for any SELECT operation. Because local indexes are logically coupled with the table (data) partitions, only the local index partitions of