Front Matter – Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization’s Data

Michelle Malcher and Darl Kuhn
Pro Oracle Database 18c AdministrationManage and Safeguard Your Organization’s Data3rd ed.
Michelle Malcher
Huntley, IL, USA
Darl Kuhn
Morrison, CO, USA
ISBN 978-1-4842-4423-4e-ISBN 978-1-4842-4424-1
© Michelle Malcher and Darl Kuhn 2019
This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed.
Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark. The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights.
While the advice and information in this book are believed to be true and accurate at the date of publication, neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors or omissions that may be made. The publisher makes no warranty, express or implied, with respect to the material contained herein.
Distributed to the book trade worldwide by Springer Science+Business Media New York, 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail, or visit Apress Media, LLC is a California LLC and the sole member (owner) is Springer Science + Business Media Finance Inc (SSBM Finance Inc). SSBM Finance Inc is a Delaware corporation.

Dedicated to my daughters.

They believe in me just like I believe in them.


Cloud, automation, artificial intelligence, and machine learning are all keywords for the direction of technology. The interesting thing about these areas is that data is still plays a very important role. Obviously, it is something good for the database administrator or the guardian of the data.

With these new environments and Oracle’s Autonomous Database in the cloud, the question is being asked if DBAs are needed. Self-driving, tuning, and provisioning of databases are the future of the environment. However, there are definitely different tasks that the DBAs are going to be performing along with being the people to go to for migrations to the cloud and automating processes.

So, why write a book about Oracle 18c database administration? This is an easy question to answer. Even though the tasks are changing, understanding the database is critical. Even with processes being automated, there are issues that might need troubleshooting and automations put into place. Applications need database objects designed, created and maintained, and tuned for performance. Is the job now just troubleshooting issues and automating the rest? No, there are design and strategy for data, application, and security. But this book is not just about the transitioning role of the DBA, but to provide administration skills that are still relevant in the database environment. It is also important to know that the internal understanding of the database helps with all of these areas including previous versions.

Data are being integrated, migrated, and maintained in several databases. The structures of these environments are what is needed and what it takes to create consistent, reliable, and always-accessible data. Administration is needed for these systems and support applications with database design and development.

This book provides details about the tasks that are needed to create Oracle 18c databases and provide administration for the environments because it is more than just building a database but managing it with the data and active applications. It provides an inside look of the Oracle database, hardware, storage, and servers that are required to run Oracle. Some of the tasks that are presented are now and should be done through automated processes but stated in ways to being able to work through issues and troubleshoot any problems.

There was careful consideration for including chapters and sections in this book to make sure it was providing the right topics to understand the database along with previous versions, support the design and performance tuning of database objects, and give DBAs the tools they need to be successful.

Backups and recovery are discussed heavily because scenarios of recovery are difficult to automate. There are consistent themes throughout the book to look to create repeatable tasks for automation, securing the environments, and utilizing the new features and tools that come with the new releases of the database. DBAs play an important role in creating backup and security strategies as there are several discussions that support this.

Many of these topics are the same if the database is on-premise or in the cloud. Understanding the difference and how the DBAs can support the migrations to the cloud are included in the notes and sections of the chapters. Databases in the cloud serve many purposes in the enterprise, and DBAs are the perfect resource to assist in migrations and make sure the data are secure and integrated from the cloud environment.

There are many examples, tips, and notes to provide any DBA with Oracle database the tools they need to design, implement, and administer Oracle 18c database environments.


Every time I sit down to write or prepare a presentation, I spend a few minutes reflecting on how I got to this place in my career. There are many people that I am thankful for: to have their influence, guidance, and encouragement in my life. A few of these people I might have told I was done writing books, four books ago. I enjoy seeing their smiles and getting teased when they hear that another one is done.

The friendships that I have made in the database community have encouraged me to learn more and share. I appreciate each of these fun database people who are passionate about what they do and enjoy bringing along others by teaching, mentoring, and supporting others. What an opportunity to be in this career and working with others passionate about databases and being the best guardians of the data! Thank you!

Table of Contents

Summary 555
Summary 646
Summary 772
Summary 834
Index 963

About the Authors and About the Technical Reviewer

About the Authors

Michelle Malcher

is a security architect for databases at Extreme-Scale Solutions. Her deep technical expertise from database to security, as well as her senior-level contributions as a speaker, author, Oracle ACE director, and customer advisory board participant have aided many corporations in the areas of architecture and risk assessment, purchasing and installation, and ongoing systems oversight. She is on the board of directors for FUEL, the Palo Alto Networks User community, as well as volunteering for the Independent Oracle User Group (IOUG). She has built out teams for database security and data services and enjoys sharing knowledge about data intelligence and providing secure and standardized database environments.

Darl Kuhn

is a senior database administrator working for Oracle. He handles all facets of database administration from design and development to production support. He also teaches advanced database courses at Regis University in Colorado. Darl does volunteer DBA work for the Rocky Mountain Oracle Users Group. He has a graduate degree from Colorado State University and lives near Spanish Peaks, Colorado, with his wife, Heidi; and daughters, Brandi and Lisa.


About the Technical Reviewer

Arup Nanda

has been working in database management for 25 years and counting. With 6 books, more than 700 published articles and 500 presentations in 22 countries, he is very well known in the database area in general and Oracle technologies in particular. Today he is the Chief Data Officer of in New York area. He blogs at arup.​blogspot.​com .