Search notes:

Oracle: Init parameter WORKAREA_SIZE_POLICY

The value of workarea_size_policy specifies the memory allocation policy for SQL working areas.
The value of workarea_size_policy can be set to:
auto Lets Oracle allocate memory for the working areas. Oracle considers the value of pga_aggregate_target when workarea_size_policy is set to auto.
manual The size of the working area is based on the *_area_size values (sort_area_size, hash_area_size, bitmap_merge_area_size and create_bitmap_area_size).
The default value is auto (which is set if the value of pga_aggregate_target is nonzero)
The documentation notes that setting workarea_size_policy to manual can lead to «sub-optimal performance and poor PGA memory utilization».

See also

memory management
init parameters

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...', 1788525918, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/init-parameters/workarea_size_policy/index(54): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78