Oracle Database Discussions

Dear All,

 I wanna set Oracle SGA /  Maximum SGA size from 950M to 2G but when I increase SGA size more than 1000M than Oracle Database doesn't start and it's showing message "Shared Memory realm.." etc error,

  finally I start Oracle Database on Old Parameters 950M SGA size,

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------************

MAX SGA / SGA

PGA

Session / Process / Transaction

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------************

Server Configuration

 **Database**                    :  10gR2

 **Operating System**     :  Windows Server 2003 Service Pack 2

 **RAM**                            : 06 GB

 **Processor**                   : 2.4G (8 Core)

 Same problem facing while increasing **Session/ Process/ Transaction** limit and **PGA** memory. (_see the above attached image_)

 **Tablespace** "USERS" size is **5 GB**. _(check the below attached image_)

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------************

 ![pastedImage_19.png](https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/jive_attachments/5/7/6/57689354egami.png)