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 VLDB


1 to 20 of 482 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Database VLDB and Partitioning Guide - Contents

ContentsIntroduction to Partitioning VLDB and Partitioning Partitioning As the Foundation for Information

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Introduction to Very Large Databases

VLDB and PartitioningA 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

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Consider Parallelizing Index Creationcreation. See Also: Oracle Database VLDB and Partitioning Guide for information about using parallel execution

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Oracle Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Oracle® DatabaseVLDB and Partitioning Guide 11 g Release 2 (11.2) E25523-01 September 2011 Oracle Database VLDB and

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Resources with Oracle Database Resource Manager

Degree of Parallelism Limita consumer group. See Also: Oracle Database VLDB and Partitioning Guide for more information about

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Specify the Type of Table to Createsimplify and reduce the time required for backup and administration. Partitioned tables are discussed in Oracle Database VLDB and Partitioning Guide.

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Processes

About Parallel Execution Serversstatements. See Also: Oracle Database VLDB and Partitioning Guide for more information about using parallel execution

Database Performance Tuning Guide, 11g Release 2 (11.2)

Configuring and Using Memory

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

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

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

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Parallelizing Table Creationnumber of parallel execution servers when creating the table. See Also: Oracle Database VLDB and

Database Performance Tuning Guide, 11g Release 2 (11.2)

The Query Optimizer

Table 11-2 Table Caching CriteriaVLDB and Partitioning Guide to learn more using parallel execution

Database Data Warehousing Guide, 11g Release 2 (11.2)

Indexes

Bitmap Indexes on Partitioned Tablesor nonpartitioned. See Also: Oracle Database VLDB and Partitioning Guide for more information

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

What Are Index-Organized Tables?Database VLDB and Partitioning Guide for information about partitioning index-organized tables

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Resources with Oracle Database Resource Manager

CPUstatement. See Also: Oracle Database VLDB and Partitioning Guide for information about parallel statement

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Resources with Oracle Database Resource Manager

Parallel Queue Timeout( MGMT_P1, MGMT_P2, and so on) in your resource plan. See Also: Oracle Database VLDB and Partitioning Guide

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Partitioning for Availability, Manageability, and Performance

Considerations When Using Read-Only TablespacesWhen 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

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Using Partitioning for Information Lifecycle Management

Lifecycle SetupThe 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

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Viewing Information About Partitioned Tables and Indexes

Viewing Information About Partitioned Tables and IndexesTable 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

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Using Partitioning in a Data Warehouse Environment

Bigger Individual Tables: More Rows in TablesIt 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

Database VLDB and Partitioning Guide, 11g Release 2 (11.2)

Miscellaneous Parallel Execution Tuning Tips

Example: Using EXPLAIN PLAN to Show Parallel OperationsThe 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