OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Number of PGAs (10g r2, XP)

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

Number of PGAs [message #496612]

Tue, 01 March 2011 06:33

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Hi friends,

I am novice to the Oracle Administration. I have just started reading on administration and I have one doubt regarding PGA.

Does Oracle create one separate PGA for each session, or it is for each user?

regards,
Delna

Report message to a moderator

Re: Number of PGAs [message #496621 is a reply to message #496612]

Tue, 01 March 2011 08:30

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

For each process, that is by default, each session.

This is well explained in Database Concepts.

Regards
Michel

Report message to a moderator

Re: Number of PGAs [message #496756 is a reply to message #496621]

Wed, 02 March 2011 05:47

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Thanks Michel sir.

I was referring same link you provided.

regards,
Delna

Report message to a moderator

Previous Topic:	csm$errors
Next Topic:	Schema Splitting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 00:58:50 CST 2025