Oracle 10g/11g Data and Database Management Utilities

Master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database tasks

Key Features

• Optimize time-consuming tasks efficiently using the Oracle database utilities
• Perform data loads on the fly and replace the functionality of the old export and import utilities using Data Pump or SQL*Loader
• Boost database defenses with Oracle Wallet Manager and Security
• A handbook with lots of practical content with real-life scenarios

Book Description

What you will learn

• Improve performance and manageability using the advanced features of direct export/import utilities among different databases
• Optimize your maintenance windows related to data management tasks such as importing data from one database to another using Data Pump and SQL*Loader
• Perform more than just the ETL processes by taking advantage of the external tables feature
• Use Oracle Scheduler to specify maintenance windows, assign priorities, configure job classes and many more features, and take decisions based on the task outcome
• Get acquainted with all the possibilities the Oracle Universal Installer tool offers to make the installation task more efficient
• Execute effective database creations: not just default creations, but comprehensive database creations
• Configure and manage an ASM environment using DBCA
• Improve performance and reduce the impact of recovery manager database backups in production environments
• Increase the security in an Oracle environment, protect the backups, and manage certificates using Oracle Wallet Manager
• Perform installations in batch environments and manage your software updates related to Critical Patch Updates (CPU) or individual patches using OPatch

Who this book is for

This book is aimed at all Oracle professionals who interact with the database through the data and database utilities and are willing to optimize their interaction with it.
Entry-level users will get acquainted with the best practices to get their job done in a timely and efficient manner. Advanced users will find useful tips and How-Tos that will help them focus on getting the most out of the database utilities and fine-tune batch processing.