Now more than ever, companies face recruitment and skills challenges. Database administrators and managers are under pressure to deliver high-performance, responsive systems that can scale businesses. The role of the DBA remains unchanged, but the technology continues to advance. Databases can be on-premises, in the cloud, or a combination. Databases can be purpose-built, multi-tenant, converged, or independent, and both legacy and cloud-native applications use and store data in databases. Oftentimes, databases are not managed properly and are at risk when it comes to business availability, security or compliance.
During Quest’s Database and Technology Week, Stephen Lemmy, Senior Principal Product Manager, and Sriram Vrinda, Product Manager at Oracle, gave a presentation on how to address these challenges with on-demand database management.
They explained that in today’s world, most companies have hybrid IT, and most enterprise users of public clouds use multiple providers. Some of the challenges of managing multicloud databases include the increasingly widespread, complex, and microservice-based applications. Additionally, more applications mean more scripts, tool installs, configurations, and screens to view all databases, as well as greater time requirements to identify, isolate, and diagnose database issues, while newer DevOps practices add requirements for more monitoring and management of telemetry.
Database administrators face the dilemma of existing scripts/tools not working for:
- More than a few databases
- Supported Oracle Database Versions
- Oracle Multitenant, Autonomous, and Exadata Capabilities
- Databases in cloud, hybrid or multicloud environments
- DevOps agility needs / development teams
Some of the advantages of using this service include the ability to obtain information about your databases within minutes of signing up; Get the latest Oracle Database support; The ability to replace orphaned third-party tools, recover hardware and resources, and save money; Availability of in-depth diagnostics and SQL measurement details; The fact that having a common source of information allows for faster troubleshooting.
OCI database management service
OCI Database Management Service is Oracle Cloud’s managed on-demand, cloud-native service. With this service, users can sign up and start using it within minutes, without the need for installation, repository, integration or on-site scripting; Get application diagnostics capabilities of the data layer, so they can solve problems faster; Automate database management tasks on-premises and in the cloud to reduce risk and get more work done; It has a modern Oracle Database management that supports the latest database versions and capabilities. Additionally, the service enables users to view a database in a single location (on-premises, hybrid or multi-cloud) with insight into availability, performance, and infrastructure operations; Gain insight into issues, availability, and basic stats for troubleshooting and diagnostics; and perform operations on a single database or a fleet thereof.
Complements the OCI Oracle Enterprise Manager Database Administration Service. This on-demand managed cloud service caters to those who have not deployed Enterprise Manager or wish to replace Enterprise Manager Express. Users like developers do not need, and will not use, all of the functionality offered by Enterprise Manager. However, DevOps teams are often called upon to perform database management tasks for Oracle databases. The OCI Database Management Service can be used to replace or fill in gaps left by third-party tools that do not support the latest versions of Oracle Database and multi-tenant capabilities, or that pose a security risk.
The main use cases of the OCI database management service
Some of the key use cases for OCI database management service include achieving a single management view of Oracle databases on-premises and in the cloud, gaining real-time performance diagnostics and management capabilities, leveraging existing on-premises skills, and managing databases in the cloud with a unified, end-to-end solution.
With this service, you can manage your Oracle Database practically from anywhere. There is one console for monitoring and management. It is also easy to use and use, and it provides fleet-wide management for greater operational efficiency. It provides unified database diagnostics and tuning for fast database lifecycle management and troubleshooting, improves SQL through real-time SQL monitoring, and improves database performance.
To learn more about on-demand database management, check out the Database and Technology Week presentation at https://questoraclecommunity.org/learn/recordings-presentations/ on-request-database-management.