Oracle 23ai Changes Everything

Transcript

1. Oracle 23ai Changes Everything Why Cloud-Native is a Revolution for the Oracle Database Sean Scott Managing Principal Consultant — Viscosity North America Oracle ACE Director
2. Database Reliability Engineering MAA ⁘ RAC ⁘ RMAN Data Guard ⁘ Sharding ⁘ Partitioning Information Lifecycle Management Exadata & Engineered Systems Database Modernization Upgrades ⁘ Patching ⁘ Migrations Cloud ⁘ Hybrid Automation DevOps ⁘ IaC ⁘ Containers ⁘ Terraform Vagrant ⁘ Ansible Observability AHF ⁘ TFA ⁘ CHA ⁘ CHM
3. www.viscosityna.com @ViscosityNA Oracle on Docker Running Oracle Databases in Linux Containers Free sample chapter: https://oraclesean.com
4. Tech Superstars Unite Get worldwide recognition as an Oracle ACE Oracle.com profile page Exclusive content Your own Oracle cloud account Swag, certification exam credit & event passes Networking events Travel support Learn more at: ace.oracle.com @oracleace Linkedin.com/groups/72183 @oracleace.bsky.social
10. www.viscosityna.com @ViscosityNA What version introduced: Flashback Database
11. www.viscosityna.com @ViscosityNA What version introduced: Oracle 10g - 2003 Flashback Database
12. www.viscosityna.com @ViscosityNA What version introduced: Optimizer Dynamic Sampling
13. www.viscosityna.com @ViscosityNA What version introduced: Oracle 11gR2 - 2009 Optimizer Dynamic Sampling
14. www.viscosityna.com @ViscosityNA What version introduced: Locally Managed Tablespaces
15. www.viscosityna.com @ViscosityNA What version introduced: Oracle 8i - 1998 Locally Managed Tablespaces
16. www.viscosityna.com @ViscosityNA What version introduced: Automatic Segment Space Management
17. www.viscosityna.com @ViscosityNA What version introduced: Oracle 9iR2 - 2002 Automatic Segment Space Management
18. www.viscosityna.com @ViscosityNA What version introduced: Automatic Undo Management
19. www.viscosityna.com @ViscosityNA What version introduced: Oracle 9i - 2001 Automatic Undo Management
20. www.viscosityna.com @ViscosityNA What version introduced: Locally Managed Tablespaces
21. www.viscosityna.com @ViscosityNA What version introduced: Oracle 8i - 1998 Locally Managed Tablespaces
22. www.viscosityna.com @ViscosityNA What version introduced: Automatic Statistics Collection
23. www.viscosityna.com @ViscosityNA What version introduced: Oracle 10g - 2003 Automatic Statistics Collection
24. www.viscosityna.com @ViscosityNA What version introduced: Automatic Database Diagnostic Monitor
25. www.viscosityna.com @ViscosityNA What version introduced: Oracle 10g - 2003 Automatic Database Diagnostic Monitor
26. www.viscosityna.com @ViscosityNA What version introduced: Dynamic Memory Resizing
27. www.viscosityna.com @ViscosityNA What version introduced: Oracle 9i - 2001 Dynamic Memory Resizing
28. www.viscosityna.com @ViscosityNA What version introduced: Automatic Shared Memory Management
29. www.viscosityna.com @ViscosityNA What version introduced: Oracle 10g - 2003 Automatic Shared Memory Management
30. www.viscosityna.com @ViscosityNA What version introduced: SQL Plan Directives
31. www.viscosityna.com @ViscosityNA What version introduced: Oracle 12c - 2013 SQL Plan Directives
32. www.viscosityna.com @ViscosityNA What version introduced: SQL Tuning Advisor
33. www.viscosityna.com @ViscosityNA What version introduced: Oracle 10gR2 - 2005 SQL Tuning Advisor
34. www.viscosityna.com @ViscosityNA What version introduced: Adaptive SQL Plan Management
35. www.viscosityna.com @ViscosityNA What version introduced: Oracle 12c - 2013 Adaptive SQL Plan Management
36. www.viscosityna.com @ViscosityNA What version introduced: Edition Based Redefinition
37. www.viscosityna.com @ViscosityNA What version introduced: Oracle 11gR2 - 2009 Edition Based Redefinition
38. www.viscosityna.com @ViscosityNA I was promised flying cars
39. www.viscosityna.com @ViscosityNA We still install, manage, monitor, and secure databases like it's 2005. We still interact with the host OS, storage, and network like it's 2005.
40. Oracle 23ai Changes Everything Why Cloud-Native is a Revolution for the Oracle Database Sean Scott Managing Principal Consultant — Viscosity North America Oracle ACE Director
41. www.viscosityna.com @ViscosityNA The reason nothing's changed? The OS hasn't changed.
45. www.viscosityna.com @ViscosityNA What is Cloud Native?
51. www.viscosityna.com @ViscosityNA Cloud native changes the operating system.
52. www.viscosityna.com @ViscosityNA The database's relationships with host resources, storage, and networks change.
53. www.viscosityna.com @ViscosityNA Techniques for installing, managing, monitoring, tuning, and securing databases change.
54. www.viscosityna.com @ViscosityNA Cloud native democratizes data and databases.
55. www.viscosityna.com @ViscosityNA Cloud Native Support for Oracle Databases • Container images: Self-contained, portable, versioned software "packages." Image builds are automated "Infrastructure as Code" that are easily consumed and deployed across an enterprise. • Oracle on Kubernetes: Kubernetes provides elasticity and orchestration for provisioning, managing, and scaling database platforms. • Oracle Kubernetes Operator: API with resource definitions and controllers for automating the full database lifecycle.
56. www.viscosityna.com @ViscosityNA Oracle Databases in Containers • Speed: Rapidly provision and deploy databases for development and testing, using identical, pre-built images. • Reduce costs: Containerized databases require fewer resources than their VM equivalents. Increase density or use smaller shapes. • Portable: Run images anywhere: On-prem, cloud, laptop. • Scaleable: Add/remove containers according to demand. • Reliable: Consistent, verifiable images produce identical results. • Secure: Codified installation, and minimal, visible filesystems improves vulnerability scanning and detection.
57. www.viscosityna.com @ViscosityNA Oracle Databases in Containers • Simple: Running a containerized database does not require specialized database administration knowledge. • Agile: "Plug-in" versioned and/or thinly provisioned datasets with simple OS commands—no Data Pump import or RMAN recovery required. • Test: Easily and quickly deploy orchestrated systems—RAC, Data Guard, GoldenGate, Sharding—to test, develop and perfect business continuity procedures. • Train: Explore new features and practice HA/DR activities on laptop/ desktop systems.
58. www.viscosityna.com @ViscosityNA Oracle Databases on Kubernetes • Infrastructure Automation: Use container images to automate deployments and integrations. • Monitoring: Monitor services, maintain availability and performance, and elastically scale/descale databases to accommodate workloads.
59. www.viscosityna.com @ViscosityNA Oracle Database Kubernetes Operator • Automate Database Management: Reduce complexity and effort associated with deploying and managing Oracle databases, and eliminate human dependencies for common database operations. • Kubernetes API: Native Kubernetes integration for database lifecycle management—stop, start, monitor, patch, upgrade, backup, and restore databases, whether on-prem or in any cloud.
60. www.viscosityna.com @ViscosityNA "If cloud native was good for databases, everyone would be doing it."
61. https://www.infoq.com/news/2014/06/everything-google-containers/
64. www.viscosityna.com @ViscosityNA Enterprises adopting Cloud Native throughout the organization—including databases—will realize increasing competitive advantage over rivals anchored to legacy database deployments.
66. Questions? Contact Me! sean.scott@viscosityna.com https://linktr.ee/oraclesean www.viscosityna.com