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 → Introduction to Partitioning VLDB and Partitioning Partitioning As the Foundation for Information
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 … Recovering VLDBs\" addresses the challenges surrounding backup and recovery for a VLDB. Storage is a key … component of a very
Consider Parallelizing Index Creation → creation. See Also: Oracle Database VLDB and Partitioning Guide for information about using parallel execution
Oracle® Database → VLDB and Partitioning Guide 11 g Release 2 (11.2) E25523-01 September 2011 Oracle Database VLDB and
Degree of Parallelism Limit → a consumer group. See Also: Oracle Database VLDB and Partitioning Guide for more information about
Specify the Type of Table to Create → simplify and reduce the time required for backup and administration. Partitioned tables are discussed in Oracle Database VLDB and Partitioning Guide.
About Parallel Execution Servers → statements. See Also: Oracle Database VLDB and Partitioning Guide for more information about using parallel execution
7.2.1 Using the Buffer Cache Effectively → : Chapter 16, \"SQL Tuning Overview\" Oracle Database VLDB and Partitioning Guide to learn more using parallel execution
Online Redefinition of a Single Partition → \" in Oracle Database VLDB and Partitioning Guide Oracle Database SQL Language Reference for details on … LOB columns. See Also: The section \"Exchanging Partitions\" in Oracle Database VLDB and Partitioning Guide
Parallelizing Table Creation → number of parallel execution servers when creating the table. See Also: Oracle Database VLDB and
Table 11-2 Table Caching Criteria → VLDB and Partitioning Guide to learn more using parallel execution
Bitmap Indexes on Partitioned Tables → or nonpartitioned. See Also: Oracle Database VLDB and Partitioning Guide for more information
What Are Index-Organized Tables? → Database VLDB and Partitioning Guide for information about partitioning index-organized tables
CPU → statement. See Also: Oracle Database VLDB and Partitioning Guide for information about parallel statement
Parallel Queue Timeout → ( MGMT_P1, MGMT_P2, and so on) in your resource plan. See Also: Oracle Database VLDB and Partitioning Guide
Considerations When Using Read-Only Tablespaces → When a referential integrity constraint is defined between parent and child tables, an index is defined on the foreign key, and the tablespace in which that index resides is made read-only. Then the integrity check for the constraint is implemented in SQL and not through consistent read buffer access. The implication of this is that, if the child is partitioned, only some child partitions have their
Lifecycle Setup → The Lifecycle Setup area of the ILM Assistant consists of the following tasks that must be performed to prepare for managing your data: Logical Storage Tiers Lifecycle Definitions Lifecycle Tables Preferences If this is the first time that you have used the ILM Assistant, then it is here where you specify exactly how the data is to be managed by the ILM Assistant. The following steps must be completed
Viewing Information About Partitioned Tables and Indexes → Table 4-4 lists the views that contain information specific to partitioned tables and indexes: Table 4-4 Views With Information Specific to Partitioned Tables and Indexes
Bigger Individual Tables: More Rows in Tables → It takes longer to scan a big table than it takes to scan a small table. Queries against partitioned tables may access one or more partitions that are small in contrast to the total size of the table. Similarly, queries may take advantage of partition elimination on indexes. It takes less time to read a smaller portion of an index from disk than to read the entire index. Index structures that share
Example: Using EXPLAIN PLAN to Show Parallel Operations → The following example illustrates how the optimizer intends to execute a parallel query: explain plan for SELECT /*+ PARALLEL */ cust_first_name, cust_last_name FROM customers c, sales s WHERE c.cust_id = s.cust_id; ---------------------------------------------------------- | Id | Operation | Name | ---------------------------------------------------------- | 0 | SELECT STATEMENT | | | 1 | PX COORDINATOR