Oracle AWR与ASH性能报告深入解析

-- 以下示例展示了如何查询AWR性能报告中的Load Profile部分
SELECT
    snap_id AS Snapshot_ID,
    db_id AS Database_ID,
    instance_number AS Instance_Number,
    BEGIN_INTERVAL_TIME AS Begin_Interval_Time,
    END_INTERVAL_TIME AS End_Interval_Time,
    round(ELAPSED_TIME / 60, 2) AS Elapsed_Minutes,
    round(CPU_TIME / 100, 2) AS CPU_Hours,
    round(DB_TIME / 100, 2) AS DB_Time_Hours,
    round(LOGICAL_READS + PHYSICAL_READS, 2) AS Total_Reads,
    round(BLOCK_CHANGES, 2) AS Block_Changes
FROM
    dba_hist_snapshot
WHERE
    snap_id IN (
        SELECT DISTINCT snap_id
        FROM dba_hist_active_sess_history
        WHERE sample_time BETWEEN TO_TIMESTAMP('2023-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
        AND TO_TIMESTAMP('2023-01-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
    )
ORDER BY snap_id;

这个示例展示了如何查询AWR性能报告中的Load Profile部分，并提取在特定时间段内的快照信息。这是一个简化的查询，主要用于展示如何结合AWR和ASH数据来获取有关特定时间段内数据库负载情况的详细信息。