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 40 of 750 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Database VLDB and Partitioning Guide - Contents

ContentsRelated 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

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

VLDB and Partitioning

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 … challenges surrounding backup and recovery for a VLDB. Storage is a key component of a very large … database. Storage Management

Database Readme, 12c Release 1 (12.1)

Documentation Addendum

4.14 Oracle Database VLDB and Partitioning GuideNote the following changes in Oracle Database VLDB and Partitioning Guide part number E41057: It

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

NO_PQ_CONCURRENT_UNION Hintprocessing of UNION and UNION ALL operations. See Also: \"PQ_CONCURRENT_UNION Hint\" Oracle Database VLDB

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

PQ_CONCURRENT_UNION HintUNION and UNION ALL operations. See Also: \"NO_PQ_CONCURRENT_UNION Hint\" Oracle Database VLDB and Partitioning Guide for information about using this hint

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

ENABLE_PARALLEL_DML HintALTER SESSION ENABLE PARALLEL DML statement. See Also: Oracle Database VLDB and Partitioning Guide

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Changes in This Release for Oracle Database VLDB and Partitioning Guide

Changes in This Release for Oracle Database VLDB and Partitioning GuideThis chapter describes changes to Oracle Database VLDB and Partitioning Guide. Changes for Very

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

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

Database Concepts, 12c Release 1 (12.1)

Partitions, Views, and Other Schema Objects

Partitioned Indexes\" Oracle Database VLDB and Partitioning Guide and Oracle Database SQL Tuning Guide for more information

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Resources with Oracle Database Resource Manager

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

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tables

20.2.2 Specify the Type of Table to Createadministration. Partitioned tables are discussed in Oracle Database VLDB and Partitioning Guide.

Database Concepts, 12c Release 1 (12.1)

Partitions, Views, and Other Schema Objects

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

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tables

20.6.1 Reasons for Using the ALTER TABLE Statementsubpartitions at a time, such as split partition and merge partitions operations. See Oracle Database VLDB

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Changes in This Release for Oracle Database VLDB and Partitioning Guide

Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1 (12.1.0.2)The following are changes in Very Large Databases and Partitioning for Oracle Database 12 c Release 1 (12.1.0.2). New Features

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Changes in This Release for Oracle Database VLDB and Partitioning Guide

Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1 (12.1.0.1)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

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tables

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

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tables

20.7.9 Online Redefinition of One or More Partitionssubpartition that is being moved. See \" Moving a Table to a New Segment or Tablespace \". See Also: Oracle Database VLDB and Partitioning Guide

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Processes

5.6.1 About Parallel Execution ServersDatabase SQL Tuning Guide for information about using parallel hints Oracle Database VLDB and

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tables

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

Database Concepts, 12c Release 1 (12.1)

Indexes and Index-Organized Tables

Secondary Indexes on Index-Organized Tablesindex-organized table Oracle Database VLDB and Partitioning Guide to learn about creating secondary indexes on indexed-organized table partitions

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_ILM

79 DBMS_ILM) strategies using Automatic Data Optimization (ADO) policies. See Also: Oracle Database VLDB and

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_RESOURCE_MANAGER

END_SQL_BLOCK ProcedureStatement Queuing with Resource Manager\" in Oracle Database VLDB and Partitioning Guide.

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_COMPRESSION

36 DBMS_COMPRESSIONOracle Database SQL Language Reference Oracle Database Data Warehousing Guide Oracle Database VLDB and

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_RESOURCE_MANAGER

BEGIN_SQL_BLOCK ProcedureParallel Statement Queuing with Resource Manager\" in Oracle Database VLDB and Partitioning Guide.

Database Reference, 12c Release 1 (12.1)

resmgr:pq queued

C.3.128 resmgr:pq queueddegree of parallelism Parameter Description location Location of the wait See Also: Oracle Database VLDB

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Database Buffer Cache

About the Database Buffer Cachestatements Oracle Database VLDB and Partitioning Guide for information about parallel execution

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Using Partitioned Spatial Indexes

5.1.3 Using Partitioned Spatial Indexesand partitioned indexes, see Oracle Database VLDB and Partitioning Guide. A partitioned spatial index

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Parameters Affecting Resource Consumption for Parallel DML and Parallel DDL

FAST_START_PARALLEL_ROLLBACKIf a system fails when there are uncommitted parallel DML or DDL transactions, you can speed up transaction recovery during startup by using the FAST_START_PARALLEL_ROLLBACK parameter. This parameter controls the DOP used when recovering terminated transactions. Terminated transactions are transactions that are active before a system failure. By default, the DOP is chosen to be at most two times the

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Rules for CREATE TABLE AS SELECT

