Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What's the limit for PGA on linux X86 32 bits ?

jmarcJan 22 2008 — edited Jan 23 2008
hi,
We have a server with REDHAT 4 ES (X86 32 bits) and oracle 10.2.0.3 + Olap option .
We want to increase memory on our server to 16 Gb.
Could we set PGA_AGGREGATE_TARGET to 12 Gb ?
Is there a limitation with 32 bits ?
We let SGA to 500 M
I observe that olap use essentially the PGA and for one user connected, there's one process PGA created. So for each process user, the limit is 4 Gb, but the total is not limited . Does i make a bad reasoning ?

help would be very appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2008
Added on Jan 22 2008
#data-warehousing, #olap
9 comments
2,188 views