- 04 Sep, 2023
- 0 Comments
- 41 Secs Read
SGA TARGET ADVISORY IN ORACLE
SGA TARGET ADVISORY IN ORACLE
The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for SGA_TARGET.
MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET_ADVICE view.
Check SGA Target Advisory is enable?
1 2 3 4 5 6 | a. DB_CACHE_ADVICE should be ONSQL> show parameter db_cache_adviceSTATISTICS_LEVEL should be TYPICAL/ALL.SQL> show parameter statistics_level |
SGA ADVISORY REPORT:
1 | SQL> select * from v$sga_target_advice order by sga_size; |