Files
db_report/sql/19b_memory_target_advice.sql
Yacine31 4e7683aee2 mise à jour v2
Grosse mise à jour :
- style moderne des tableaux et code
- code structuré et factorisé
- sql et sh affinés
2025-11-19 15:55:11 +01:00

19 lines
264 B
SQL

prompt <h2>SGA Target Advice</h2>
select /* db-html-report */
*
FROM
GV$SGA_TARGET_ADVICE;
prompt <h2>PGA Target Advice</h2>
SELECT
*
FROM
GV$PGA_TARGET_ADVICE;
prompt <h2>Memory Target Advice</h2>
SELECT
*
FROM
GV$MEMORY_TARGET_ADVICE;