| 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'
|
|
|
|
|
|
| Re: OS Solaris Parameter That May Affect the SGA [message #576640 is a reply to message #576428] |
Wed, 06 February 2013 20:44  |
|
rielph
Messages: 2
Registered: February 2013
Location: Philippines
|
Junior Member |
|
|
Hi BlackSwan,
Thank you for reply, below are the snapshot of the kernel parameter of the production & the development servers. They differ on project.max-shm-memory but this is okay cause less memory is allotted for development but significantly they differs on project.max-device-locked-memory and project.max-crypto-memory, do you this reducing the project.max-device-locked-memory and project.max-crypto-memory is the key to reduce the SGA to 200MB?
Production:
>> ps -o taskid -p $$
TASKID
19029
>> prctl -i task 19029
task: 19029
project.max-device-locked-memory
privileged 1.95GB - deny
system 16.0EB max deny
project.max-crypto-memory
privileged 7.79GB - deny
system 16.0EB max deny
project.max-shm-memory
privileged 24.0GB - deny
system 16.0EB max deny
Development:
>> ps -o taskid -p $$
TASKID
1706
>> prctl -i task 1706
task: 1706
project.max-device-locked-memory
privileged 7.81GB - deny
system 16.0EB max deny
project.max-crypto-memory
privileged 31.3GB - deny
system 16.0EB max deny
project.max-shm-memory
privileged 10.0GB - deny
system 16.0EB max deny
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
