OraFAQ Forum: Server Administration » PGA memory allocation

Home » RDBMS Server » Server Administration » PGA memory allocation (Oracle 10gR2,RHEL6)

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

PGA memory allocation [message #642910]

Tue, 22 September 2015 21:20

devan0165
Messages: 28
Registered: September 2015
Location: Malaysia

Junior Member

I have configured the below oracle 10gR2 server with total RAM = 16GB as below:-

1) SHMMAX = 13GB
2) SGA = 8GB
3) PGA = 4800M
4) CTX index memory = 2 GB.

From the above settings, I just want to know whether the PGA allocated from operating system RAM or from SHMMAX ?

Is PGA memory allocated from balance OS RAM (3GB) or from SHMMAX (13GB) ?

Please help me to solve this mystery.

Report message to a moderator

[Message index]

		PGA memory allocation By: devan0165 on Tue, 22 September 2015 21:20
		Re: PGA memory allocation By: BlackSwan on Tue, 22 September 2015 21:26
		Re: PGA memory allocation By: devan0165 on Wed, 23 September 2015 01:05
		Re: PGA memory allocation By: Michel Cadot on Wed, 23 September 2015 01:13
		Re: PGA memory allocation By: devan0165 on Wed, 23 September 2015 01:35
		Re: PGA memory allocation By: Michel Cadot on Wed, 23 September 2015 01:40
		Re: PGA memory allocation By: devan0165 on Wed, 23 September 2015 01:53
		Re: PGA memory allocation By: Michel Cadot on Wed, 23 September 2015 01:55
		Re: PGA memory allocation By: devan0165 on Wed, 23 September 2015 01:59
		Re: PGA memory allocation By: devan0165 on Wed, 23 September 2015 02:02

Previous Topic:	Need XMLTYPE & LOB segment explanation
Next Topic:	Error ORA-47306 causing error for Checkpoint

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:13:39 CDT 2024