ASM Lesson 5 : ASM Parameters



Last updated on July 17th, 2015 at 06:05 pm

ASM parameters

Some of the important parameter in ASM are

*.asm_diskgroups=’DATA’,’FLASH’
*.asm_diskstring=’/dev/disk*’
*.asm_power_limit=10
*.shared_pool_size=700M
*.db_cache_size=50M
*.large_pool_size=50M
*.processes=100
*.instance_type=’ASM’
 
 


 UnderScore parameter in ASM

select a.ksppinm “Parameter”, c.ksppstvl “Instance Value”
  from x$ksppi a, x$ksppcv b, x$ksppsv c
 where a.indx = b.indx and a.indx = c.indx
   and ksppinm like ‘%


Leave a Reply