Re: Does Oracle PGA take out memory out of SGA?

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_at_gmail.com> 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
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l