Vai al contenuto principale della pagina

Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / / Hector R. Madrid



(Visualizza in formato marc)    (Visualizza in BIBFRAME)

Autore: Madrid Hector R Visualizza persona
Titolo: Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / / Hector R. Madrid Visualizza cluster
Pubblicazione: Birmingham, U.K., : Packt Publishing Ltd., 2009
Edizione: 1st ed.
Descrizione fisica: 1 online resource (432 p.)
Disciplina: 005.75/85
Soggetto topico: Database management
Relational databases
Note generali: Includes index.
Nota di contenuto: Cover; Table of Contents; Preface; Chapter 1: Data Pump; Data Pump features; Data Pump architecture; Setting up the practical scenarios; Data Pump export; Data Pump export modes; A simple Data Pump export session; Data Pump export filtering operations; Use of parameter file; Retrieve original data; Data Pump export space estimation; Dump file multiplexing; Transporting data among different versions; Data Pump export interactive mode; Data Pump restart capability; Getting information about the export job; Data Pump import; Remap function; Data Pump import network mode
Improving performance with Data PumpWorking with the Data Pump API; Data Pump 11g new features; Compression; Encrypted dump file sets; Enhancements for Data Pump External Tables; Single partition transportable for Oracle Data Pump; Overwrite dump files; XML Datatypes; Summary; Chapter 2: SQL*Loader; SQL*Loader basics; Preparing the demo environment; Our first simple load; The SQL*Loader log file; Fixed record size format load; Variable record size format load; Stream record format load; Specifying a particular character set; Load on the fly; Direct path versus Conventional path load
Direct path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; Chapter 3: External Tables; The External Table basics; Let's setup the environment; A basic External Table; Creating External Table metadata, the easy way; Unloading data to External Tables; Inter-version compatibility; Data transformation with External Tables; Extending the alert.log analysis with External Tables; Reading the listener.log from the database; Mapping XML files as External Tables
Dynamically changing the external referenceOracle 11g External Table enhancements; Summary; Chapter 4: Recovery Manager Advanced Techniques; Recovery Manager basics; Getting started with a Recovery Manager session; Format masks used by recovery manager; What happens in a user-managed online backup?; Myths related to the online backup method; Configuring a multiplexed backup; Configuring the RMAN recovery catalog; A simple backup session; Backup compression; Fast backup compression; Improving data set compression with the ZLIB algorithm (11g only)
Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery; Backup duration and throttling; Database cloning; Database cloning procedure; Database cloning on the fly (11g only); Inter-platform database migration; Migrate to and from an ASM environment; General backup advices; Summary; Chapter 5: Recovery Manager Restore and Recovery Techniques; Oracle database recovery; Instance failure; Media failure; Complete recovery; Incomplete recovery; Loss of data files; Queries used to diagnose data files; Loss of a non-critical datafile
Loss of a temporary datafile
Sommario/riassunto: Master 12 must-use Oracle Database Utilities with this book and eBook
Titolo autorizzato: Oracle 10g  Visualizza cluster
ISBN: 1-282-17234-4
1-84719-629-2
9786612172342
Formato: Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione: Inglese
Record Nr.: 9910818343603321
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui