On-Demand Database Management – Database Trends and Applications

Today more than ever, companies are facing recruitment and skills challenges. DBAs and managers are under pressure to deliver high-performing, responsive systems that can grow with the business. The role of the DBA remains unchanged, but technology continues to advance. Databases can be on-premises, in the cloud, or a hybrid combination. Databases can be purpose-built, multi-tenant, converged, or stand-alone, and legacy and cloud-native applications use and store data in databases. Often, databases are not properly managed and present risks in terms of availability, security or compliance.

During Quest’s Database and Technology Week, Steven Lemme, Senior Principal Product Manager, and Sriram Vrinda, Product Manager at Oracle, gave a presentation on how to meet these challenges with on-demand database management.

In today’s world, they explained, most businesses have mixed IT and most businesses that adopt public cloud services use multiple vendors. Some of the challenges of managing multi-cloud databases include increasingly large, complex, and microservices-based applications. Additionally, more applications mean more scripts, tool installations, configurations, and screens to view all databases, as well as greater time requirements to identify, isolate, and diagnose database issues, while new DevOps practices add requirements for more observability and manageability. telemetry.

DBAs face the dilemma of current scripts/tools not working for:

  • More than a few databases
  • Supported Oracle Database Versions
  • Multi-tenant, stand-alone, and Exadata Oracle capabilities
  • Databases in cloud, hybrid or multicloud environments
  • Agility needs of DevOps/development teams

Some of the benefits of using this service include the ability to get information about your databases within minutes of signing up; have the latest Oracle database support; the ability to replace siled third-party tools, salvage hardware and resources, and save money; the availability of in-depth diagnostics and detailed SQL metrics; and the fact that having a common source of information allows for faster troubleshooting.

OCI Database Management Service

The OCI Database Management Service is Oracle Cloud’s native on-demand managed cloud service. With this service, users can subscribe and start using it in minutes, with no on-premises installation, repository, integration, or scripting required; Obtain application diagnostic capabilities for the data layer, so they can troubleshoot issues faster; automate on-premises and cloud database management tasks to reduce risk and get more work done; and have modern Oracle database administration supporting the latest database releases and features. Additionally, the service allows users to view a database in one place (on-premises, hybrid, or multi-cloud) with complete insight into infrastructure availability, performance, and operations; Obtain information about issues, availability, and key statistics for troubleshooting and diagnostics; and perform operations on a database or set of databases.

The OCI Database Management Service complements Oracle Enterprise Manager. This on-demand managed cloud service is for those who have not deployed Enterprise Manager or want a replacement for Enterprise Manager Express. Users such as developers do not need and would not use all the functionality offered by Enterprise Manager. Yet, 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 gaps left by third-party tools that do not support the latest versions of Oracle Database and multi-tenant features, or that pose a security risk.

Top Use Cases of OCI Database Management Service

Some of the primary use cases for the OCI database management service include achieving a single management view for Oracle databases on-premises and in the cloud, obtaining performance diagnostics and reporting capabilities. real-time administration, leveraging existing on-premises skills, and cloud database management with a unified, integrated solution.

With this service, you can manage Oracle Database from virtually anywhere. There is a console for monitoring and management. It’s also simple to adopt and use, and it provides fleet-wide administration for greater operational efficiency. It offers unified database diagnostics and tuning for database lifecycle management and fast problem troubleshooting, optimizes SQL with real-time SQL monitoring, and optimizes database performance.

To learn more about on-demand database management, see the Database & Technology Week presentation at https://questoraclecommunity.org/learn/recordings-presentations/on-demand-database-management.

Maria H. Underwood