We would need to know oracle version, Operating system type and version,
and the settings for pga_aggregate_target, sga_max_size, sga_target,
memory_target, pga_max_size, sessions, and processes.
On Wed, Mar 31, 2021 at 2:04 PM Amit Saroha <eramitsaroha@xxxxxxxxx> wrote:
Dear All,
Please help me understanding PGA and SGA.
I was under the impression that PGA and Memory and SGA Memory are
differently allocated. But, in a recent situation, we observed *ORA-7445
[kghalf] *and my DBA is saying - out of a total of 256 GB system memory
one session's PGA consumed everything and only 8 MB was left for other
sessions. But, apart from one process, no other processes were impacted so
I have doubt that - Oracle consumes SGA memory and Allocates it to PGA of a
single process.
Please help me understand.
Best Regards,
Amit