All Products
Search

This Product

    Data Management:Database performance

    Document Center

    Data Management:Database performance

    Last Updated:Mar 30, 2026

    DMS integrates Database Autonomy Service (DAS) to give you real-time visibility into database instance performance—and the tools to act on what you find.

    Prerequisites

    Before you begin, make sure you have the required permissions based on how your database instance is managed:

    • Flexible Management or Stable Change mode: Permission to log on to the database instance

    • Security Collaboration mode: Permission to manage the performance of the database instance

    Available features

    DAS provides four features to monitor and diagnose database performance:

    Feature What it does
    One-click diagnostics Identify performance issues in your database instances. See Diagnostics.
    Real-time performance monitoring View performance metrics for each database instance connected to DAS in real time. See Real-time monitoring.
    Instance session management View active session details—client info, commands, and connection duration—and terminate abnormal sessions. See Session management.
    Storage analysis View storage usage and the number of days for which the remaining storage is available, with per-table breakdowns covering storage usage, tablespace fragments, and diagnostic reports for storage exceptions. See Storage analysis.
    Note For information about which features are available for specific database engines, see Database engines and features supported by DAS.

    Open the DAS console from DMS

    Use one of the following methods to navigate from the DMS console V5.0 to the DAS console.

    Method 1: Search from the DMS home page

    1. In the upper-left corner of the DMS console, enter the instance name, endpoint, or type in the search box.

    2. In the search results, right-click the database whose performance you want to view, move the pointer to Performance, and select the feature you want to open.

    Method 2: Navigate from SQL Console

    1. In the top navigation bar, choose SQL Console > SQL Console.

    2. In the Please select the database first dialog box, search for and select the target database instance, then click Confirm.

    3. In the upper-right corner of the SQL Console page, click the 性能 icon.

    Method 3: Search from Data Assets

    1. In the top navigation bar, click Data Assets. In the left-side navigation pane, click Global Search.

    2. On the Global Search page, enter keywords in the search box. Fuzzy match is supported.

    3. In the search results, find the database instance and click Performance in the Actions column.