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

  • 4h 47m
  • Hector R. Madrid
  • Packt Publishing
  • 2009

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.

You don't have to reinvent the wheel, just learn how to properly use the Oracle Utilities to achieve your goals. This is what this book is about; it covers topics oriented towards data management, session management, batch processing, massive deployment, troubleshooting, and how to make the most out of the frequently used DBA tools to improve your daily work.

Data management is one of the most frequently required tasks; doing a backup is a must-do task for any company. Data management includes several tasks such as data transfers, data uploading and downloading, reorganizing data, and data cloning, among many others. If people learn to use a tool and things appear to go well, few will question if their approach is optimal. Often it is only when maintenance windows start shrinking, due to the amount of data and business availability, that problems with any particular approach get identified. If people get used to the old export/import utilities to perform data management and if it works, they probably will consider the problem solved and will continue to use an obsolete tool. This book explores further possibilities and new tools. It makes the user question if his/her current environment is optimized and teaches how to adopt more optimized data management techniques focusing to the tools and the requirements most frequently seen in modern production environments.

About the Author

Hector R. Madrid is a highly respected Oracle professional with 20 years of experience as a full time DBA. He has been working with Oracle databases from version 5.0 up to the latest 11g release. He was the first Oracle Certified Master in Latin America and he holds the Oracle Certified Professional certificate for all Oracle versions starting with 7.3 up to 11g.

He obtained a bachelor's degree in Electronic Engineering from the Metropolitan Autonomous University in 1992, with a major in Digital Systems and Computers. He obtained a Master's degree in Computer Science from the same University. He has collaborated with Oracle Corp. as an instructor teaching the database track since 1996.

Hector works as a database consultant for several major firms, dealing with a wide range of DBA requirements, ranging from daily DBA tasks to defining and maintaining mission critical and high availability systems.

He has presented different technical papers at several Oracle conferences. He is the author of the Blog ‘Oracle by Madrid’ a Blog specializing in Oracle database topics.

In this Book

  • Data Pump
  • SQL*Loader
  • External Tables
  • Recovery Manager Advanced Techniques
  • Recovery Manager Restore and Recovery Techniques
  • Session Management
  • Oracle Scheduler
  • Oracle Wallet Manager
  • Security Management
  • Database Configuration Assistant
  • Oracle Universal Installer
  • Enterprise Manager Configuration Assistant
  • OPatch