White Papers

On Loading and Extents

Category: Data Management, Software and Web Development

Overview Parallel DDL and operations such as a direct path load via SQL*Loader rely on direct path operations. That is, the data is not passed to the buffer cache to be written later; rather, an operation such as a CREATE TABLE AS SELECT will create new extents and write directly to them, and the data goes straight from the query to disk in those newly allocated extents. Each parallel execution server performing its part of the CREATE TABLE AS SELECT writes to its own extent. The INSERT /+ APPEND / (a direct path insert) writes above a segment's High-Water Mark (HWM), and each parallel execution server again writes to its own set of extents, never sharing them with other parallel execution servers.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Please disable any pop-up blocking software before downloading.

Publisher: Oracle
File Format: HTML
Date Published: May 1, 2007
Format: White Papers
Topics: Programming Languages, Database Management

Similiar White Papers

Building a Hybrid Data Warehouse Model

This paper discusses the hybrid design and provides a fully functional reference implementation. The system runs on Orac

Publisher: Oracle | Tags: data, database, warehouse

MySQL Stored Procedure Programming: Error Handling

The perfect programmer, living in a perfect world, would always write programs that anticipate every possible circumstan

Publisher: O'Reilly Media | Tags: applications, business applications, server, shuttle, software

MSDN Webcast: Using LINQ With Relational Data (Level 100)

One of the most common forms of data used in applications today continues to be relational data that is stored in variou

Publisher: Microsoft | Tags: applications, data, database

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)

This webcast is for Transact-SQL (T-SQL) lover. The presenter introduces to several new features of SQL Server 2008, inc

Publisher: Microsoft | Tags: data

Efficient Use of PL/SOL String Functions for Unicode Applications

This white paper focuses on performing implications of PL/SQL applications for Unicode database server using a UTF-8 dat

Publisher: Oracle Corporation | Tags: applications, database, server

Oracle White Papers

Featured white papers

Achieving PCI Compliance for:Privileged Password Management & Remote Vendor Access

e-DMZ Security

For multi-store outlets, including retail, banking, grocery, gas, hospitality, convenience stores and others, reducing (or avoiding) the cost of in-store system support and maintenance while maintaining compliance with PCI and other requirements has become a strategic challenge.

Download now »
Web 2.0 Security Threats: How to Protect Your Enterprise Network

Qualys

Speaker: Dr. Chenxi Wang, Principal Analyst, Security and Risk Management, Forrester Research, Inc. As Enterprises are increasingly connected to the Internet and as hard organizational boundaries are fast disappearing, security professionals are facing fresh challenges in Enterprise computing.

Download now »
MindManager - Tutorial for New Users - Short

Mindjet

This tutorial is for new MindManager users and teaches you how to get started, by creating maps, reading maps and organizing your information.

Download now »