Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ALTER SYSTEM SET SGA_TARGET = 0 scope=spfile; not working

755353Jan 26 2011 — edited Jul 23 2013

SQL> ALTER SYSTEM SET SGA_TARGET = 0 scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 2121256960 bytes
Fixed Size 2243280 bytes
Variable Size 1140852016 bytes
Database Buffers 973078528 bytes
Redo Buffers 5083136 bytes
Database mounted.
Database opened.
SQL> show parameters sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 2032M
sga_target big integer 0
SQL> create pfile=#/home/oracle/per03pfile' from spfile;

pfile has
*.sga_max_size=0
*.sga_target=0

and

instance1.__sga_target=2130706432
instance2.__sga_target=2130706432

tried ALTER SYSTEM SET SGA_TARGET = 0 scope=spfile sid='*'; aswell ...

oracle v11.2.0.2
GI 11.2.0.2
linux 64 bit

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2013

Added on Jan 26 2011

#11g, #general-database-discussions

22 comments

41,440 views