OraFAQ Forum: Server Administration » pga allocation done on what basis ??

Home » RDBMS Server » Server Administration » pga allocation done on what basis ??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pga allocation done on what basis ?? [message #184274]

Wed, 26 July 2006 00:19

tridentadm
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 ??

Report message to a moderator

Re: pga allocation done on what basis ?? [message #184400 is a reply to message #184274]

Wed, 26 July 2006 07:40

Frank Naude
Messages: 4596
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%'
/

Report message to a moderator

Re: pga allocation done on what basis ?? [message #536505 is a reply to message #184400]

Wed, 21 December 2011 03:59

suddhasatwa_bhaumik
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 11 01:12:13 CST 2025