{"id":954,"date":"2026-04-17T06:30:09","date_gmt":"2026-04-17T06:30:09","guid":{"rendered":"https:\/\/www.devopsschool.com\/tutorials\/oracle-cloud-database-management-tutorial-architecture-pricing-use-cases-and-hands-on-guide-for-observability-and-management\/"},"modified":"2026-04-17T06:30:09","modified_gmt":"2026-04-17T06:30:09","slug":"oracle-cloud-database-management-tutorial-architecture-pricing-use-cases-and-hands-on-guide-for-observability-and-management","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/tutorials\/oracle-cloud-database-management-tutorial-architecture-pricing-use-cases-and-hands-on-guide-for-observability-and-management\/","title":{"rendered":"Oracle Cloud Database Management Tutorial: Architecture, Pricing, Use Cases, and Hands-On Guide for Observability and Management"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Category<\/h2>\n\n\n\n<p>Observability and Management<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Introduction<\/h2>\n\n\n\n<p>Oracle Cloud <strong>Database Management<\/strong> is an <strong>Observability and Management<\/strong> service in <strong>Oracle Cloud<\/strong> (OCI) that helps you monitor, troubleshoot, and administer Oracle databases from a centralized, cloud-native console and API.<\/p>\n\n\n\n<p>In simple terms: Database Management gives you one place to see database health, performance, and SQL behavior\u2014so you can detect issues early, reduce downtime, and keep database fleets running smoothly.<\/p>\n\n\n\n<p>In technical terms: Database Management registers supported Oracle databases as <strong>managed databases<\/strong> and collects telemetry (metrics, performance signals, configuration details) either natively (for certain OCI database services) or via an agent\/connector pattern (for databases running on compute or outside OCI). It then exposes fleet views, performance tooling (for example, Performance Hub\/ASH-style analysis where applicable), alerts, and administration workflows, integrated with OCI IAM, compartments, Monitoring, Notifications, Logging, and Audit.<\/p>\n\n\n\n<p><strong>What problem it solves:<\/strong> database fleets are hard to operate at scale. Teams often split monitoring across scripts, host tools, and separate dashboards. Database Management standardizes \u201cday-2 operations\u201d (visibility, alerting, and diagnostics) while aligning with OCI governance (compartments, policies, tagging) and operational toolchains.<\/p>\n\n\n\n<blockquote>\n<p>Service status \/ naming: <strong>Database Management<\/strong> is the current service name in OCI under <strong>Observability and Management<\/strong>. If you encounter older references (for example, \u201cDB Management\u201d), treat them as informal shorthand\u2014verify current terminology in the official documentation.<\/p>\n<\/blockquote>\n\n\n\n<p>Official documentation entry point: https:\/\/docs.oracle.com\/en-us\/iaas\/database-management\/home.htm<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">2. What is Database Management?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Official purpose<\/h3>\n\n\n\n<p><strong>Database Management<\/strong> is an Oracle Cloud service for <strong>monitoring and managing Oracle Databases<\/strong> through a unified interface. It focuses on operational visibility (health, performance, SQL) and selected administrative actions, organized for fleets and integrated with OCI governance.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Core capabilities (high level)<\/h3>\n\n\n\n<p>Commonly used capabilities include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Fleet views<\/strong> to understand overall database estate health and status<\/li>\n<li><strong>Performance troubleshooting<\/strong> (where supported) using built-in performance pages\/tools<\/li>\n<li><strong>Database metrics and alerting<\/strong> integrated with OCI Monitoring\/Alarms\/Notifications<\/li>\n<li><strong>Configuration and inventory insights<\/strong> (database details, parameters\/configuration surfaces depending on target type)<\/li>\n<li><strong>Workflows for managed targets<\/strong> (actions depend on target type and permissions)<\/li>\n<\/ul>\n\n\n\n<p>Because Database Management supports different target types (OCI databases vs externally connected databases), some features vary by database deployment model and edition. Always verify feature availability for your specific database type in official docs.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Major components (conceptual)<\/h3>\n\n\n\n<p>Database Management typically involves:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Database Management service control plane<\/strong> (OCI)<\/li>\n<li><strong>Managed database<\/strong> resources (the representation of a database being monitored\/managed)<\/li>\n<li><strong>Connectivity mechanism<\/strong> (varies by target type):<\/li>\n<li>Native integration for some OCI database services<\/li>\n<li>Agent\/connector-based integration for databases on compute or outside OCI (verify exact target support matrix in docs)<\/li>\n<li><strong>IAM policies and compartments<\/strong> for access control and governance<\/li>\n<li><strong>OCI Monitoring \/ Alarms \/ Notifications<\/strong> for alerting and operational workflows<\/li>\n<li><strong>OCI Logging \/ Audit<\/strong> for operational and security visibility<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Service type<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Cloud-native managed service<\/strong> (control plane hosted by OCI)<\/li>\n<li>Integrates with databases running:<\/li>\n<li>In OCI database services<\/li>\n<li>Potentially on OCI Compute or external environments (depends on supported target types)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Scope: regional and compartment-based<\/h3>\n\n\n\n<p>Database Management is an OCI service that is <strong>region-scoped<\/strong> in practice:\n&#8211; You use it within an OCI <strong>region<\/strong>\n&#8211; Resources are organized in <strong>compartments<\/strong>\n&#8211; Cross-region visibility is not automatic\u2014if you operate multi-region, plan for per-region operations or an aggregation strategy (verify current cross-region capabilities in official docs)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Fit in the Oracle Cloud ecosystem<\/h3>\n\n\n\n<p>Database Management sits in <strong>Observability and Management<\/strong> and commonly works alongside:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Monitoring<\/strong> (metrics, alarms): https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Monitoring\/home.htm  <\/li>\n<li><strong>Notifications<\/strong> (email, SMS, PagerDuty-like integrations via HTTPS endpoints): https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Notification\/home.htm  <\/li>\n<li><strong>Logging<\/strong> (service logs where available): https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Logging\/home.htm  <\/li>\n<li><strong>Events<\/strong> (automation triggers): https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Events\/home.htm  <\/li>\n<li><strong>Vault<\/strong> (secrets\/keys when credentials or encryption keys are involved): https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/KeyManagement\/home.htm  <\/li>\n<li><strong>IAM<\/strong> (policies, dynamic groups, compartments): https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Identity\/home.htm  <\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">3. Why use Database Management?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Business reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Reduce downtime and incident duration:<\/strong> centralized performance visibility shortens time-to-detect (TTD) and time-to-resolve (TTR).<\/li>\n<li><strong>Standardize operations:<\/strong> consistent dashboards and workflows reduce dependence on tribal knowledge.<\/li>\n<li><strong>Improve accountability:<\/strong> compartment-scoped access and audit-friendly operations help in regulated environments.<\/li>\n<li><strong>Cost control through operational efficiency:<\/strong> fewer manual interventions and faster troubleshooting reduce operational overhead.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Technical reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Database-aware observability:<\/strong> database metrics and SQL\/performance views are often richer than generic host monitoring.<\/li>\n<li><strong>Fleet-level posture:<\/strong> quickly identify outliers (a single noisy database, a misconfigured instance, unusual load patterns).<\/li>\n<li><strong>Integration with OCI-native telemetry:<\/strong> connect alarms to Notifications and automate responses.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Operational reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Central \u201csingle pane\u201d for database estate:<\/strong> useful for NOC\/SRE rotations.<\/li>\n<li><strong>Repeatable onboarding:<\/strong> standard way to register databases as managed targets.<\/li>\n<li><strong>Better collaboration:<\/strong> DBAs, SREs, and app engineers can share a common view of performance signals.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Security and compliance reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>IAM-based access control:<\/strong> define least-privilege policies by compartment and role (DBA vs observer vs automation).<\/li>\n<li><strong>Audit trails:<\/strong> OCI Audit logs management actions at the API level (verify exact coverage for your operations).<\/li>\n<li><strong>Private connectivity options:<\/strong> where supported, reduce public exposure via private endpoints and VCN patterns.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Scalability \/ performance reasons<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Fleet scaling:<\/strong> operational model scales better than per-host scripts and manual checks.<\/li>\n<li><strong>Performance troubleshooting tooling:<\/strong> helps isolate bottlenecks in SQL execution, waits, and resource utilization (capabilities vary by target type).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">When teams should choose it<\/h3>\n\n\n\n<p>Choose Database Management when you:\n&#8211; Run <strong>Oracle databases<\/strong> in OCI (or supported external targets) and need centralized operational visibility\n&#8211; Want <strong>OCI-native alerting and governance<\/strong>\n&#8211; Need to support <strong>multiple teams<\/strong> with compartment-separated operations\n&#8211; Want a managed service approach rather than building\/maintaining your own observability stack<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">When teams should not choose it<\/h3>\n\n\n\n<p>Database Management may not be the best fit when:\n&#8211; You primarily run <strong>non-Oracle<\/strong> databases (use a different observability toolchain)\n&#8211; You need <strong>deep application tracing<\/strong> (consider OCI APM; Database Management is database-focused)\n&#8211; You already standardized on <strong>Oracle Enterprise Manager<\/strong> for all database management and don\u2019t want to split tooling (some orgs still use both; evaluate overlap)\n&#8211; Your environment requires a feature that is not available for your database target type (always confirm target\/feature compatibility)<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">4. Where is Database Management used?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Industries<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Financial services (regulated operations, strict auditability)<\/li>\n<li>Healthcare (compliance, uptime requirements)<\/li>\n<li>Telecom (large fleets, high throughput)<\/li>\n<li>Retail\/e-commerce (seasonal spikes, performance troubleshooting)<\/li>\n<li>SaaS providers (multi-tenant database operations)<\/li>\n<li>Public sector (governance, compartment separation)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Team types<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DBAs managing fleet health and performance<\/li>\n<li>SRE\/Platform teams integrating alerting and incident response<\/li>\n<li>DevOps teams automating diagnostics and standard dashboards<\/li>\n<li>Security teams reviewing access controls and audit logs<\/li>\n<li>Application teams troubleshooting slow queries (with appropriate access)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Workloads<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OLTP systems needing latency control and consistent performance<\/li>\n<li>Analytics workloads with batch windows and resource contention<\/li>\n<li>Mixed workloads and consolidation scenarios<\/li>\n<li>Mission-critical systems running on OCI database services<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Architectures<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Single-region production with DR region<\/li>\n<li>Multi-compartment setups per environment (dev\/test\/prod)<\/li>\n<li>Hub-and-spoke VCN patterns for private database access<\/li>\n<li>Hybrid estates (OCI + on-prem) where supported<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Real-world deployment contexts<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Production monitoring and on-call readiness<\/li>\n<li>Pre-production performance validation (baseline before release)<\/li>\n<li>Post-incident analysis and operational reviews<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Production vs dev\/test usage<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Production:<\/strong> use alarms, least privilege, private endpoints, standardized dashboards, and change control.<\/li>\n<li><strong>Dev\/test:<\/strong> use fleet visibility to catch misconfigurations early, set lower-cost retention\/feature tiers where possible, and avoid over-alerting.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">5. Top Use Cases and Scenarios<\/h2>\n\n\n\n<p>Below are realistic scenarios where <strong>Oracle Cloud Database Management<\/strong> is commonly used. Feature availability can vary by target type; verify for your database deployment.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1) Fleet health dashboard for DBAs<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> DBAs manage dozens\/hundreds of databases with inconsistent monitoring.<\/li>\n<li><strong>Why it fits:<\/strong> Fleet views consolidate status, key metrics, and health indicators.<\/li>\n<li><strong>Example:<\/strong> A DBA team uses Database Management fleet pages to spot 3 databases with unusual CPU and session spikes after a deployment.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2) Faster SQL performance troubleshooting<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Users report intermittent slowness; root cause unclear.<\/li>\n<li><strong>Why it fits:<\/strong> Database-focused performance views can highlight top SQL, waits, and load patterns (where supported).<\/li>\n<li><strong>Example:<\/strong> An app team identifies a regression caused by a missing index after reviewing top SQL activity and execution changes.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3) Standardized alerting with OCI Alarms + Notifications<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Teams rely on ad-hoc email scripts and manual checks.<\/li>\n<li><strong>Why it fits:<\/strong> Database metrics can feed OCI Monitoring alarms and deliver alerts via Notifications.<\/li>\n<li><strong>Example:<\/strong> An alarm triggers when storage usage approaches a threshold and sends an email to the on-call list.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">4) Onboarding new databases into a governed operations model<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> New databases are created without consistent monitoring or tagging.<\/li>\n<li><strong>Why it fits:<\/strong> Managed database registration plus compartment\/tagging policies enable consistent governance.<\/li>\n<li><strong>Example:<\/strong> A platform team requires every new database to be enabled for Database Management and tagged with owner\/environment.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">5) \u201cNo public exposure\u201d monitoring via private connectivity<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Security policy forbids public endpoints for management traffic.<\/li>\n<li><strong>Why it fits:<\/strong> Where supported, private endpoints\/VCN patterns can keep telemetry traffic private.<\/li>\n<li><strong>Example:<\/strong> A regulated workload uses private endpoints for management connectivity and restricts traffic with NSGs.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6) Operational readiness for audits<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Compliance requires evidence of monitoring, access controls, and change tracking.<\/li>\n<li><strong>Why it fits:<\/strong> IAM policies, compartments, and Audit logs support structured governance.<\/li>\n<li><strong>Example:<\/strong> An audit team reviews who has \u201cmanage\u201d privileges and pulls OCI Audit events for administrative actions.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">7) Pre-release performance baselining<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Teams push a release without knowing its performance impact.<\/li>\n<li><strong>Why it fits:<\/strong> Performance views and metrics can establish baselines and detect regressions.<\/li>\n<li><strong>Example:<\/strong> Before a major launch, the team compares query patterns and resource use against prior baselines.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">8) Capacity planning signals (when paired with other services)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Hard to predict when database resources will saturate.<\/li>\n<li><strong>Why it fits:<\/strong> Database Management provides metrics that can feed planning processes; for deeper planning, pair with Operations Insights (separate service).<\/li>\n<li><strong>Example:<\/strong> The team tracks growth trends in CPU and sessions and uses them to justify scaling before peak season.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">9) Reduce MTTR during incidents<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Too many tools; slow handoffs between app and DBA teams.<\/li>\n<li><strong>Why it fits:<\/strong> Central performance dashboards reduce context-switching.<\/li>\n<li><strong>Example:<\/strong> During an outage, on-call identifies that the database isn\u2019t down; it\u2019s blocked sessions from a single batch job.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">10) Multi-environment visibility (dev\/test\/prod) with compartments<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Engineers need access to dev\/test telemetry without touching prod.<\/li>\n<li><strong>Why it fits:<\/strong> Compartments and policies separate access cleanly.<\/li>\n<li><strong>Example:<\/strong> Developers get read-only access to dev\/test managed databases, while DBAs have elevated access in prod.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">11) Operational automation via Events (where applicable)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Teams want to automatically open tickets or notify Slack when alarms fire.<\/li>\n<li><strong>Why it fits:<\/strong> OCI Alarms + Notifications + Events can integrate with webhooks and ITSM.<\/li>\n<li><strong>Example:<\/strong> A critical alarm posts to an HTTPS endpoint that creates an incident in an ITSM tool.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">12) Consolidated inventory and configuration review<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> Lack of consistent record of versions, key settings, and database attributes.<\/li>\n<li><strong>Why it fits:<\/strong> Database inventory\/configuration surfaces help standardize reviews (availability depends on target type).<\/li>\n<li><strong>Example:<\/strong> Security reviews database configurations quarterly and flags outliers for remediation.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">6. Core Features<\/h2>\n\n\n\n<blockquote>\n<p>Note: Feature availability depends on database target type (OCI database service vs external database), database version\/edition, and enabled management option. Always verify the support matrix in official docs: https:\/\/docs.oracle.com\/en-us\/iaas\/database-management\/home.htm<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">6.1 Managed database fleet views<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does:<\/strong> Presents an inventory and summary of managed databases (health, key metrics, status).<\/li>\n<li><strong>Why it matters:<\/strong> You can operate many databases consistently, not one-by-one.<\/li>\n<li><strong>Practical benefit:<\/strong> Spot anomalies and prioritize response across a fleet.<\/li>\n<li><strong>Caveats:<\/strong> Fleet data depends on successful registration and telemetry collection; misconfigured networking\/credentials can result in missing data.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.2 Database monitoring and metrics integration<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does:<\/strong> Collects and surfaces database telemetry and integrates it with OCI Monitoring (metrics) and alarms.<\/li>\n<li><strong>Why it matters:<\/strong> Enables standardized alerting and dashboards.<\/li>\n<li><strong>Practical benefit:<\/strong> Create alarms for CPU, storage, sessions, wait events, or other supported signals using native OCI mechanisms.<\/li>\n<li><strong>Caveats:<\/strong> Not all signals are available for every target type; metric names and namespaces can differ by database service (verify in Monitoring UI for your database).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.3 Performance troubleshooting pages (Performance Hub-style capabilities)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does:<\/strong> Provides database performance troubleshooting views (for example, load analysis and SQL-focused troubleshooting where supported).<\/li>\n<li><strong>Why it matters:<\/strong> Database incidents often require SQL-level investigation, not just host metrics.<\/li>\n<li><strong>Practical benefit:<\/strong> Faster identification of top SQL, bottlenecks, and abnormal activity patterns.<\/li>\n<li><strong>Caveats:<\/strong> Some performance data relies on database instrumentation and privileges; for external\/on-prem targets, licensing or configuration requirements may apply (verify Oracle licensing requirements for diagnostics\/tuning features).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.4 SQL monitoring \/ top SQL insights (where available)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does:<\/strong> Helps identify resource-consuming SQL and problematic execution patterns.<\/li>\n<li><strong>Why it matters:<\/strong> In many production incidents, a small number of SQL statements cause most of the pain.<\/li>\n<li><strong>Practical benefit:<\/strong> Quickly isolate \u201cbad actors\u201d and correlate them with application changes.<\/li>\n<li><strong>Caveats:<\/strong> SQL-level visibility may require additional database privileges and may not be enabled by default.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.5 Alerts and operational workflows<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does:<\/strong> Supports operational alerting by integrating with Monitoring alarms and Notifications topics\/subscriptions.<\/li>\n<li><strong>Why it matters:<\/strong> Observability without alerting is incomplete for production operations.<\/li>\n<li><strong>Practical benefit:<\/strong> Notify on-call teams, trigger webhooks, and standardize incident entry points.<\/li>\n<li><strong>Caveats:<\/strong> Over-alerting is common; tune thresholds and use severity-based routing.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.6 IAM + compartment governance<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does:<\/strong> Uses OCI IAM policies to control who can view\/manage managed databases and related resources.<\/li>\n<li><strong>Why it matters:<\/strong> Database operations are security-sensitive.<\/li>\n<li><strong>Practical benefit:<\/strong> Enforce least privilege and environment separation (dev\/test\/prod).<\/li>\n<li><strong>Caveats:<\/strong> Mis-scoped policies are a frequent cause of \u201cI can\u2019t see my database\u201d issues.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.7 Private connectivity patterns (private endpoints where applicable)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does:<\/strong> Allows management connectivity to stay on private network paths (depending on target type and feature).<\/li>\n<li><strong>Why it matters:<\/strong> Reduces attack surface and aligns with \u201cno public management plane\u201d policies.<\/li>\n<li><strong>Practical benefit:<\/strong> Use VCN, subnets, and NSGs to tightly control traffic.<\/li>\n<li><strong>Caveats:<\/strong> Private DNS, routing, and NSG rules must be correct; hybrid connectivity may require FastConnect\/VPN.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.8 APIs and automation foundations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does:<\/strong> Supports programmatic operations through OCI APIs (and commonly via OCI SDK\/CLI where supported).<\/li>\n<li><strong>Why it matters:<\/strong> Platform teams need automation and consistency.<\/li>\n<li><strong>Practical benefit:<\/strong> Integrate with CI\/CD, runbooks, or internal portals for onboarding and operational tasks.<\/li>\n<li><strong>Caveats:<\/strong> API surface differs by feature; validate endpoints and required permissions in the API reference.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">6.9 Tagging and cost attribution support<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>What it does:<\/strong> Uses OCI tagging to organize and attribute resources (managed database resources, alarms, notifications, etc.).<\/li>\n<li><strong>Why it matters:<\/strong> Governance at scale requires consistent metadata.<\/li>\n<li><strong>Practical benefit:<\/strong> Filter fleets by owner\/app\/environment; improve cost reporting.<\/li>\n<li><strong>Caveats:<\/strong> Tagging strategy must be designed; retroactive tagging can be time-consuming.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">7. Architecture and How It Works<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">High-level service architecture<\/h3>\n\n\n\n<p>Database Management uses an OCI-hosted control plane to maintain a representation of each monitored target as a <strong>managed database<\/strong>. Telemetry is collected either:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Natively<\/strong> from OCI database services that integrate directly, or<\/li>\n<li>Through an <strong>agent\/connector<\/strong> pattern for externally connected databases (depending on supported targets)<\/li>\n<\/ul>\n\n\n\n<p>Collected data is surfaced in the Database Management UI and APIs, and key metrics integrate with <strong>OCI Monitoring<\/strong> so you can create alarms and route notifications.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Request\/data\/control flow (conceptual)<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Enable \/ register database<\/strong> for Database Management.<\/li>\n<li><strong>Authorize access<\/strong> using IAM policies and (where required) database credentials\/privileges.<\/li>\n<li><strong>Collect telemetry<\/strong> (native integration or agent-based).<\/li>\n<li><strong>Store and surface<\/strong> telemetry in Database Management views.<\/li>\n<li><strong>Emit metrics<\/strong> to OCI Monitoring and configure alarms.<\/li>\n<li><strong>Route alerts<\/strong> via OCI Notifications (email\/HTTPS\/etc.).<\/li>\n<li><strong>Audit actions<\/strong> via OCI Audit logs for governance and security review.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Integrations with related OCI services<\/h3>\n\n\n\n<p>Common integrations include:\n&#8211; <strong>Monitoring + Alarms<\/strong> for thresholds and alerting\n&#8211; <strong>Notifications<\/strong> for delivery channels\n&#8211; <strong>Events<\/strong> for automation triggers\n&#8211; <strong>Logging<\/strong> for log-centric workflows (where relevant)\n&#8211; <strong>Vault<\/strong> for secrets management (especially when credentials are involved)\n&#8211; <strong>IAM<\/strong> for all authorization and tenancy governance<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Dependency services (typical)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>An OCI database service (for example, Autonomous Database) or supported external database environment<\/li>\n<li>Network infrastructure (VCNs\/subnets\/NSGs) if private connectivity patterns are required<\/li>\n<li>Monitoring + Notifications for alerting<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Security\/authentication model<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OCI <strong>IAM policies<\/strong> control access to Database Management resources and operations.<\/li>\n<li>Managed targets that require database-level access typically require:<\/li>\n<li>A database user with appropriate privileges, and<\/li>\n<li>Secure handling of credentials (often via OCI Vault; verify per target type)<\/li>\n<li>For external connectivity, agents communicate outbound to OCI endpoints over TLS (typical cloud agent pattern); ensure egress rules allow required endpoints (verify exact endpoints\/ports in docs).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Networking model<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For OCI-native databases, much of the integration is service-to-service.<\/li>\n<li>For external\/compute-hosted databases, plan for:<\/li>\n<li><strong>Outbound connectivity<\/strong> from agent to OCI endpoints<\/li>\n<li><strong>Private endpoint patterns<\/strong> (if using private connectivity) within a VCN\/subnet<\/li>\n<li>NSG and route rules to restrict and control traffic<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Monitoring\/logging\/governance considerations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Treat Database Management as part of a broader observability posture:<\/li>\n<li>Alarms should map to SLOs and operational runbooks<\/li>\n<li>Use tags and compartments for ownership and environment boundaries<\/li>\n<li>Regularly review IAM policies and Audit events<\/li>\n<li>Maintain an onboarding checklist for new databases<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Simple architecture diagram (Mermaid)<\/h3>\n\n\n\n<pre><code class=\"language-mermaid\">flowchart LR\n  DB[(Oracle Database Target)] --&gt;|Telemetry\/Integration| DBM[OCI Database Management]\n  DBM --&gt; MON[OCI Monitoring (Metrics\/Alarms)]\n  MON --&gt; ONS[OCI Notifications]\n  DBM --&gt; IAM[OCI IAM (Policies\/Compartments)]\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Production-style architecture diagram (Mermaid)<\/h3>\n\n\n\n<pre><code class=\"language-mermaid\">flowchart TB\n  subgraph Tenancy[OCI Tenancy]\n    subgraph CompartmentProd[Compartment: Prod]\n      ADB[(Autonomous Database)]\n      EXACS[(Exadata Database Service)]\n      ALARMS[Monitoring Alarms]\n      TOPIC[Notifications Topic]\n      VAULT[OCI Vault]\n      LOG[OCI Logging]\n    end\n\n    subgraph CompartmentShared[Compartment: Shared Services]\n      DBM[Database Management]\n      IAM[IAM Policies &amp; Dynamic Groups]\n      AUDIT[OCI Audit]\n      EVENTS[OCI Events]\n    end\n\n    subgraph VCN[VCN: Prod-VCN]\n      PE[DB Mgmt Private Endpoint\\n(if applicable)]\n      NSG[NSG Rules]\n    end\n\n    subgraph Hybrid[On-prem \/ Other Cloud\\n(if supported)]\n      EXTDB[(External Oracle Database)]\n      AGENT[Management Agent\\n(if required)]\n    end\n  end\n\n  ADB --&gt; DBM\n  EXACS --&gt; DBM\n\n  EXTDB --&gt; AGENT --&gt;|TLS egress| DBM\n  PE --- DBM\n  NSG --- PE\n\n  DBM --&gt; ALARMS --&gt; TOPIC\n  DBM --&gt; LOG\n  DBM --&gt; AUDIT\n  EVENTS --&gt; TOPIC\n  VAULT --- DBM\n  IAM --- DBM\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">8. Prerequisites<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">OCI account\/tenancy requirements<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>An active <strong>Oracle Cloud<\/strong> tenancy with access to the region where your databases run.<\/li>\n<li>Ability to create or access:<\/li>\n<li>Compartments<\/li>\n<li>The database target (for example, Autonomous Database)<\/li>\n<li>Observability resources (Monitoring alarms, Notifications topics)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Permissions \/ IAM roles<\/h3>\n\n\n\n<p>If you are a tenancy administrator, you can complete the lab more easily. For least-privilege access, you typically need permissions for:\n&#8211; Database Management\n&#8211; The database service you are using (for example, Autonomous Database)\n&#8211; Monitoring\/Alarms\n&#8211; Notifications<\/p>\n\n\n\n<p>OCI policy syntax is precise and service-specific. Use the official policy reference and Database Management policy examples for your target type:\n&#8211; IAM policies overview: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Identity\/policies\/overview.htm<br\/>\n&#8211; Database Management docs: https:\/\/docs.oracle.com\/en-us\/iaas\/database-management\/home.htm  <\/p>\n\n\n\n<p><strong>Example policy set (verify in official docs before production use):<\/strong><\/p>\n\n\n\n<pre><code class=\"language-text\">Allow group DBM-Lab-Admins to manage autonomous-database-family in compartment DBM-Lab\nAllow group DBM-Lab-Admins to manage dbmgmt-family in compartment DBM-Lab\nAllow group DBM-Lab-Admins to manage ons-topics in compartment DBM-Lab\nAllow group DBM-Lab-Admins to manage ons-subscriptions in compartment DBM-Lab\nAllow group DBM-Lab-Admins to manage alarms in compartment DBM-Lab\nAllow group DBM-Lab-Admins to read metrics in compartment DBM-Lab\n<\/code><\/pre>\n\n\n\n<p>If any statement fails validation in your tenancy, use the Console policy editor suggestions and the official policy reference for the correct resource types\/verbs.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Billing requirements<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You need a billing-enabled tenancy.<\/li>\n<li>This lab aims to be low-cost and can often be done using <strong>Always Free<\/strong> resources (for example, Always Free Autonomous Database), but <strong>Database Management pricing may still apply depending on management option and features<\/strong>. Verify pricing for your region and target type.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">CLI\/SDK\/tools<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OCI Console access is sufficient for this tutorial.<\/li>\n<li>Optional:<\/li>\n<li>OCI CLI: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/API\/CLI.htm  <\/li>\n<li>SQL access via Database Actions (Autonomous Database) or SQL*Plus\/SQLcl depending on your target.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Region availability<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Database Management is not necessarily available in every OCI region in the same way at all times.<\/li>\n<li>Check <strong>OCI service availability<\/strong> and your region\u2019s service list in the Console, and verify via official sources:<\/li>\n<li>Regions overview: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/General\/Concepts\/regions.htm  <\/li>\n<li>OCI public regions list: https:\/\/www.oracle.com\/cloud\/public-cloud-regions\/<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Quotas\/limits<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Database Management and dependent services have tenancy and compartment limits.<\/li>\n<li>Check and request increases if needed:<\/li>\n<li>Service limits overview: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/General\/Concepts\/servicelimits.htm  <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Prerequisite services<\/h3>\n\n\n\n<p>For this hands-on lab:\n&#8211; Autonomous Database (Always Free recommended)\n&#8211; Monitoring + Alarms\n&#8211; Notifications<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">9. Pricing \/ Cost<\/h2>\n\n\n\n<blockquote>\n<p>Pricing changes over time and varies by region, SKU, and contract. Use official sources for current pricing and always validate in your target region.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">Official pricing sources<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Cloud pricing list: https:\/\/www.oracle.com\/cloud\/price-list\/  <\/li>\n<li>OCI Cost Estimator (calculator): https:\/\/www.oracle.com\/cloud\/costestimator.html  <\/li>\n<li>Database Management docs (often link to pricing and feature tiers): https:\/\/docs.oracle.com\/en-us\/iaas\/database-management\/home.htm  <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Pricing dimensions (typical model)<\/h3>\n\n\n\n<p>Database Management pricing is commonly based on one or more of the following (verify the current model in the official price list for your region):<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Management option \/ tier<\/strong> enabled for a database (for example, basic vs advanced\/enterprise-style management options)<\/li>\n<li><strong>Number of managed databases<\/strong> or the size of managed resources<\/li>\n<li><strong>Database compute characteristics<\/strong> (for example, cores\/OCPUs or similar sizing dimensions) depending on the SKU<\/li>\n<li><strong>Additional capabilities<\/strong> (for example, deeper performance analysis features) that may be priced separately<\/li>\n<\/ul>\n\n\n\n<p>Because Oracle databases also have edition\/licensing considerations (especially outside OCI), always confirm:\n&#8211; Whether performance diagnostics features require separate licensing for your deployment model\n&#8211; Whether enabling certain performance views changes your billing or licensing posture<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Free tier considerations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OCI offers an <strong>Always Free<\/strong> tier for certain services (including some Autonomous Database offerings).<\/li>\n<li>Whether Database Management itself is free for a given Always Free database depends on current OCI policy and the management option used. <strong>Verify in official docs\/pricing<\/strong> before assuming \u201cfree.\u201d<\/li>\n<\/ul>\n\n\n\n<p>Always Free overview: https:\/\/www.oracle.com\/cloud\/free\/<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Main cost drivers<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>How many databases<\/strong> you enable for Database Management<\/li>\n<li><strong>Which management option<\/strong> you select per database (if applicable)<\/li>\n<li><strong>Retention and volume of performance data<\/strong> (where configurable)<\/li>\n<li><strong>Alarms\/notifications volume<\/strong> (not usually expensive, but operationally noisy)<\/li>\n<li><strong>Network egress<\/strong> for hybrid connectivity (agent sending telemetry outbound from on-prem; egress pricing depends on your network path and provider)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Hidden or indirect costs<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Operational cost:<\/strong> time spent tuning alarms and access policies<\/li>\n<li><strong>Hybrid connectivity:<\/strong> VPN\/FastConnect costs if you require private connectivity from on-prem<\/li>\n<li><strong>Associated services:<\/strong> Monitoring, Notifications, Logging usage beyond free allotments (check each service\u2019s pricing page)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Network\/data transfer implications<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OCI charges can apply for data egress depending on direction and destination (internet vs inter-region vs on-prem via specific connectivity).<\/li>\n<li>For agent-based telemetry from on-prem, consider:<\/li>\n<li>Outbound traffic volume<\/li>\n<li>Required endpoints<\/li>\n<li>Whether traffic traverses the public internet or private connectivity<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">How to optimize cost<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Start with the minimal management option that meets your needs.<\/li>\n<li>Enable advanced performance features only on:<\/li>\n<li>Critical production databases<\/li>\n<li>Databases with frequent performance incidents<\/li>\n<li>Use compartments and tags to track adoption and attribute cost by team.<\/li>\n<li>Reduce alert noise (fewer incidents means lower operational cost).<\/li>\n<li>If you only need capacity planning, compare with <strong>Operations Insights<\/strong> (separate service) rather than enabling more advanced features everywhere.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Example low-cost starter estimate (no fabricated numbers)<\/h3>\n\n\n\n<p>A starter lab setup might include:\n&#8211; 1 Always Free Autonomous Database\n&#8211; Database Management enabled for that single database (management option dependent)\n&#8211; 1\u20133 alarms and a single email notification topic<\/p>\n\n\n\n<p>To estimate cost accurately:\n1. Open the OCI Cost Estimator: https:\/\/www.oracle.com\/cloud\/costestimator.html<br\/>\n2. Add Database Management and your database service.\n3. Select your region and the specific SKUs\/options you will enable.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example production cost considerations (what to model)<\/h3>\n\n\n\n<p>For production, model:\n&#8211; Number of production databases enabled\n&#8211; Average database size\/cores and tier selection\n&#8211; Performance feature usage on a subset (tiered rollout)\n&#8211; Alarm volume and retention\n&#8211; Hybrid connectivity costs (if applicable)<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">10. Step-by-Step Hands-On Tutorial<\/h2>\n\n\n\n<p>This lab uses <strong>Autonomous Database<\/strong> because it\u2019s the fastest and lowest-ops way to get a real database target into <strong>Oracle Cloud Database Management<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Objective<\/h3>\n\n\n\n<p>Enable <strong>Database Management<\/strong> for an <strong>Oracle Autonomous Database<\/strong> in Oracle Cloud, explore managed database fleet\/performance views, and set up a basic alarm with Notifications.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Lab Overview<\/h3>\n\n\n\n<p>You will:\n1. Create a compartment for the lab.\n2. Create a Notifications topic and email subscription.\n3. Create an Always Free Autonomous Database.\n4. Enable Database Management for the database.\n5. Verify the database appears as a managed database and review key metrics\/performance pages.\n6. Create an alarm to notify you when a database metric crosses a threshold.\n7. Clean up all resources.<\/p>\n\n\n\n<p><strong>Estimated time:<\/strong> 45\u201375 minutes (including provisioning and waiting for telemetry)<br\/>\n<strong>Cost:<\/strong> Often low or free with Always Free resources, but <strong>verify Database Management pricing and the management option selected<\/strong>.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Create a compartment for the lab<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In the OCI Console, open the navigation menu.<\/li>\n<li>Go to <strong>Identity &amp; Security \u2192 Compartments<\/strong>.<\/li>\n<li>Click <strong>Create Compartment<\/strong>.<\/li>\n<li>Name: <code>DBM-Lab<\/code><br\/>\n   Description: <code>Database Management hands-on lab<\/code><\/li>\n<li>Click <strong>Create Compartment<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p><strong>Expected outcome:<\/strong> A new compartment <code>DBM-Lab<\/code> exists and you can select it in the compartment dropdown.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; Confirm <code>DBM-Lab<\/code> appears in the compartments list.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: (Optional but recommended) Create IAM access for a lab group<\/h3>\n\n\n\n<p>If you are already a tenancy admin, you can skip this step.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to <strong>Identity &amp; Security \u2192 Groups<\/strong> and create a group, e.g. <code>DBM-Lab-Admins<\/code>.<\/li>\n<li>Add your user to the group.<\/li>\n<li>Go to <strong>Identity &amp; Security \u2192 Policies<\/strong>.<\/li>\n<li>Create a policy in the <strong>root compartment<\/strong> or a parent compartment (based on your org\u2019s governance) that grants access in <code>DBM-Lab<\/code>.<\/li>\n<\/ol>\n\n\n\n<p><strong>Example policy (verify syntax in your tenancy):<\/strong><\/p>\n\n\n\n<pre><code class=\"language-text\">Allow group DBM-Lab-Admins to manage autonomous-database-family in compartment DBM-Lab\nAllow group DBM-Lab-Admins to manage dbmgmt-family in compartment DBM-Lab\nAllow group DBM-Lab-Admins to manage alarms in compartment DBM-Lab\nAllow group DBM-Lab-Admins to manage ons-topics in compartment DBM-Lab\nAllow group DBM-Lab-Admins to manage ons-subscriptions in compartment DBM-Lab\nAllow group DBM-Lab-Admins to read metrics in compartment DBM-Lab\n<\/code><\/pre>\n\n\n\n<p><strong>Expected outcome:<\/strong> Your user can create the database and manage Database Management resources in <code>DBM-Lab<\/code>.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; Switch to the <code>DBM-Lab<\/code> compartment and confirm you can access Autonomous Database creation.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Create a Notifications topic + email subscription<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to <strong>Developer Services \u2192 Notifications<\/strong> (or search for \u201cNotifications\u201d).<\/li>\n<li>Select compartment: <code>DBM-Lab<\/code>.<\/li>\n<li>Click <strong>Create Topic<\/strong>.<\/li>\n<li>Name: <code>dbm-lab-topic<\/code><\/li>\n<li>Click <strong>Create<\/strong>.<\/li>\n<li>Open the topic and click <strong>Create Subscription<\/strong>.<\/li>\n<li>Protocol: <code>EMAIL<\/code><\/li>\n<li>Email: your email address<\/li>\n<li>Click <strong>Create<\/strong>.<\/li>\n<li>Check your email and confirm the subscription (there is typically a confirmation link).<\/li>\n<\/ol>\n\n\n\n<p><strong>Expected outcome:<\/strong> You have an active email subscription on the topic.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; In the topic details, confirm the subscription status shows as <strong>Active<\/strong> (after confirmation).<\/p>\n\n\n\n<p><strong>Common error:<\/strong>\n&#8211; Subscription stays in <strong>Pending<\/strong> until you click the confirmation link.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Create an Always Free Autonomous Database<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to <strong>Oracle Database \u2192 Autonomous Database<\/strong>.<\/li>\n<li>Select compartment: <code>DBM-Lab<\/code>.<\/li>\n<li>Click <strong>Create Autonomous Database<\/strong>.<\/li>\n<li>Choose a workload type (ATP or ADW). For general labs, ATP is common.<\/li>\n<li>Set:\n   &#8211; Display name: <code>dbm-lab-adb<\/code>\n   &#8211; Database name: <code>DBMLAB<\/code>\n   &#8211; Choose <strong>Always Free<\/strong> if available<\/li>\n<li>Set an admin password (store it securely).<\/li>\n<li>Click <strong>Create Autonomous Database<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p>Wait for the database lifecycle state to become <strong>Available<\/strong>.<\/p>\n\n\n\n<p><strong>Expected outcome:<\/strong> An Autonomous Database is running in <code>DBM-Lab<\/code>.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; Open the database details page and confirm status is <strong>Available<\/strong>.<\/p>\n\n\n\n<p><strong>Cost note:<\/strong> Always Free availability depends on tenancy limits and region capacity.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5: Enable Database Management for the Autonomous Database<\/h3>\n\n\n\n<p>The exact UI wording can change, but typically you enable Database Management either:\n&#8211; From the Autonomous Database details page, or\n&#8211; From the Database Management service pages under Observability &amp; Management<\/p>\n\n\n\n<p>Try this path first:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open your Autonomous Database <code>dbm-lab-adb<\/code>.<\/li>\n<li>Look for a section such as <strong>Database Management<\/strong> or <strong>Management<\/strong>.<\/li>\n<li>Click <strong>Enable Database Management<\/strong> (or similar).<\/li>\n<li>If prompted, choose the <strong>management option<\/strong> (names and tiers vary\u2014select the lowest option that still enables visibility for your lab; verify pricing impact).<\/li>\n<li>Confirm the compartment is <code>DBM-Lab<\/code>.<\/li>\n<li>Confirm\/enable.<\/li>\n<\/ol>\n\n\n\n<p>Wait a few minutes for onboarding and telemetry to populate.<\/p>\n\n\n\n<p><strong>Expected outcome:<\/strong> Database Management is enabled and the database is registered\/visible as a managed database.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; Go to <strong>Observability &amp; Management \u2192 Database Management<\/strong>.\n&#8211; Select compartment <code>DBM-Lab<\/code>.\n&#8211; Confirm you see your database in the fleet or managed databases list.<\/p>\n\n\n\n<p><strong>Common error:<\/strong>\n&#8211; You enabled Database Management in one compartment, but you\u2019re viewing another in the Database Management pages.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 6: Explore the managed database details and performance views<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In <strong>Database Management<\/strong>, open the managed database entry for <code>dbm-lab-adb<\/code>.<\/li>\n<li>Review:\n   &#8211; Overview\/summary page\n   &#8211; Key metrics and charts\n   &#8211; Any performance pages (for example, performance hub-style views if available)<\/li>\n<\/ol>\n\n\n\n<p>If you want to generate a small amount of workload:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>On the Autonomous Database details page, open <strong>Database Actions<\/strong> (if enabled).<\/li>\n<li>Open <strong>SQL Worksheet<\/strong>.<\/li>\n<li>Run a simple query a few times, for example:<\/li>\n<\/ol>\n\n\n\n<pre><code class=\"language-sql\">SELECT COUNT(*) FROM ALL_OBJECTS;\n<\/code><\/pre>\n\n\n\n<p>Or run a slightly heavier query (don\u2019t overdo it on Always Free):<\/p>\n\n\n\n<pre><code class=\"language-sql\">SELECT \/*+ FULL(a) FULL(b) *\/ COUNT(*)\nFROM ALL_OBJECTS a, ALL_OBJECTS b\nWHERE a.OBJECT_ID = b.OBJECT_ID;\n<\/code><\/pre>\n\n\n\n<p><strong>Expected outcome:<\/strong> You can navigate Database Management views and see current charts\/metrics. With some activity, you may observe changes in load-related charts.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; Confirm charts show recent timestamps and are not empty.\n&#8211; Confirm the managed database status indicates it is reachable\/healthy (wording varies).<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Step 7: Create a Monitoring alarm and route it to Notifications<\/h3>\n\n\n\n<p>You will create an alarm on an Autonomous Database metric and send notifications to your email topic.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to <strong>Observability &amp; Management \u2192 Monitoring \u2192 Alarms<\/strong>.<\/li>\n<li>Select compartment: <code>DBM-Lab<\/code>.<\/li>\n<li>Click <strong>Create Alarm<\/strong>.<\/li>\n<li>Name: <code>dbm-lab-adb-alarm<\/code><\/li>\n<li>For metric selection:\n   &#8211; Resource type: choose <strong>Autonomous Database<\/strong> (or equivalent)\n   &#8211; Compartment: <code>DBM-Lab<\/code>\n   &#8211; Metric namespace: select the Autonomous Database namespace offered in the UI\n   &#8211; Metric: pick a commonly available metric such as CPU utilization or storage usage<\/li>\n<li>Set a threshold that is easy to validate (for example, a low CPU threshold for a short time window).<\/li>\n<li>In <strong>Notifications<\/strong>, select your topic: <code>dbm-lab-topic<\/code><\/li>\n<li>Save the alarm.<\/li>\n<\/ol>\n\n\n\n<p><strong>Expected outcome:<\/strong> The alarm is created and transitions to <strong>OK<\/strong> after evaluation, and will trigger when your metric crosses the threshold.<\/p>\n\n\n\n<p><strong>Verification:<\/strong>\n&#8211; In the alarms list, confirm the alarm state is <strong>OK<\/strong>.\n&#8211; If you intentionally generate load and exceed the threshold long enough, confirm the alarm transitions to <strong>FIRING<\/strong> and you receive an email.<\/p>\n\n\n\n<p><strong>Common errors and fixes:<\/strong>\n&#8211; <strong>No metrics appear:<\/strong> Wait 5\u201315 minutes after enabling Database Management and after database activity; confirm you selected the correct compartment and resource.\n&#8211; <strong>Alarm never fires:<\/strong> Your threshold is too high or the evaluation window is too long. Reduce threshold or shorten duration.\n&#8211; <strong>No email received:<\/strong> Confirm Notifications subscription is Active and check spam filters.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Validation<\/h3>\n\n\n\n<p>Use this checklist:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>[ ] <code>dbm-lab-adb<\/code> is <strong>Available<\/strong><\/li>\n<li>[ ] Database Management is <strong>enabled<\/strong> for the database<\/li>\n<li>[ ] The database appears under <strong>Database Management<\/strong> fleet\/managed databases<\/li>\n<li>[ ] You can open the managed database details and see current charts<\/li>\n<li>[ ] A Monitoring alarm exists and shows <strong>OK<\/strong><\/li>\n<li>[ ] Notifications topic subscription is <strong>Active<\/strong><\/li>\n<li>[ ] (Optional) Alarm can be forced to <strong>FIRING<\/strong> by workload or threshold tuning<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Troubleshooting<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Issue: \u201cI can\u2019t see Database Management pages or actions\u201d<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Confirm your IAM policies allow access to Database Management in compartment <code>DBM-Lab<\/code>.<\/li>\n<li>Confirm you are in the correct region and correct compartment.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Issue: Database is not listed as a managed database<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Confirm Database Management is enabled for the database (re-check the ADB details page).<\/li>\n<li>Wait for onboarding\/telemetry propagation (often several minutes).<\/li>\n<li>Confirm you are checking <strong>Database Management<\/strong> in the same compartment where the database resides.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Issue: Metrics are empty or delayed<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Generate some activity (run a few SQL queries).<\/li>\n<li>Wait for metric ingestion intervals.<\/li>\n<li>Confirm Monitoring is showing the correct resource and time range.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Issue: Notifications not received<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verify subscription confirmation.<\/li>\n<li>Check spam\/junk filters.<\/li>\n<li>Confirm alarm is actually firing (not just created).<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h3 class=\"wp-block-heading\">Cleanup<\/h3>\n\n\n\n<p>To avoid ongoing costs:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\n<p><strong>Delete the alarm<\/strong>\n   &#8211; Monitoring \u2192 Alarms \u2192 select <code>dbm-lab-adb-alarm<\/code> \u2192 Delete<\/p>\n<\/li>\n<li>\n<p><strong>Delete the Notifications topic (and subscriptions)<\/strong>\n   &#8211; Notifications \u2192 <code>dbm-lab-topic<\/code> \u2192 Delete<br\/>\n   (Subscriptions are removed with the topic.)<\/p>\n<\/li>\n<li>\n<p><strong>Terminate the Autonomous Database<\/strong>\n   &#8211; Autonomous Database \u2192 <code>dbm-lab-adb<\/code> \u2192 More actions \u2192 Terminate\n   &#8211; Confirm termination<\/p>\n<\/li>\n<li>\n<p><strong>Delete the compartment<\/strong> (optional, only after everything inside is removed)\n   &#8211; Identity \u2192 Compartments \u2192 <code>DBM-Lab<\/code> \u2192 Delete<br\/>\n   Note: compartment deletion can take time and will fail if any resources remain.<\/p>\n<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">11. Best Practices<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Architecture best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Separate by compartments:<\/strong> isolate prod\/non-prod and teams; align with your org\u2019s landing zone design.<\/li>\n<li><strong>Use a fleet strategy:<\/strong> standard tags and naming conventions make fleet views useful at scale.<\/li>\n<li><strong>Tiered enablement:<\/strong> enable advanced performance features on critical databases first; expand based on value.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">IAM\/security best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Least privilege:<\/strong> create roles such as:<\/li>\n<li>DBM-Observers (read-only)<\/li>\n<li>DBM-Operators (alarms\/notifications)<\/li>\n<li>DBM-Admins (full manage)<\/li>\n<li><strong>Environment separation:<\/strong> don\u2019t grant dev access to prod compartments.<\/li>\n<li><strong>Prefer groups and dynamic groups<\/strong> (for automation) over individual user permissions.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Cost best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Start small:<\/strong> enable Database Management on a subset, measure value, then scale.<\/li>\n<li><strong>Avoid blanket advanced tiers:<\/strong> match management option to the database criticality.<\/li>\n<li><strong>Use tags for cost attribution:<\/strong> <code>CostCenter<\/code>, <code>AppName<\/code>, <code>Environment<\/code>, <code>Owner<\/code>.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Performance best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Baseline first:<\/strong> record \u201cnormal\u201d before tuning thresholds.<\/li>\n<li><strong>Tune alerts to symptoms:<\/strong> alert on meaningful indicators (sustained high CPU, storage near full, connection spikes).<\/li>\n<li><strong>Correlate with app changes:<\/strong> combine database signals with deployment events.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Reliability best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Standardize alarm routing:<\/strong> ensure critical alarms reach on-call 24\/7; route lower severity to ticket queues.<\/li>\n<li><strong>Runbook links:<\/strong> include runbook references in alarm descriptions.<\/li>\n<li><strong>Test alerting:<\/strong> validate at least quarterly that alarms fire and notifications reach the right responders.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Operations best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Operational dashboards:<\/strong> build standard views for NOC\/SRE.<\/li>\n<li><strong>Change management:<\/strong> track configuration changes and who performed them (Audit + tagging + ticket references).<\/li>\n<li><strong>Continuous onboarding:<\/strong> new databases must be enabled and tagged as part of provisioning pipelines.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Governance\/tagging\/naming best practices<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Naming:<\/li>\n<li><code>env-app-db<\/code> (example: <code>prod-orders-adb<\/code>)<\/li>\n<li>Tags:<\/li>\n<li><code>Environment=prod|dev|test<\/code><\/li>\n<li><code>Owner=email\/team<\/code><\/li>\n<li><code>AppName=orders<\/code><\/li>\n<li><code>CostCenter=...<\/code><\/li>\n<li>Policies:<\/li>\n<li>Use compartment hierarchies that match org structure and blast radius boundaries.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">12. Security Considerations<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Identity and access model<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Database Management access is controlled by <strong>OCI IAM<\/strong>:<\/li>\n<li>Policies grant permissions to groups\/dynamic groups in compartments.<\/li>\n<li>Use <strong>read-only<\/strong> permissions for most users; reserve manage permissions for DBAs\/platform admins.<\/li>\n<li>For target connections that require credentials:<\/li>\n<li>Use database users with the <strong>minimum required privileges<\/strong><\/li>\n<li>Prefer <strong>OCI Vault<\/strong> for secret storage if supported by the onboarding method (verify per target type)<\/li>\n<\/ul>\n\n\n\n<p>IAM documentation: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Identity\/home.htm<br\/>\nVault documentation: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/KeyManagement\/home.htm  <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Encryption<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OCI services use encryption in transit (TLS) and at rest for managed service data, but you should still:<\/li>\n<li>Confirm encryption specifics for telemetry and stored data in official docs<\/li>\n<li>Use customer-managed keys (CMK) where required and supported<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Network exposure<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Avoid public exposure for management traffic where possible:<\/li>\n<li>Prefer private endpoints \/ private connectivity patterns (if supported)<\/li>\n<li>Restrict egress from agents to only required OCI endpoints<\/li>\n<li>Use NSGs and route rules for least-access networking<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Secrets handling<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Don\u2019t store passwords in scripts or on jump hosts.<\/li>\n<li>Rotate credentials regularly.<\/li>\n<li>Use OCI Vault secrets where supported; restrict access via IAM and audit usage.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Audit\/logging<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OCI Audit captures API calls for many service operations:<\/li>\n<li>Use Audit for investigations and compliance reporting<\/li>\n<li>Export Audit logs to a SIEM if required<\/li>\n<\/ul>\n\n\n\n<p>Audit documentation: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Audit\/home.htm<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Compliance considerations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Map Database Management access to your control framework:<\/li>\n<li>Least privilege and separation of duties<\/li>\n<li>Evidence of monitoring and alerting<\/li>\n<li>Access reviews and logging retention<\/li>\n<li>If operating in regulated industries, document:<\/li>\n<li>Which data is collected<\/li>\n<li>Where it is stored (region)<\/li>\n<li>Retention and access controls<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Common security mistakes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Granting broad \u201cmanage\u201d rights in the root compartment to too many users<\/li>\n<li>Leaving databases manageable over public endpoints when private options exist<\/li>\n<li>Not confirming what advanced performance features imply for licensing in external environments<\/li>\n<li>Failing to confirm email subscription routing (alerts going to individual inboxes instead of on-call systems)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Secure deployment recommendations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use compartments per environment and team.<\/li>\n<li>Use private connectivity patterns and NSGs where possible.<\/li>\n<li>Centralize alert routing (Notifications topics) owned by platform\/SRE.<\/li>\n<li>Periodically review policies, tags, and Audit logs.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">13. Limitations and Gotchas<\/h2>\n\n\n\n<blockquote>\n<p>The most important limitation: <strong>Database Management is Oracle Database-focused.<\/strong> It is not a general-purpose monitoring platform for all database engines.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">Known limitations (typical)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Target\/feature variability:<\/strong> Not every feature applies to every database target type.<\/li>\n<li><strong>Hybrid complexity:<\/strong> External targets can require agents\/connectors, networking, and credential management.<\/li>\n<li><strong>Data latency:<\/strong> Metrics and performance data may have ingestion intervals; don\u2019t expect instant visibility.<\/li>\n<li><strong>UI differences:<\/strong> Console labels and navigation can change; use official docs for current steps.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Quotas and limits<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Limits exist for related resources (alarms, notifications, endpoints, agents). Check service limits:\n  https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/General\/Concepts\/servicelimits.htm<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Regional constraints<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Service availability can differ by region. Validate in your region:<\/li>\n<li>OCI regions: https:\/\/www.oracle.com\/cloud\/public-cloud-regions\/<\/li>\n<li>Service availability (Console service list per region)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Pricing surprises<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enabling more advanced management options across many databases can create unexpected spend.<\/li>\n<li>Hybrid connectivity costs (VPN\/FastConnect) are often larger than expected.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Compatibility issues<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Some metrics\/performance features depend on database version\/edition and enabled instrumentation.<\/li>\n<li>For external\/on-prem databases, licensing for diagnostics\/tuning packs may apply. <strong>Confirm with Oracle licensing guidance and your account team.<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Operational gotchas<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Wrong compartment selection is a top cause of \u201cmissing resources.\u201d<\/li>\n<li>IAM policies that are too restrictive can block visibility without obvious error messages.<\/li>\n<li>Alert fatigue: default thresholds are rarely perfect\u2014tune them to your environment.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Migration challenges<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Moving from Enterprise Manager or custom monitoring to Database Management requires:<\/li>\n<li>Metric\/alert mapping<\/li>\n<li>Runbook and escalation updates<\/li>\n<li>Training and permissions redesign<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Vendor-specific nuances<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle database performance tooling can rely on Oracle-specific concepts (ASH\/AWR\/top SQL). Ensure your team understands these constructs before operationalizing.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">14. Comparison with Alternatives<\/h2>\n\n\n\n<p>Database Management is one option in a broader database observability and management landscape.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Nearest services in Oracle Cloud<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Operations Insights<\/strong> (OCI): capacity planning and forecasting signals (separate service)<\/li>\n<li><strong>Monitoring + Logging<\/strong> (OCI): generic observability primitives<\/li>\n<li><strong>Oracle Enterprise Manager<\/strong> (self-managed): deep Oracle database management platform (often used on-prem or in IaaS)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Nearest services in other clouds<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>AWS:<\/strong> CloudWatch + RDS Performance Insights (for RDS engines)<\/li>\n<li><strong>Azure:<\/strong> Azure Monitor + SQL Insights (for Azure SQL)<\/li>\n<li><strong>Google Cloud:<\/strong> Cloud Monitoring + Cloud SQL Insights<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Open-source\/self-managed alternatives<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Prometheus + Grafana<\/strong> with exporters (requires maintenance and database-specific expertise)<\/li>\n<li><strong>Commercial APM\/monitoring suites<\/strong> (varies by database support and licensing)<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Comparison table<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Option<\/th>\n<th>Best For<\/th>\n<th>Strengths<\/th>\n<th>Weaknesses<\/th>\n<th>When to Choose<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>OCI Database Management<\/strong><\/td>\n<td>Oracle databases needing OCI-native fleet management<\/td>\n<td>Oracle-aware views, OCI IAM\/compartments, integrated alarms\/notifications<\/td>\n<td>Feature variability by target type; Oracle-focused<\/td>\n<td>You want OCI-native operational management for Oracle databases<\/td>\n<\/tr>\n<tr>\n<td><strong>OCI Monitoring + Logging (without DBM)<\/strong><\/td>\n<td>Basic infra\/app telemetry<\/td>\n<td>Flexible, broad coverage<\/td>\n<td>Not database-specialized; you must build DB views yourself<\/td>\n<td>You only need basic metrics\/logs or already have DB tooling<\/td>\n<\/tr>\n<tr>\n<td><strong>OCI Operations Insights<\/strong><\/td>\n<td>Capacity planning\/forecasting<\/td>\n<td>Planning-focused signals and trends<\/td>\n<td>Not a replacement for incident troubleshooting<\/td>\n<td>You need forecasting and utilization planning beyond reactive monitoring<\/td>\n<\/tr>\n<tr>\n<td><strong>Oracle Enterprise Manager (self-managed)<\/strong><\/td>\n<td>Deep Oracle database management across estates<\/td>\n<td>Mature DBA workflows, deep features<\/td>\n<td>Infrastructure overhead, patching, sizing<\/td>\n<td>You require EM-specific features or standardized on EM already<\/td>\n<\/tr>\n<tr>\n<td><strong>AWS RDS Performance Insights<\/strong><\/td>\n<td>Managed AWS RDS databases<\/td>\n<td>Tight AWS integration, SQL performance views<\/td>\n<td>AWS-only, engine-specific<\/td>\n<td>Your estate is mostly on AWS RDS<\/td>\n<\/tr>\n<tr>\n<td><strong>Prometheus + Grafana<\/strong><\/td>\n<td>Toolchain standardization across platforms<\/td>\n<td>Highly customizable; open ecosystem<\/td>\n<td>Operational burden; Oracle-specific depth varies<\/td>\n<td>You want a unified OSS observability stack and can invest in maintenance<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">15. Real-World Example<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Enterprise example: regulated multi-compartment Oracle database fleet<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> A financial institution runs multiple Oracle databases in OCI across prod and non-prod compartments. They need standardized monitoring, alert routing, and audit-friendly access controls.<\/li>\n<li><strong>Proposed architecture:<\/strong><\/li>\n<li>Separate compartments: <code>Prod<\/code>, <code>NonProd<\/code>, <code>Shared-Observability<\/code><\/li>\n<li>Database Management enabled on all prod databases; advanced performance features only on tier-1 systems<\/li>\n<li>Monitoring alarms per database with standardized thresholds and runbook links<\/li>\n<li>Notifications topics integrated with on-call rotation (email\/HTTPS)<\/li>\n<li>IAM policies: read-only for app teams, manage for DBA\/SRE<\/li>\n<li>Audit logs exported to a SIEM<\/li>\n<li><strong>Why Database Management was chosen:<\/strong><\/li>\n<li>OCI-native governance and compartment model<\/li>\n<li>Fleet visibility and database-centric troubleshooting<\/li>\n<li>Easier operational standardization compared to bespoke scripts<\/li>\n<li><strong>Expected outcomes:<\/strong><\/li>\n<li>Reduced MTTR for performance incidents<\/li>\n<li>Measurable compliance posture improvement (access reviews + audit trails)<\/li>\n<li>Cleaner separation of duties across teams<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Startup\/small-team example: single Autonomous Database with lightweight alerting<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Problem:<\/strong> A startup runs one Autonomous Database for a SaaS backend. They need basic operational confidence without building a full monitoring stack.<\/li>\n<li><strong>Proposed architecture:<\/strong><\/li>\n<li>One <code>Prod<\/code> compartment with tagged resources<\/li>\n<li>Database Management enabled for visibility<\/li>\n<li>2\u20133 alarms (CPU, storage, connection anomalies) routed to a shared on-call mailbox or webhook<\/li>\n<li><strong>Why Database Management was chosen:<\/strong><\/li>\n<li>Minimal operational overhead<\/li>\n<li>Fast setup in OCI Console<\/li>\n<li>Database-aware insights without hiring a full DBA team<\/li>\n<li><strong>Expected outcomes:<\/strong><\/li>\n<li>Fewer \u201csurprise\u201d outages from capacity issues<\/li>\n<li>Faster troubleshooting when query latency increases<\/li>\n<li>A scalable path as they add more databases\/environments<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">16. FAQ<\/h2>\n\n\n\n<p>1) <strong>Is Database Management only for Oracle databases?<\/strong><br\/>\nYes. Oracle Cloud Database Management is designed for Oracle Database targets. For non-Oracle engines, use other OCI observability tools or third-party solutions.<\/p>\n\n\n\n<p>2) <strong>Is Database Management part of Observability and Management in Oracle Cloud?<\/strong><br\/>\nYes. In OCI, Database Management is categorized under <strong>Observability and Management<\/strong> and integrates with Monitoring, Alarms, Notifications, Logging, and Audit.<\/p>\n\n\n\n<p>3) <strong>Do I need an agent to use Database Management?<\/strong><br\/>\nIt depends on the database target type. Some OCI database services integrate natively; external targets often use an agent\/connector approach. Verify the current target onboarding model in the official docs.<\/p>\n\n\n\n<p>4) <strong>Can I use Database Management with Autonomous Database?<\/strong><br\/>\nCommonly, yes. Autonomous Database is a typical target for Database Management workflows in OCI. Exact feature availability and cost depend on current options\u2014verify in docs and pricing.<\/p>\n\n\n\n<p>5) <strong>How long does it take for metrics to appear after enabling Database Management?<\/strong><br\/>\nTypically minutes, but it depends on ingestion intervals and the database generating activity. If you see no data after 15\u201330 minutes, re-check IAM and compartment selection.<\/p>\n\n\n\n<p>6) <strong>How do compartments affect Database Management?<\/strong><br\/>\nResources are compartment-scoped. If your managed database is in compartment A but you\u2019re viewing Database Management in compartment B, it can look like the database \u201cdisappeared.\u201d<\/p>\n\n\n\n<p>7) <strong>Can I restrict who can view performance details vs basic health?<\/strong><br\/>\nYes, using IAM policies and group design. Implement roles (observer\/operator\/admin) and grant only the minimum required access per compartment.<\/p>\n\n\n\n<p>8) <strong>Does Database Management replace Oracle Enterprise Manager?<\/strong><br\/>\nNot necessarily. Database Management is cloud-native and integrates with OCI services, while Enterprise Manager is a comprehensive self-managed platform. Many organizations evaluate overlap and may use both.<\/p>\n\n\n\n<p>9) <strong>Can I send Database Management alerts to Slack or an ITSM tool?<\/strong><br\/>\nDatabase Management typically routes alerts through OCI Monitoring Alarms and OCI Notifications. Notifications can deliver to email or HTTPS endpoints, which can integrate with chat\/ITSM via webhooks or middleware.<\/p>\n\n\n\n<p>10) <strong>What are the most common first alarms to configure?<\/strong><br\/>\nCommon starting points are CPU utilization, storage nearing capacity, and abnormal session\/connection patterns\u2014choose what aligns to your incident history and SLOs.<\/p>\n\n\n\n<p>11) <strong>Is there an API to automate onboarding and alert creation?<\/strong><br\/>\nOCI services generally expose APIs for resource management. Validate the Database Management API surface and any CLI\/SDK support in the official references.<\/p>\n\n\n\n<p>12) <strong>Does enabling Database Management change my database performance?<\/strong><br\/>\nTelemetry collection can introduce overhead depending on target type and enabled features. In managed services, Oracle typically optimizes this, but you should validate overhead for your workload and configuration.<\/p>\n\n\n\n<p>13) <strong>How do I keep management traffic private?<\/strong><br\/>\nUse private connectivity patterns when supported (private endpoints, VCN design, NSGs) and restrict outbound egress for agent-based models. Verify the supported private connectivity architecture in official docs.<\/p>\n\n\n\n<p>14) <strong>What\u2019s the best way to roll out Database Management across many databases?<\/strong><br\/>\nUse a phased approach:\n&#8211; Pilot on a small set\n&#8211; Standardize tags\/alarms\n&#8211; Create runbooks and on-call routing\n&#8211; Expand to broader fleets with tiered feature enablement<\/p>\n\n\n\n<p>15) <strong>Where should I look first if I can\u2019t see a database in Database Management?<\/strong><br\/>\nCheck:\n&#8211; Region\n&#8211; Compartment\n&#8211; IAM policies\n&#8211; Whether Database Management is enabled\n&#8211; Telemetry\/ingestion wait time<\/p>\n\n\n\n<p>16) <strong>Can I use Database Management for dev\/test?<\/strong><br\/>\nYes. It\u2019s useful for catching issues early. Keep alerting lightweight and use separate compartments and policies so dev\/test doesn\u2019t impact prod operations.<\/p>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">17. Top Online Resources to Learn Database Management<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Resource Type<\/th>\n<th>Name<\/th>\n<th>Why It Is Useful<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Official documentation<\/td>\n<td>OCI Database Management docs: https:\/\/docs.oracle.com\/en-us\/iaas\/database-management\/home.htm<\/td>\n<td>Primary reference for features, onboarding, and supported targets<\/td>\n<\/tr>\n<tr>\n<td>Official documentation<\/td>\n<td>OCI Monitoring docs: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Monitoring\/home.htm<\/td>\n<td>Learn metrics, alarm creation, and alarm query language concepts<\/td>\n<\/tr>\n<tr>\n<td>Official documentation<\/td>\n<td>OCI Notifications docs: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Notification\/home.htm<\/td>\n<td>Configure alert delivery via email\/HTTPS endpoints<\/td>\n<\/tr>\n<tr>\n<td>Official documentation<\/td>\n<td>OCI IAM docs: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Identity\/home.htm<\/td>\n<td>Policies, compartments, groups, and governance model<\/td>\n<\/tr>\n<tr>\n<td>Official documentation<\/td>\n<td>OCI Audit docs: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Audit\/home.htm<\/td>\n<td>Track administrative actions for compliance and investigations<\/td>\n<\/tr>\n<tr>\n<td>Official pricing<\/td>\n<td>Oracle Cloud Price List: https:\/\/www.oracle.com\/cloud\/price-list\/<\/td>\n<td>Authoritative price list by service\/SKU<\/td>\n<\/tr>\n<tr>\n<td>Pricing tool<\/td>\n<td>OCI Cost Estimator: https:\/\/www.oracle.com\/cloud\/costestimator.html<\/td>\n<td>Build region-specific estimates without guessing<\/td>\n<\/tr>\n<tr>\n<td>Always Free overview<\/td>\n<td>Oracle Cloud Free Tier: https:\/\/www.oracle.com\/cloud\/free\/<\/td>\n<td>Identify free resources for labs and learning<\/td>\n<\/tr>\n<tr>\n<td>Official architecture<\/td>\n<td>OCI Architecture Center: https:\/\/docs.oracle.com\/en\/solutions\/<\/td>\n<td>Reference architectures and design guidance (search for observability\/database operations patterns)<\/td>\n<\/tr>\n<tr>\n<td>Official docs (regional concepts)<\/td>\n<td>OCI Regions: https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/General\/Concepts\/regions.htm<\/td>\n<td>Plan for regional availability and multi-region design<\/td>\n<\/tr>\n<tr>\n<td>Official videos<\/td>\n<td>Oracle Cloud YouTube: https:\/\/www.youtube.com\/@OracleCloudInfrastructure<\/td>\n<td>Product walkthroughs and service deep dives (search \u201cDatabase Management OCI\u201d)<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">18. Training and Certification Providers<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Institute<\/th>\n<th>Suitable Audience<\/th>\n<th>Likely Learning Focus<\/th>\n<th>Mode<\/th>\n<th>Website URL<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>DevOpsSchool.com<\/td>\n<td>DevOps engineers, SREs, platform teams<\/td>\n<td>OCI operations, observability basics, DevOps practices (verify course catalog)<\/td>\n<td>Check website<\/td>\n<td>https:\/\/www.devopsschool.com\/<\/td>\n<\/tr>\n<tr>\n<td>ScmGalaxy.com<\/td>\n<td>Beginners to intermediate IT professionals<\/td>\n<td>DevOps\/SCM fundamentals and operational tooling (verify OCI coverage)<\/td>\n<td>Check website<\/td>\n<td>https:\/\/www.scmgalaxy.com\/<\/td>\n<\/tr>\n<tr>\n<td>CLoudOpsNow.in<\/td>\n<td>Cloud operations practitioners<\/td>\n<td>Cloud operations, monitoring, incident response (verify OCI-specific modules)<\/td>\n<td>Check website<\/td>\n<td>https:\/\/cloudopsnow.in\/<\/td>\n<\/tr>\n<tr>\n<td>SreSchool.com<\/td>\n<td>SREs, reliability engineers<\/td>\n<td>SRE practices, alerting, SLOs, operations (verify OCI content)<\/td>\n<td>Check website<\/td>\n<td>https:\/\/sreschool.com\/<\/td>\n<\/tr>\n<tr>\n<td>AiOpsSchool.com<\/td>\n<td>Ops teams exploring AIOps<\/td>\n<td>AIOps concepts, automation, event correlation (verify OCI integration topics)<\/td>\n<td>Check website<\/td>\n<td>https:\/\/aiopsschool.com\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">19. Top Trainers<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Platform\/Site<\/th>\n<th>Likely Specialization<\/th>\n<th>Suitable Audience<\/th>\n<th>Website URL<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>RajeshKumar.xyz<\/td>\n<td>Cloud\/DevOps training content (verify current offerings)<\/td>\n<td>Beginners to advanced practitioners<\/td>\n<td>https:\/\/rajeshkumar.xyz\/<\/td>\n<\/tr>\n<tr>\n<td>devopstrainer.in<\/td>\n<td>DevOps training and coaching (verify OCI modules)<\/td>\n<td>DevOps engineers, SREs<\/td>\n<td>https:\/\/www.devopstrainer.in\/<\/td>\n<\/tr>\n<tr>\n<td>devopsfreelancer.com<\/td>\n<td>Freelance DevOps guidance and services (verify training availability)<\/td>\n<td>Teams needing practical DevOps help<\/td>\n<td>https:\/\/www.devopsfreelancer.com\/<\/td>\n<\/tr>\n<tr>\n<td>devopssupport.in<\/td>\n<td>DevOps support and training resources (verify scope)<\/td>\n<td>Operations and DevOps teams<\/td>\n<td>https:\/\/www.devopssupport.in\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">20. Top Consulting Companies<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>Company Name<\/th>\n<th>Likely Service Area<\/th>\n<th>Where They May Help<\/th>\n<th>Consulting Use Case Examples<\/th>\n<th>Website URL<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>cotocus.com<\/td>\n<td>Cloud\/DevOps services (verify service catalog)<\/td>\n<td>Implementation, automation, operations enablement<\/td>\n<td>Setting up monitoring\/alerting strategy; compartment\/IAM design review<\/td>\n<td>https:\/\/cotocus.com\/<\/td>\n<\/tr>\n<tr>\n<td>DevOpsSchool.com<\/td>\n<td>DevOps consulting and enablement (verify offerings)<\/td>\n<td>Training + consulting engagements<\/td>\n<td>Observability rollout planning; operational runbook creation<\/td>\n<td>https:\/\/www.devopsschool.com\/<\/td>\n<\/tr>\n<tr>\n<td>DEVOPSCONSULTING.IN<\/td>\n<td>DevOps consulting (verify portfolio)<\/td>\n<td>CI\/CD, operations, monitoring integrations<\/td>\n<td>Alarm routing integration with ITSM; governance and access review<\/td>\n<td>https:\/\/devopsconsulting.in\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">21. Career and Learning Roadmap<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">What to learn before Database Management<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OCI fundamentals:<\/li>\n<li>Compartments, VCNs, IAM policies, regions<\/li>\n<li>Monitoring fundamentals:<\/li>\n<li>Metrics, alarms, notification routing, incident processes<\/li>\n<li>Oracle Database fundamentals:<\/li>\n<li>Sessions, waits, SQL execution basics, indexing concepts<\/li>\n<li>Basic admin concepts (users, privileges, resource usage)<\/li>\n<\/ul>\n\n\n\n<p>Recommended starting point:\n&#8211; OCI Foundations-level learning (Oracle University and OCI docs)\n&#8211; Monitoring + Notifications docs (linked above)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What to learn after Database Management<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Operations Insights<\/strong> (for capacity planning, if relevant)<\/li>\n<li><strong>OCI Logging and Events<\/strong> for automation and centralized operational workflows<\/li>\n<li><strong>OCI Vault<\/strong> for secrets governance<\/li>\n<li><strong>SRE practices<\/strong>: SLOs, error budgets, alert tuning, incident response<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Job roles that use it<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle DBA (cloud-focused)<\/li>\n<li>Site Reliability Engineer (SRE)<\/li>\n<li>Cloud Operations Engineer<\/li>\n<li>Platform Engineer (internal developer platform)<\/li>\n<li>DevOps Engineer (observability owner)<\/li>\n<li>Security Engineer (IAM\/audit reviewer for operations)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Certification path (if available)<\/h3>\n\n\n\n<p>Oracle certifications change over time. A practical path often includes:\n&#8211; OCI Foundations certification (baseline)\n&#8211; OCI Architect Associate\/Professional (for broader design)\n&#8211; Oracle Database certifications (for deeper database expertise)<\/p>\n\n\n\n<p>Verify current OCI certification tracks via Oracle University:\nhttps:\/\/education.oracle.com\/<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Project ideas for practice<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Build a \u201cprod-ready\u201d alarm pack (CPU\/storage\/sessions) with standardized naming and runbook links.<\/li>\n<li>Create compartment-based RBAC:\n   &#8211; Observers can view metrics\n   &#8211; Operators can manage alarms\n   &#8211; Admins can enable\/disable Database Management<\/li>\n<li>Implement tag policies and reporting:\n   &#8211; Enforce required tags\n   &#8211; Build a monthly review of unmanaged databases<\/li>\n<li>Hybrid pilot (if supported):\n   &#8211; Connect one external Oracle database target\n   &#8211; Validate private connectivity and credential rotation procedures<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">22. Glossary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>ADB (Autonomous Database):<\/strong> OCI managed Oracle Database service with automation for patching, tuning, and backups.<\/li>\n<li><strong>Alarm:<\/strong> A Monitoring rule that evaluates a metric against conditions and triggers notifications.<\/li>\n<li><strong>ASH (Active Session History):<\/strong> Oracle performance data model used for analyzing session activity over time (availability depends on target\/features).<\/li>\n<li><strong>Audit (OCI Audit):<\/strong> Service that records API calls for governance and security investigations.<\/li>\n<li><strong>Compartment:<\/strong> OCI logical container for organizing and isolating resources with IAM policies.<\/li>\n<li><strong>Fleet:<\/strong> A collection view of multiple managed databases, usually filtered by compartment and tags.<\/li>\n<li><strong>IAM Policy:<\/strong> Human-readable access control statements defining who can do what in OCI.<\/li>\n<li><strong>Managed database:<\/strong> The Database Management representation of a database target that is onboarded for monitoring\/management.<\/li>\n<li><strong>Metrics:<\/strong> Time-series measurements emitted by services\/resources and used by Monitoring.<\/li>\n<li><strong>NSG (Network Security Group):<\/strong> Virtual firewall rules applied to VNICs\/resources to control traffic.<\/li>\n<li><strong>Notifications (ONS):<\/strong> OCI service to deliver messages to endpoints (email, HTTPS, etc.) from alarms and events.<\/li>\n<li><strong>OCPU:<\/strong> Oracle CPU unit used for OCI compute and some database services.<\/li>\n<li><strong>Private endpoint (context-dependent):<\/strong> A private networking construct used to keep service connectivity within a VCN (verify Database Management private endpoint requirements for your target type).<\/li>\n<li><strong>SQL monitoring \/ Top SQL:<\/strong> Features that help identify and analyze expensive SQL statements.<\/li>\n<li><strong>VCN (Virtual Cloud Network):<\/strong> OCI virtual network for subnets, routing, and security controls.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<h2 class=\"wp-block-heading\">23. Summary<\/h2>\n\n\n\n<p><strong>Oracle Cloud Database Management<\/strong> is an <strong>Observability and Management<\/strong> service that centralizes monitoring and operational management for <strong>Oracle databases<\/strong> in Oracle Cloud (and supported external targets). It matters because database incidents are costly and difficult to troubleshoot without database-aware telemetry and standardized fleet operations.<\/p>\n\n\n\n<p>Architecturally, Database Management fits as the database-focused layer integrated with <strong>OCI IAM<\/strong>, <strong>compartments<\/strong>, <strong>Monitoring\/Alarms<\/strong>, and <strong>Notifications<\/strong>, with optional private connectivity patterns and governance through tags and audit logs.<\/p>\n\n\n\n<p>From a cost perspective, the main drivers are how many databases you enable, what management option\/tier you choose, and whether you enable advanced performance capabilities broadly. Don\u2019t guess pricing\u2014use the official price list and cost estimator:\n&#8211; https:\/\/www.oracle.com\/cloud\/price-list\/<br\/>\n&#8211; https:\/\/www.oracle.com\/cloud\/costestimator.html  <\/p>\n\n\n\n<p>From a security perspective, success depends on least-privilege IAM policies, careful compartment design, private connectivity where needed, and disciplined secrets handling and audit review.<\/p>\n\n\n\n<p>Use Database Management when you want OCI-native, Oracle-aware database observability with standardized alerting and governance. Next, deepen your skills by pairing it with OCI Monitoring\/Logging practices and SRE-style alert tuning\u2014and validate feature support and pricing for your specific database targets in the official docs:\nhttps:\/\/docs.oracle.com\/en-us\/iaas\/database-management\/home.htm<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Observability and Management<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,62],"tags":[],"class_list":["post-954","post","type-post","status-publish","format-standard","hentry","category-observability-and-management","category-oracle-cloud"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts\/954","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/comments?post=954"}],"version-history":[{"count":0,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts\/954\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/media?parent=954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/categories?post=954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/tutorials\/wp-json\/wp\/v2\/tags?post=954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}