Degree of Parallelism (CREATE Part)The DOP for the CREATE operation, and for the SELECT operation if it is parallelized, is specified by the PARALLEL clause of the CREATE statement, unless it is overridden by an ALTER SESSION FORCE PARALLEL DDL statement. If the PARALLEL clause does not specify the DOP, the default is the number of CPUs.

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Creating Composite List-Range Partitioned Tables

Creating Composite List-Range Partitioned TablesExample 4-14 shows an accounts table that is list partitioned by region and subpartitioned using range by account balance, and row movement is enabled. Subpartitions for different list partitions could have different ranges specified. To learn how using a subpartition template can simplify the specification of a composite partitioned table, see \" Specifying Subpartition Templates to Describe Composite

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Creating Reference-Partitioned Tables

Creating Reference-Partitioned TablesTo create a reference-partitioned table, you specify a PARTITION BY REFERENCE clause in the CREATE TABLE statement. This clause specifies the name of a referential constraint and this constraint becomes the partitioning referential constraint that is used as the basis for reference partitioning in the table. The referential constraint must be enabled and enforced. As with other partitioned tables,

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Single-Level Partitioning

Single-Level PartitioningA table is defined by specifying one of the following data distribution methodologies, using one or more columns as the partitioning key: Range Partitioning Hash Partitioning List Partitioning For example, consider a table with a column of type NUMBER as the partitioning key and two partitions less_than_five_hundred and less_than_one_thousand. The less_than_one_thousand partition contains rows where

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Creating a Composite Range-List Partitioned Table

Creating a Composite Range-List Partitioned TableExample 4-10 illustrates how range-list partitioning might be used. The example tracks sales data of products by quarters and within each quarter, groups it by specified states. A row is mapped to a partition by checking whether the value of the partitioning column for a row falls within a specific partition range. The row is then mapped to a subpartition within that partition by identifying the subpartition

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Truncating Multiple Partitions

Truncating Multiple PartitionsYou can truncate multiple partitions from a range or list partitioned table with the TRUNCATE PARTITION clause of the ALTER TABLE statement. The corresponding partitions of local indexes are truncated in the operation. Global indexes must be rebuilt unless UPDATE INDEXES is specified.For example, the following SQL statement truncates multiple partitions in the range-partitioned sales table. ALTER

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Exchanging a Hash Partitioned Table with a *-Hash Partition

Exchanging a Hash Partitioned Table with a *-Hash PartitionIn this example, you are exchanging a whole hash partitioned table, with all of its partitions, with the partition of a *-hash partitioned table and all of its hash subpartitions. The following example illustrates this concept for a range-hash partitioned table. First, create a hash partitioned table: CREATE TABLE t1 (i NUMBER, j NUMBER) PARTITION BY HASH(i) (PARTITION p1, PARTITION p2); Populate

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Best Practice 1: Use ARCHIVELOG Mode

Best Practice 1: Use ARCHIVELOG ModeArchived redo logs are crucial for recovery when no data can be lost because they constitute a record of changes to the database. Oracle Database can be run in either of two modes: ARCHIVELOG Oracle Database archives the filled online redo log files before reusing them in the cycle. NOARCHIVELOG Oracle Database does not archive the filled online redo log files before reusing them in the cycle. Running

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Best Practice 6: Plan for NOLOGGING Operations in Your Backup/Recovery Strategy

Extract, Transform, and LoadThe 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

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Concurrent Execution of Union All

Concurrent Execution of Union AllSet operators like UNION or UNION ALL consist of multiple queries (branches) combined to a single SQL statement. Traditionally, set operators are processed in a sequential manner. Individual branches can be processed in serial or parallel, but only one branch at a time, one branch after another. While this approach satisfies many use cases, there are situations where the processing of multiple branches

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

About Modifying List Partitions: Adding Values

About Modifying List Partitions: Adding ValuesList 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

Database VLDB and Partitioning Guide, 12c Release 1 (12.1)

Partitioning Overview

Partitioning OverviewPartitioning allows a table, index, or index-organized table to be subdivided into smaller pieces, where each piece of such a database object is called a partition. Each partition has its own name, and may optionally have its own storage characteristics. This section contains the following topics: Basics of Partitioning Partitioning Key Partitioned Tables Partitioned Index-Organized Tables System