Home » Infrastructure » Unix » OS Solaris Parameter That May Affect the SGA (Oracle 10g, Solaris 10)
OS Solaris Parameter That May Affect the SGA [message #576427] |
Mon, 04 February 2013 19:41  |
 |
rielph
Messages: 2 Registered: February 2013 Location: Philippines
|
Junior Member |
|
|
Please help I can't reduced the SGA target to less than 850M, the server (UAT) is a replicate of the production the only difference is it's part of a zone now, in prod I can reduced the SGA to 200M, but now it's not possible an error message prompt please help what kernel or OS parameter, or Oracle parameter I need to set in the zone so I can reduced the SGA target. Below are the logs. Thank you
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 1536M
sga_target big integer 1536M
SQL> create pfile='init_elams_20130204.ora' from spfile;
SQL> startup pfile=init_elams_20130204.ora
ORACLE instance started.
Total System Global Area 893386752 bytes
Fixed Size 2141952 bytes
Variable Size 199184640 bytes
Database Buffers 553648128 bytes
Redo Buffers 138412032 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[dev-dbs]:elams>/appl1/home/oracle/10.2/dbs>> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 4 16:59:33 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[dev-dbs]:elams>/appl1/home/oracle/10.2/dbs>> vi init_elams_20130204.ora
"init_elams_20130204.ora" 19 lines, 753 characters
*.audit_file_dest='/appl1/home/oracle/admin/elams/adump'
*.background_dump_dest='/appl1/home/oracle/admin/elams/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/u101/oradata/elams/control/control_01.ctl','/u301/oradata/elams/control/control_02.ctl','/u501/oradata/elams/contro l/control_03.ctl'
*.core_dump_dest='/appl1/home/oracle/admin/elams/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='elams'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=elamsXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=1048576000
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=750M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/appl1/home/oracle/admin/elams/udump'
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"init_elams_20130204.ora" 19 lines, 753 characters
[dev-dbs]:elams>/appl1/home/oracle/10.2/dbs>> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 4 17:00:09 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup pfile=init_elams_20130204.ora
ORA-12853: insufficient memory for PX buffers: current 0K, max needed 27738K
ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
SQL> exit
Disconnected
[dev-dbs]:elams>/appl1/home/oracle/10.2/dbs>> vi init_elams_20130204.ora
"init_elams_20130204.ora" 19 lines, 753 characters
*.audit_file_dest='/appl1/home/oracle/admin/elams/adump'
*.background_dump_dest='/appl1/home/oracle/admin/elams/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/u101/oradata/elams/control/control_01.ctl','/u301/oradata/elams/control/control_02.ctl','/u501/oradata/elams/contro l/control_03.ctl'
*.core_dump_dest='/appl1/home/oracle/admin/elams/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='elams'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=elamsXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=1048576000
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=850M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/appl1/home/oracle/admin/elams/udump'
|
|
|
|
|
Goto Forum:
Current Time: Fri May 02 01:21:24 CDT 2025
|