2013. 9. 10. 11:51 오라클
Oracle ASM parameter sample
설치후 ASM 초기 parameter
SQL> show parameter
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string
asm_diskstring string
asm_power_limit integer 1
asm_preferred_read_failure_groups string
audit_file_dest string /u01/11.2.0/grid/rdbms/audit
audit_sys_operations boolean FALSE
audit_syslog_level string
background_core_dump string partial
background_dump_dest string /u01/app/oracle/diag/asm/+asm/
+ASM1/trace
cluster_database boolean TRUE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database_instances integer 4
cluster_interconnects string
core_dump_dest string /u01/app/oracle/diag/asm/+asm/
+ASM1/cdump
cpu_count integer 1
db_cache_size big integer 0
db_ultra_safe string OFF
db_unique_name string +ASM
diagnostic_dest string /u01/app/oracle
event string
file_mapping boolean FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string none
ifile file
instance_name string +ASM1
instance_number integer 1
instance_type string asm
large_pool_size big integer 12M
ldap_directory_sysauth string no
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.
168.56.102)(PORT=1521))))
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_name_space string
lock_sga boolean FALSE
max_dump_file_size string unlimited
memory_max_target big integer 272M
memory_target big integer 272M
nls_calendar string
nls_comp string BINARY
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
os_authent_prefix string ops$
os_roles boolean FALSE
parallel_execution_message_size integer 16384
pga_aggregate_target big integer 0
processes integer 120
remote_listener string
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
service_names string +ASM
sessions integer 202
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 272M
sga_target big integer 0
shadow_core_dump string partial
shared_pool_reserved_size big integer 5872025
shared_pool_size big integer 0
sort_area_size integer 65536
spfile string +DATA/rac-cluster/asmparameter
file/registry.253.813896719
sql_trace boolean FALSE
statistics_level string TYPICAL
timed_os_statistics integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
timed_statistics boolean TRUE
trace_enabled boolean TRUE
use_large_pages string TRUE
user_dump_dest string /u01/app/oracle/diag/asm/+asm/
+ASM1/trace
workarea_size_policy string AUTO