Back to Performance Tuning
sql
Run Share Pool Kit
oracle_dba_perf_toolkit/incident_kits/run_share_pool_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 Share Pool Troubleshooting Kit
PROMPT Recommended to run in CDB$ROOT.
@../performance_tuning/30_share_pool_errors_from_alert_log_cdb_root_only.sql
@../performance_tuning/31_share_pool_pressure_indicators.sql
@../performance_tuning/32_shared_pool_reserved_diagnostics.sql
@../performance_tuning/33_share_pool_top_sql_hard_parse_pressure.sql