Home » RDBMS Server » Server Administration » pga allocation done on what basis ??
pga allocation done on what basis ?? [message #184274] Wed, 26 July 2006 00:19 Go to next message
Messages: 142
Registered: March 2006
Senior Member
how is pga used ???

say 200 users are there but pga allocated is 100m

how will it be distributed to users ??
Re: pga allocation done on what basis ?? [message #184400 is a reply to message #184274] Wed, 26 July 2006 07:40 Go to previous messageGo to next message
Frank Naude
Messages: 4509
Registered: April 1998
Senior Member
A query like this should do it:

SELECT sid, name, value 
  FROM v$sesstat s, v$statname n
 WHERE s.statistic# = n.statistic#
   AND UPPER(name) LIKE '%PGA%'

Re: pga allocation done on what basis ?? [message #536505 is a reply to message #184400] Wed, 21 December 2011 03:59 Go to previous message
Messages: 18
Registered: October 2011
Location: India
Junior Member

Below is a blatant copy of what Tom suggests in his book:

Apress Expert Oracle Database Architecture 9i and 10g Programming Techniques and Solutions Sep 2005
(I am copying it with no sorrows since I cannot explain like he has done in this book!)

[Edit MC: copyrighted material removed]

You can refer to this book as I mention above (with the above information available in Chapter 4), or the other book of Tom: Expert One-to-One Oracle.

[Updated on: Wed, 21 December 2011 04:21] by Moderator

Report message to a moderator

Previous Topic: DBMS_STATS and ORA-20000
Next Topic: Creating/ Running jobs in oracle 9i for solaris
Goto Forum:

Current Time: Sat Jul 22 10:05:26 CDT 2017

Total time taken to generate the page: 0.07592 seconds