Strange PGA numbers from statspack
- From: Amihay Gonen <AmihayG@xxxxxxxxx>
- To: "Oracle-L (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 May 2005 18:42:42 +0300
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
