Back to Performance Tuning
sql
Run Memory Kit
oracle_dba_perf_toolkit/incident_kits/run_memory_kit.sql
Disclaimer:
This script is provided for educational and learning purposes. Review it carefully,
test in a non-production environment, confirm privileges, and validate impact before
using it in production.
PROMPT PGA/SGA Memory Troubleshooting Kit
PROMPT Recommended to run in CDB$ROOT.
@../performance_tuning/37_pga_sga_memory_errors_from_alert_log_cdb_root_only.sql
@../performance_tuning/38_pga_usage_and_limit_by_instance.sql
@../performance_tuning/39_sga_pool_usage_by_instance.sql
@../performance_tuning/40_process_memory_top_consumers.sql
@../performance_tuning/31_share_pool_pressure_indicators.sql
@../performance_tuning/32_shared_pool_reserved_diagnostics.sql