question on ASM spfile settings

[satish]

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

[ErmanArslansOracleBlog]

Those double underscore parameters are auto adjusted.
You use Automatic memory management in this instance.  So those pools (large pool, shared pool and other stuff) are automatically adjusted. double underscore is a result of that.

[ErmanArslansOracleBlog]

So as you are using automatic memory management, oracle adjust those pool sizes automatically.
As oracle wants to remember their adjusted values after a restart, it records them into the parameter file with double underscore..
During restart (actually startup), oracle sees those adjusted values, and set the default values of these pool sizes accordingly.

This is also an extra info for you.

[satish]

Thanks for the update.It was helpful

I also see SGA_TARGET was set manually,is it really required?

[ErmanArslansOracleBlog]

Please read and understand what memory_target does and what sga_target, sga_max_size paramaters do.
With the release of Oracle 11g, the MEMORY_TARGET parameter defines the total amount of memory that Oracle can use, which incorporates both SGA and PGA areas.

I recommend you to use "only memory_target" or "only sga_target/sga_max_size."

This current conf is not leaving any space to pga. So it is not good.

[satish]

Dear Erman,

Above spfile parameters are for ASM instance

[ErmanArslansOracleBlog]

Who set them? 

12 Eyl 2018 Çar 13:05 tarihinde satish [via Erman Arslan's Oracle Forum] <[hidden email]> şunu yazdı:

Dear Erman,

Above spfile parameters are for ASM instance

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/question-on-ASM-spfile-settings-tp6690p6704.html

To start a new topic under RAC, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML