Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.

Related Content you might be interested in

Current Title:

Small book image
Oracle 10g/11g Data and Database Management Utilities
Jun, 2009 | 432 pages
No titles found
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Oracle 10g/11g Data and Database Management Utilities
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
Preface
Preface
Free Chapter
1
Data Pump
Data Pump
Data Pump features
Data Pump architecture
Setting up the practical scenarios
Data Pump export
Data Pump restart capability
Getting information about the export job
Data Pump import
Improving performance with Data Pump
Working with the Data Pump API
Data Pump 11g new features
Summary
2
SQL*Loader
SQL*Loader
SQL*Loader basics
Preparing the demo environment
Specifying a particular character set
Load on the fly
Direct path versus Conventional path load
Loading Large Objects (LOBs)
Loading multimedia files
Resumable load
Parallel load
General performance booster tips
Summary
3
External Tables
External Tables
The External Table basics
Let's setup the environment
Inter-version compatibility
Data transformation with External Tables
Mapping XML files as External Tables
Dynamically changing the external reference
Oracle 11g External Table enhancements
Summary
4
Recovery Manager Advanced Techniques
Recovery Manager Advanced Techniques
Recovery Manager basics
Backup compression
Faster backups through intra-file parallel backup and restore operations (11g only)
Block media recovery
Backup duration and throttling
Database cloning
Inter-platform database migration
Migrate to and from an ASM environment
General backup advices
Summary
5
Recovery Manager Restore and Recovery Techniques
Recovery Manager Restore and Recovery Techniques
Oracle database recovery
Loss of data files
Loss of redo log files
Test restore
Crosscheck command
Nologging considerations
Summary
6
Session Management
Session Management
User sessions in a dedicated server architecture
Blocking sessions
Services
Resource Manager
Active Session History (ASH)
Session monitoring, the traditional way
Summary
7
Oracle Scheduler
Oracle Scheduler
Oracle Scheduler concepts
Getting started with the Oracle Scheduler
Time expression syntax
Programs
Schedules
Jobs and Job Classes
Managing the Scheduler
Data dictionary related views
Summary
8
Oracle Wallet Manager
Oracle Wallet Manager
The Oracle Wallet Manager
Oracle Wallet Manager CSR generation
Storing the Oracle Wallet in the Windows registry
Storing the Wallet in an LDAP server
Using certificates for authentication
Using the Oracle Wallet to store database credentials
Summary
9
Security Management
Security Management
Using the Oracle Wallet to encrypt backups
The enterprise user
Summary
10
Database Configuration Assistant
Database Configuration Assistant
DBCA
Database creation
Database edition
Database template management
Automatic Storage Management configuration
DBCA, Batch mode
Summary
11
Oracle Universal Installer
Oracle Universal Installer
OUI basics
OUI basic and advanced installation modes
Modes of installation
OUI command line parameters
Silent installation mode
The oraparam.ini file
OUI return codes
Installing Oracle from the Web
Recovering a lost Inventory
Cloning Oracle Home using OUI
Summary
12
Enterprise Manager Configuration Assistant
Enterprise Manager Configuration Assistant
Enterprise Manager Components
Enterprise Manager configuration
EMCA Command Line Interface
EMCA 10g Release 1
EM directory structure
Environment changes
Securing Enterprise Manager
Summary
13
OPatch
OPatch
OPatch
Downloading the latest OPatch version
OPatch requirements
OPatch syntax
Oracle maintenance using OPatch
Applying a single patch using OPatch
Querying the Oracle inventory
Rolling back a failed OPatch session
Considerations after applying a patch
OPatch in Oracle 11g
Oracle Configuration Manager Registration
Critical Patch Updates
Hot patching (11g only)
Troubleshooting OPatch
Using Enterprise Manager for software maintenance
Managing Patches in EM 11g
Summary

Parallel load

A parallel load can be used to perform the data load more efficiently. It is a suitable data load strategy for partitioned tables. When performing the load the data file is partitioned so that each single session grabs its piece of data and all the sessions can execute the job simultaneously on the same table.

In order for the user to enable parallel loading, once the data has been split into several files, the clause PARALLEL=TRUE must be specified for each session. If the user is working on a Unix like operating system, then the workload can be left running as a background process.

sqlldr sqlldrdemo/oracle control=pload01.ctl DIRECT=TRUE PARALLEL=TRUE &
sqlldr sqlldrdemo/oracle control=pload02.ctl DIRECT=TRUE PARALLEL=TRUE &
sqlldr sqlldrdemo/oracle control=pload03.ctl DIRECT=TRUE PARALLEL=TRUE &
sqlldr sqlldrdemo/oracle control=pload04.ctl DIRECT=TRUE PARALLEL=TRUE &

In this example, four processes execute the data load in parallel. The degree of parallelism...

Previous Section
End of Section 10
Next Section