Pro Oracle Database 23ai Administration

Manage and Safeguard Your Organization’s Data

Michelle Malcher, Darl Kuhn (Autoren)

Buch | Softcover

550 Seiten

2024 | Fifth Edition
Apress (Verlag)
979-8-8688-1037-4 (ISBN)

Titel nicht im Sortiment

Artikel merken

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 tuned and performing, and includes new, important innovations with AI Vector Search, JSON Duality Views, and Select AI. Since Oracle Database 23ai offers a choice of platforms with on-premises and cloud, 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 are often 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 Will Learn

Configure and manage Oracle 23ai databases both on-premises and in the cloud
Meet your DBA responsibilities in the Oracle Cloud and with Database Cloud Services
Leverage converged database capabilities to manage different workloads, structured and unstructured data
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 23ai 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 be current with the new features in Oracle Database 23ai. 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 lake house and data mesh environments.

Michelle Malcher is a senior manager for database product management at Oracle. 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 areas such as architecture and risk assessment, purchasing and installation, and ongoing systems oversight. She was a founding board member for FUEL, the Palo Alto Networks User community, as well as a past president and long time volunteer 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 an Oracle DBA consultant at RMCI. He handles all facets of database administration from design and development to production support. He also teaches advanced database courses at University of Denver. He does volunteer DBA work for the Rocky Mountain Oracle User 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.

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.

Erscheint lt. Verlag	17.2.2025
Zusatzinfo	Approx. 550 p.
Verlagsort	Berlin
Sprache	englisch
Maße	178 x 254 mm
Themenwelt	Mathematik / Informatik ► Informatik ► Datenbanken
Themenwelt	Informatik ► Netzwerke ► Sicherheit / Firewall
Schlagworte	AI Vector Search • Automated Storage Management (ASM) • Autonomous Database • Backup • Container databases (CDB) • Containerization • Data Management • Data Pump • Dsc • External Tables • JSON • Metadata driven automation • Oracle Cloud • Oracle Database In-Memory • Oracle Public Cloud • Oracle Schedule • Pluggable databases (PDB) • Recovery • Recovery Manager (RMAN) • SQL Server
ISBN-13	979-8-8688-1037-4 / 9798868810374
Zustand	Neuware