Search notes:

Oracle: Init parameter MEMORY_TARGET

Setting memory_target lets Oracle manage memory automatically.
The value of memory_target specifies the maximum size of memory used by Oracle for SGA and PGA.
The total amount of memory used can exceed the specified value, for example for memory allocated for PL/SQL tables and varrays. Memory used for such purposes is allocated as long as there is memory available from the operating system.
The value of memory_target controls, together with memory_max_target, the default value of sga_max_size`.
If memory_target is set, sga_max_size should not be set (because that would fix the size of the SGA and conflicts with the intended use of memory_target).

See also

v$memory_target_advice gives a rough estimation on the influence of different values for memory_target on DB time.
init parameters such as memory_max_target or sga_target.
Memory management
ORA-00844: Parameter not taking MEMORY_TARGET into account

Index

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:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758198965, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/init-parameters/memory/target/index(57): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78