Monday, January 10, 2022

Performance Analysis

Steps for performance analysis on Oracle Database - Manually using views ( V$/GV$/DBA_)

Oracle Version - 19c 

https://docs.oracle.com/database/121/ADMIN/cdb_mon.htm#ADMIN13719

To Collect information manually by views for Sys-metric related waits from PDB.

  1. DBA_HIST_CON_SYSMETRIC_SUMM
  2. V$CON_SYSMETRIC


No comments:

Post a Comment