Search notes:

Oracle: V$SGA_TARGET_ADVICE

The purpose of v$sga_target_advice is to assist in deciding for a value for the init parameter The init parameter sga_target.

v$sga_target_advice is part of ASSM (Automatic Shared Memory Management).

This view is populated if db_cache_advice is set to on and statistics_level is typical (or all).

select
   sta.sga_size                 sga_size_mb,
   sta.sga_size_factor,
   sta.estd_db_time,
   sta.estd_physical_reads,
   sta.estd_buffer_cache_size,
   sta.estd_shared_pool_size,
   sta.con_id
from
   v$sga_target_advice sta;

TODO

Is the value of total_sga_mb and sga_size_1_mb as returned by the following query always equal?

select
   (select round(sum(value)/1024/1024) from v$sga) total_sga_mb,
   (select sga_size from v$sga_target_advice where sga_size_factor = 1) sga_size_1_mb
from
   dual;

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758205632, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/dynamic-performance-views/sga/target_advice(70): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51

Oracle: V$SGA_TARGET_ADVICE

TODO

See also