Today a little wednesday fun: a quiz.
What do you think will happen in the following situation (leave a response as comment please!):
-Oracle Linux x86_64 6u6.
-Oracle database 220.127.116.11 PSU 4
-Oracle database (single instance) with the following parameter set: memory_target=1G. No other memory related parameters set.
Run the pga_filler script (which can be found here (PGA limiting for Oracle 12)), with grow_until set to 2100000000 (approximately 2.1G).
I’ll try to create a blogpost on the outcome and an explanation on short notice!