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

Posted on 2011-04-27
Last Modified: 2013-12-25
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 find a solution
Question by:John_143
    LVL 23

    Expert Comment


    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:
    LVL 23

    Expert Comment

    - this article explain detail on setting up PAE/AWE:

    LVL 76

    Accepted Solution

    >> 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).

    LVL 2

    Expert Comment

    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....!!!
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    >>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.
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Read about achieving the basic levels of HRIS security in the workplace.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now