In Oracle 18c and up, the space allocated to the MGA (Managed Global Area) is included in total amount of memory allocated to the PGA. This can be see from v$pgastat:Therefore it follows that when upgrading from an earlier version, the maximum allowable PGA size (PGA_AGGREGATE_LIMIT) ...
pga_aggregate_target = 3600M memory_max_target takes the value of memory_target as it is not set explicitly. We hit a situation once when a poorly created SQL stmt made oracle exe use 28g of memory. Running the following query we knew that PGA took 3 times more that was allocated: SQ...
A standard Oracle datafile can have, at most, 4194303 Oracle datablocks. So this also implies that the maximum size is dependant on the Oracle Block size used. DB_BLOCK_SIZE Max Mb value to use in any command ~~~ ~~~ 2048 8191 M 4096 16383 M 8192 32767 M 16384 65535 M starting fr...
pga_aggregate_target = 3600M memory_max_target takes the value of memory_target as it is not set explicitly. We hit a situation once when a poorly created SQL stmt made oracle exe use 28g of memory. Running the following query we knew that PGA took 3 times more that was allocated: SQ...