Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Oracle 10g/11g Data and Database Management Utilities

Buy

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.
 

What you will learn from this book?

  • 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

Approach

This book is written using a practical approach that guides you through different practical scenarios. It provides a brief introduction to the topics; this way you can quickly get to know the main features, start being productive with the tool, and grow with it at a fast pace. You won't have to spend too much time getting to the basics of the tool and can immediately progress towards the advanced tips.

Using this practical approach you don't have to spend valuable time trying to decipher arid reference manuals; you can easily set up the practical scenarios, and try to follow up the presentations. The images used in the book come from real scenarios, and the output is always explained so you can easily interpret what is being displayed on the screen after issuing the commands.

Who this book is written 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.

About the Author

Hector R. Madrid

Hector Madrid is currently working as a freelance consultant. He collaborates with Oracle University as a certified instructor for the DBA and Java curriculum tracks. He is a highly respected Oracle professional with 20 years of experience as a full time DBA. He works with a wide range of DBA requirements from the daily DBA routine duties to tasks related to mission-critical and high availability systems. He was the first Oracle Certified Master in Latin America and he holds the certificate for all Oracle Version starting with 7.0 and up to 11g.

He obtained a Masters Degree in Computer Sciences from the Metropolitan Autonomous University (UAM) and he has presented different technical papers at several Oracle conferences.

(HTML tags aren't allowed.)

Endoscopic Skull Base Surgery: A Comprehensive Guide with Illustrative Cases
Endoscopic Skull Base Surgery: A Comprehensive Guide with Illustrative Cases

To date, more than three thousand brain and skull base tumors, along with various vascular problems, have been treated by using advanced, fully endoscopic, minimally invasive surgical techniques. In this book, Dr. Hrayr K. Shahinian, director of the Skull Base Institute, compiles these techniques. The book is highly specific and amply...

Distributed Operating Systems
Distributed Operating Systems

As distributed computer systems become more pervasive, there is a need for a book that explains how their operating systems are designed and implemented. This book, which is a revised and expanded Part II of the best selling MODERN OPERATING SYSTEMS, fulfills that need. KEY TOPICS: It covers the material from the original...

Frontiers of Statistical Decision Making and Bayesian Analysis: In Honor of James O. Berger
Frontiers of Statistical Decision Making and Bayesian Analysis: In Honor of James O. Berger

Research in Bayesian analysis and statistical decision theory is rapidly expanding and diversifying, making it increasingly more difficult for any single researcher to stay up to date on all current research frontiers. This book provides a review of current research challenges and opportunities. While the book can not exhaustively cover all...


PC Magazine - 21 August 2007
PC Magazine - 21 August 2007
First Looks
GoToMeeting v3.0
GuardedID 1.02
Howard Verity TW3
Kodak EasyShare 5300 All-In-One printer
Logitech X-240
MSI Q677 Crystal Edition
Nokia E61i
Oki Printing Solutions C6000n
Panasonic Lumix DMC-FZ8
RealPlayer 11 (beta)
Sennheiser PXC 450 NoiseGard
Sony VAIO VGN-SZ370P
Adobe
...
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Second Edition
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Second Edition

No previous background in database design is necessary to read this book. The reason you have this book in your hands is to learn how to design a database properly. If you're just getting into database management and you're thinking about developing your own databases, this book will be very valuable to you. It's better that...

Creatine and Creatine Phosphate: Scientific and Clinical Perspectives
Creatine and Creatine Phosphate: Scientific and Clinical Perspectives

Creatine and creatine phosphate (CP, also called phosphocreatine, PCr) are

important metabolites in high-energy phosphorus metabolism. They rank with dietary carbohydrates fats, proteins and other compounds as central components of the metabolic system involved in the provision of energy for work and exercise performance.
...
©2020 LearnIT (support@pdfchm.net) - Privacy Policy