作者：Hector R. Madrid
出版日期：June 26, 2009
出版社：其它
页数：432
ISBN：ISBN-10: 1847196284 ISBN-13: 978-1847196286
文件格式：PDF


Product Description
Master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database tasksOptimize time-consuming tasks efficiently using the Oracle database utilitiesPerform data loads on the fly and replace the functionality of the old export and import utilities using Data Pump or SQL*LoaderBoost database defenses with Oracle Wallet Manager and SecurityA handbook with lots of practical content with real-life scenariosIn Detail Does your database look complicated? Areyou finding it difficult to interact with it? Database interaction is apart of the daily routine for all database professionals. Using OracleUtilities the user can benefit from improved maintenance windows,optimized backups, faster data transfers, and more reliable securityand in general can do more with the same time and resources.
You don’t have to reinvent the wheel, just learn how to properly usethe Oracle Utilities to achieve your goals. This is what this book isabout; it covers topics oriented towards data management, sessionmanagement, batch processing, massive deployment, troubleshooting, andhow to make the most out of the frequently used DBA tools to improveyour daily work.
Data management is one of the most frequently required tasks; doinga backup is a must-do task for any company. Data management includesseveral tasks such as data transfers, data uploading and downloading,reorganizing data, and data cloning, among many others. If people learnto use a tool and things appear to go well, few will question if theirapproach is optimal. Often it is only when maintenance windows startshrinking, due to the amount of data and business availability, thatproblems with any particular approach get identified. If people getused to the old export/import utilities to perform data management andif it works, they probably will consider the problem solved and willcontinue to use an obsolete tool. This book explores furtherpossibilities and new tools. It makes the user question if his/hercurrent environment is optimized and teaches how to adopt moreoptimized data management techniques focusing to the tools and therequirements 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 databasesOptimize your maintenance windows related to data management taskssuch as importing data from one database to another using Data Pump andSQL*LoaderPerform more than just the ETL processes by taking advantage of the external tables featureUse Oracle Scheduler to specify maintenance windows, assignpriorities, configure job classes and many more features, and takedecisions based on the task outcomeGet acquainted with all the possibilities the Oracle UniversalInstaller tool offers to make the installation task more efficientExecute effective database creations: not just default creations, but comprehensive database creationsConfigure and manage an ASM environment using DBCAImprove performance and reduce the impact of recovery manager database backups in production environmentsIncrease the security in an Oracle environment, protect the backups, and manage certificates using Oracle Wallet ManagerPerform installations in batch environments and manage yoursoftware updates related to Critical Patch Updates (CPU) or individualpatches using OPatchApproach
This book is written using a practical approach that guides youthrough different practical scenarios. It provides a brief introductionto 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 tooland can immediately progress towards the advanced tips.
Using this practical approach you don’t have to spend valuable timetrying to decipher arid reference manuals; you can easily set up thepractical scenarios, and try to follow up the presentations. The imagesused in the book come from real scenarios, and the output is alwaysexplained so you can easily interpret what is being displayed on thescreen after issuing the commands.
Who this book is written for?
This book is aimed at all Oracle professionals who interact with thedatabase through the data and database utilities and are willing tooptimize their interaction with it.
Entry-level users will get acquainted with the best practices to gettheir job done in a timely and efficient manner. Advanced users willfind useful tips and How-Tos that will help them focus on getting themost 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. Hecollaborates with Oracle University as a certified instructor for theDBA and Java curriculum tracks. He is a highly respected Oracleprofessional with 20 years of experience as a full time DBA. He workswith a wide range of DBA requirements from the daily DBA routine dutiesto tasks related to mission-critical and high availability systems. Hewas the first Oracle Certified Master in Latin America and he holds thecertificate for all Oracle Version starting with 7.0 and up to 11g.
He obtained a Masters Degree in Computer Sciences from theMetropolitan Autonomous University (UAM) and he has presented differenttechnical papers at several Oracle conferences.