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