Strange PGA numbers from statspack

From: Amihay Gonen <AmihayG_at_ectel.com>
Date: Tue, 31 May 2005 18:42:42 +0300
Message-ID: <A18EEF7322197F4A8586D0B013C7B8F60587813A@ectexil1.ectel.com>

Hi.
I have some specific situation that I can't find any acceptable explanation to it.
We have some DB server (oracle 9i) with 24GB ram and 1.7 PGA_aggregate_target defined.
There is some cut from statspack below.

The question how session pga memory max can grow to 140Gb and session pga memory to 6Gb?
If it isnt bug how its possible and what does it mean?  

Statistic Total per Second per Trans
--------------------------------- ------------------ --------------

---

session pga memory 5,833,839,984 270,523.5 21,892.6 session pga memory max 140,591,794,472 6,519,443.3 527,598.4 session uga memory 452,728,840 20,993.7 1,699.0 session uga memory max 25,300,354,184 1,173,213.7 94,944.6  

Amihay Gonen
DBA,
972-3-9268280

Be there ... -> http://golan/Forum%20DBA/default.aspx

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 31 2005 - 11:44:29 CDT