Does Oracle PGA take out memory out of SGA?
From: Amit Saroha <eramitsaroha_at_gmail.com>
Date: Wed, 31 Mar 2021 15:03:31 -0400
Message-ID: <CAG67e6RWyCJJgKn7Ab=fpLqdcXbAOMYxd8qvsUiHbudptQ6sTg_at_mail.gmail.com>
Dear All,
Date: Wed, 31 Mar 2021 15:03:31 -0400
Message-ID: <CAG67e6RWyCJJgKn7Ab=fpLqdcXbAOMYxd8qvsUiHbudptQ6sTg_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 31 2021 - 21:03:31 CEST