• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 741
  • Last Modified:

How do i increase the sessions of oracle in oracle 11g which runs on a windows server 2008 32bit

I have installed windows server 2008 32 bit and on that I installed oracle 11 G. I set the maximum sessions to 450. I would like to increase the sessions how is this possible?.
The OS is windows server 2008
Platform is oracle 11G
RAM is 8 GB
Make of the Server is Fujitsu.
I have another small problem in spite of having 8GB i tried to allocate more space by adding PAE in the boot file but to no avail. Oracle only detects 2 GB and wont increase

please help as i am desperate.........to find a solution
0
John_143
Asked:
John_143
1 Solution
 
OP_ZaharinCommented:

ALTER SYSTEM SET SESSIONS=450 scope=both;

Open in new window


- SESSIONS parameter is derived from value of PROCESSES. you must calculate number of sessions that you going to set. read further here:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams220.htm
http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams188.htm
0
 
OP_ZaharinCommented:
- this article explain detail on setting up PAE/AWE:
http://askdba.org/weblog/2008/05/awe-what-is-it-and-how-can-i-use-it/

0
 
slightwv (䄆 Netminder) Commented:
>> Oracle only detects 2 GB and wont increase

The 'magic' 3gb PAE is one of those 'talked about' features that no one ever actually uses in Production.  I've even asked Oracle directly if they know anyone that has used it, they didn't.

Migrate over to 64-Bit Oracle.  You'll never look back.

I'm running 64Bit 11g on 2008R2 and love it (It's not as good as it was back when I was running on *nix but by far the best/most stable Oracle/Windows yet).


0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
abbas_najafizadehCommented:
windows 32Bit can only set Maximum 2GB to any application like oracle, sql server, etc.

thus if you need to have more memory for your Oracle DBMS, then change your Operating system to a 64bit version.

your have no solution with windows 32bit....!!!
0
 
slightwv (䄆 Netminder) Commented:
>>your have no solution with windows 32bit....!!!

Not entirely true.  Have you read the link posted above?  There is a switch that 'can' allow up to 3GB.  I just don't suggest using it.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now