question on ASM spfile settings

Posted by satish on Sep 11, 2018; 10:30am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/question-on-ASM-spfile-settings-tp6690.html

Dear Erman,

Our oracle version 12.1.0.2 with 2node RAC

our spfile contents

+ASM2.__large_pool_size=29360128

+ASM1.__large_pool_size=33554432

+ASM1.__oracle_base='/u01/UAT/GRID_BASE'#ORACLE_BASE set from in memory value

+ASM2.__oracle_base='/u01/UAT/GRID_BASE'#ORACLE_BASE set from in memory value

+ASM2.__shared_pool_size=1015021568

+ASM1.__shared_pool_size=1010827264

+ASM1.asm_diskgroups='OCRVOTE1','REDO1ADG','REDO1BDG','FRADG','REDO2ADG','REDO2BDG','DATADG'#Manual Mount

+ASM2.asm_diskgroups='OCRVOTE1','REDO1ADG','REDO1BDG','FRADG','REDO2ADG','REDO2BDG','DATADG'

*.asm_diskstring='ORCL:*'

*.asm_power_limit=1

*.large_pool_size=12M

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=1073741824

[griduat@erpuatdb1 tmp]$

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

memory_max_target                    big integer 1092M

memory_target                        big integer 1092M

sga_max_size                         big integer 1G

sga_target                           big integer 1G


Are the below parameters set by the system or they were set manually?

when memory target is set and sga target is also set,what is the use of setting these parameters?

+ASM2.__large_pool_size=29360128

+ASM1.__large_pool_size=33554432

+ASM2.__shared_pool_size=1015021568

+ASM1.__shared_pool_size=1010827264

Thank you