
eBook - ePub
Pro Oracle Database 23c Administration
Manage and Safeguard Your Organization’s Data
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Pro Oracle Database 23c Administration
Manage and Safeguard Your Organization’s Data
About this book
Master Oracle Database administration in both on-premises and cloud environments. This new edition covers the tasks you'll need to perform to keep your databases stable, tuned, and running. The book also includes administrative tasks specific to cloud environments, including the Oracle Autonomous Database running in the Oracle Cloud Infrastructure. New in this edition is help for DBAs who are becoming involved in data management, and a look at the idea of a converged database and what that means in handling various data types and workloads. The book covers some of the machine learning features now in Oracle and shows how the same SQL that you know for database administration also helps you with data management tasks. The information in this book helps you to apply the right solution at the right time, mitigating risk and making robust choices that protect your data and avoid midnight phone calls.
Data management is increasingly a DBA function, and DBAs areoften called upon for help in getting data loaded into analytics environments such as a data lakehouse or a data mesh. This book addresses this fast-growing new role for database administrators and helps you build on your existing knowledge to make the transition into a new skill set that is in high demand. You'll learn how to look at data optimization from the standpoint of data analysis and machine learning so that you can be seen as a key player in preparing your organization's data for those type of activities. You'll know how to pull back information from a combination of relational tables and JSON structures. You'll become familiar with the tools that Oracle Database provides to make analytics easier and more straightforward. And you'll learn simpler ways to manage time-based tables that eliminate the need for painfully creating triggers to track the history of row changes over time.
This book builds your skills as an Oracle Database administrator with the aim of helping you to be seen as a key player in data management as your organization pivots toward cloud computing and a greater use of machine learning and analytics technologies.
What You'll Learn
- Configure and manage Oracle 23c databases both on-premises and in the cloud
- Meet your DBA responsibilities in the Oracle Cloud and with Database Cloud Services
- Perform administrative tasks for Autonomous Database dedicated environments
- Perform DBA tasks and effectively use data management tools
- Migrate from on-premises to the Oracle Cloud Infrastructure
- Troubleshoot issues with Oracle 23c databases and quickly solve performance problems
- Architect cloud, on-premises, hybrid, and multi-cloud database environments
Who This Book Is For
Oracle database administrators (DBAs) who want to becurrent with the new features in Oracle Database 23c. For any DBA who is tasked with managing Oracle databases in cloud, hybrid cloud, and multi-cloud configurations. Also helpful for data architects who are designing analytic solutions in data lakehouse and data mesh environments.
Frequently asked questions
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Pro Oracle Database 23c Administration by Michelle Malcher,Darl Kuhn in PDF and/or ePUB format, as well as other popular books in Computer Science & Databases. We have over one million books available in our catalogue for you to explore.
Information
Table of contents
- Cover
- Front Matter
- 1. Installing the Oracle Binaries
- 2. Creating a Database
- 3. Configuring an Efficient Environment
- 4. Tablespaces and Data Files
- 5. Managing Control Files, Online Redo Logs, and Archivelogs
- 6. Users and Basic Security
- 7. Tables and Constraints
- 8. Indexes
- 9. Views, Duality Views, and Materialized Views
- 10. Data Dictionary Fundamentals
- 11. Large Objects
- 12. Containers and Pluggables
- 13. RMAN Backups and Reporting
- 14. RMAN Restore and Recovery
- 15. External Tables
- 16. Automation and Troubleshooting
- 17. Migration to Multitenant and Fleet Management
- 18. Data Management
- Back Matter