Oracle 10g/11g Data and Database Management Utilities
| By: | Hector R. Madrid |
| Publisher: | Packt Publishing |
| Print ISBN: | 9781847196286 |
| eText ISBN: | 9781847196293 |
| Edition: | 1 |
| Copyright: | 2009 |
| Format: | Reflowable |
Lifetime - $39.59
eBook Features
Instant Access
Purchase and read your book immediately
Read Offline
Access your eTextbook anytime and anywhere
Study Tools
Built-in study tools like highlights and more
Read Aloud
Listen and follow along as Bookshelf reads to you
Details
Table of Contents
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
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.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