Home » RDBMS Server » Server Administration » pga memory allocated
pga memory allocated [message #166301] Wed, 05 April 2006 11:21 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
Is the amount of pga memory allocated to all the users same?
Re: pga memory allocated [message #166373 is a reply to message #166301] Thu, 06 April 2006 01:09 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
No. Proof:

SQL> SELECT spid, username, pga_used_mem, pga_alloc_mem FROM v$process;

SPID         USERNAME        PGA_USED_MEM PGA_ALLOC_MEM
------------ --------------- ------------ -------------
                                        0             0
7004         oracle                214545        366221
7006         oracle                213761        366221
7008         oracle                214961        366221
7010         oracle                278193       1785513
7012         oracle              10770773      22910077
7014         oracle                302061       1657713
7016         oracle                483837       2053129
7018         oracle                484345       1152653
7020         oracle                662345       2070157
7022         oracle               1709397       3118745
7024         oracle                288857        497293
7026         oracle                651117        664177
7028         oracle                205425        205425
5265         oracle                254909       1152653
5251         oracle                315717        842025
7036         oracle                216101        366221
7052         oracle                449241       1218189
7059         oracle                231901        366221

19 rows selected.

Previous Topic: Temporary Tablespace Group
Next Topic: Error when opening ODBCA
Goto Forum:
  


Current Time: Sun Jan 26 14:33:06 CST 2025