Oracle ASM hidden parameters

[oracle@vzwc2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Nov 9 21:43:58 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> col value for a8
SQL> col name for a39
SQL> col describe for a70
SQL> set lines 260 pages 100
SQL> select name,value,describe from v$asm_hidden_paras;

NAME                                    VALUE    DESCRIBE
--------------------------------------- -------- ----------------------------------------------------------------------
_asm_acd_chunks                         1        initial ACD chunks created
_asm_admin_with_sysdba                  FALSE    Does the sysdba role have administrative privileges on ASM?
_asm_allow_appliance_dropdisk_noforce   FALSE    Allow DROP DISK/FAILUREGROUP NOFORCE on ASM Appliances
_asm_allow_lvm_resilvering              TRUE     Enable disk resilvering for external redundancy
_asm_allow_only_raw_disks               TRUE     Discovery only raw devices
_asm_allow_system_alias_rename          FALSE    if system alias renaming is allowed
_asm_appliance_config_file                       Appliance configuration file name
_asm_ausize                             1048576  allocation unit size
_asm_automatic_rezone                   TRUE     automatically rebalance free space across zones
_asm_avoid_pst_scans                    TRUE     Avoid PST Scans
_asm_blksize                            4096     metadata block size
_asm_check_for_misbehaving_cf_clients   FALSE    check for misbehaving CF-holding clients
_asm_compatibility                      10.1     default ASM compatibility level
_asm_dba_batch                          500000   ASM Disk Based Allocation Max Batch Size
_asm_dba_spcchk_thld                    20000    ASM Disk Based Allocation Space Check Threshold
_asm_dba_threshold                      0        ASM Disk Based Allocation Threshold
_asm_dbmsdg_nohdrchk                    FALSE    dbms_diskgroup.checkfile does not check block headers
_asm_diag_dead_clients                  FALSE    diagnostics for dead clients
_asm_direct_con_expire_time             120      Expire time for idle direct connection to ASM instance
_asm_disable_amdu_dump                  FALSE    Disable AMDU dump
_asm_disable_async_msgs                 FALSE    disable async intra-instance messaging
_asm_disable_multiple_instance_check    FALSE    Disable checking for multiple ASM instances on a given node
_asm_disable_profilediscovery           FALSE    disable profile query for discovery
_asm_disable_smr_creation               FALSE    Do Not create smr
_asm_disable_ufg_dump                   FALSE    disable terminated umbilicus diagnostic
_asm_disk_repair_time                   14400    seconds to wait before dropping a failing disk
_asm_emulate_nfs_disk                   FALSE    Emulate NFS disk test event
_asm_emulmax                            10000    max number of concurrent disks to emulate I/O errors
_asm_emultimeout                        0        timeout before emulation begins (in 3s ticks)
_asm_evenread                           2        ASM Even Read level
_asm_evenread_alpha                     0        ASM Even Read Alpha
_asm_evenread_alpha2                    0        ASM Even Read Second Alpha
_asm_evenread_faststart                 0        ASM Even Read Fast Start Threshold
_asm_fail_random_rx                     FALSE    Randomly fail some RX enqueue gets
_asm_fd_cln_idle_sess_twait             10000000 Idle session time wait to run ASM FD cleanup
_asm_fd_cln_on_fg                       TRUE     ASM stale FD cleanup on foregrounds
_asm_fob_tac_frequency                  9        Timeout frequency for FOB cleanup
_asm_force_quiesce                      FALSE    Force diskgroup quiescing
_asm_global_dump_level                  267      System state dump level for ASM asserts
_asm_hbeatiowait                        15       number of secs to wait for PST Async Hbeat IO return
_asm_hbeatwaitquantum                   2        quantum used to compute time-to-wait for a PST Hbeat check
_asm_imbalance_tolerance                3        hundredths of a percentage of inter-disk imbalance to tolerate
_asm_instlock_quota                     0        ASM Instance Lock Quota
_asm_iostat_latch_count                 31       ASM I/O statistics latch count
_asm_kfdpevent                          0        KFDP event
_asm_kfioevent                          0        KFIO event
_asm_kill_unresponsive_clients          TRUE     kill unresponsive ASM clients
_asm_libraries                          ufs      library search order for discovery
_asm_log_scale_rebalance                FALSE    Rebalance power uses logarithmic scale
_asm_lsod_bucket_size                   67       ASM lsod bucket size
_asm_max_cod_strides                    5        maximum number of COD strides
_asm_max_redo_buffer_size               2097152  asm maximum redo buffer size
_asm_maxio                              1048576  Maximum size of individual I/O request
_asm_partner_target_disk_part           8        target maximum number of disk partners for repartnering
_asm_partner_target_fg_rel              4        target maximum number of failure group relationships for repartnering
_asm_primary_load                       1        Number of cycles/extents to load for non-mirrored files
_asm_primary_load_cycles                TRUE     True if primary load is in cycles, false if extent counts
_asm_random_zone                        FALSE    Random zones for new files
_asm_rebalance_plan_size                120      maximum rebalance work unit
_asm_rebalance_space_errors             4        number of out of space errors allowed before aborting rebalance
_asm_repairquantum                      60       quantum (in 3s) used to compute elapsed time for disk drop
_asm_reserve_slaves                     TRUE     reserve ASM slaves for CF txns
_asm_root_directory                     ASM      ASM default root directory
_asm_runtime_capability_volume_support  FALSE    runtime capability for volume support returns supported
_asm_secondary_load                     10000    Number of cycles/extents to load for mirrored files
_asm_secondary_load_cycles              FALSE    True if secondary load is in cycles, false if extent counts
_asm_serialize_volume_rebalance         FALSE    Serialize volume rebalance
_asm_shadow_cycle                       3        Inverse shadow cycle requirement
_asm_skip_rename_check                  FALSE    skip the checking of the clients for s/w compatibility for rename
_asm_skip_resize_check                  FALSE    skip the checking of the clients for s/w compatibility for resize
_asm_storagemaysplit                    FALSE    PST Split Possible
_asm_stripesize                         131072   ASM file stripe size
_asm_stripewidth                        8        ASM file stripe width
_asm_sync_rebalance                     FALSE    Rebalance uses sync I/O
_asm_usd_batch                          64       ASM USD Update Max Batch Size
_asm_wait_time                          18       Max/imum time to wait before asmb exits
_asmlib_test                            0        Osmlib test event
_asmsid                                 asm      ASM instance id

78 rows selected.

SQL Language

select a.ksppinm name, b.ksppstvl value, a.ksppdesc describe
  from x$ksppi a, x$ksppcv b
 where a.inst_id = userenv('Instance')
   and b.inst_id = userenv('Instance')
   and a.indx = b.indx
   and a.ksppinm like '\_asm%' escape '\'
 order by name;