All _ show parameters
SYS AS SYSDBA@ORCL > SHOW PARAMETER
NAME TYPE VALUE
-
O7_DICTIONARY_ACCESSIBILITY boolean FALSE
Active_instance_count integer
Aq_tm_processes integer 0
Archive_lag_target integer 0
Asm_diskgroups string
Asm_diskstring string
Asm_power_limit integer 1
Asm_preferred_read_failure_groups string
Audit_file_dest string / u01/app/oracle/admin/ORCL/adu
Mp
Audit_sys_operations boolean FALSE
Audit_syslog_level string
Audit_trail string DB
Background_core_dump string partial
Background_dump_dest string / u01/app/oracle/diag/rdbms/orc
L/ORCL/trace
Backup_tape_io_slaves boolean FALSE
Bitmap_merge_area_size integer 1048576
Blank_trimming boolean FALSE
Buffer_pool_keep string
Buffer_pool_recycle string
Cell_offload_compaction string ADAPTIVE
Cell_offload_decryption boolean TRUE
Cell_offload_parameters string
Cell_offload_plan_display string AUTO
Cell_offload_processing boolean TRUE
Cell_partition_large_extents string DEFAULT
Circuits integer
Client_result_cache_lag big integer 3000
Client_result_cache_size big integer 0
Cluster_database boolean FALSE
Cluster_database_instances integer 1
Cluster_interconnects string
Commit_logging string
Commit_point_strength integer 1
Commit_wait string
Commit_write string
Compatible string 11.2.0.0.0
Control_file_record_keep_time integer 7
Control_files string / u01/app/oracle/oradata/ORCL/c
Ontrol01.ctl, / u01/app/oracle/
Flash_recovery_area/ORCL/contr
Ol02.ctl
Control_management_pack_access string DIAGNOSTIC+TUNING
Core_dump_dest string / u01/app/oracle/diag/rdbms/orc
L/ORCL/cdump
Cpu_count integer 2
Create_bitmap_area_size integer 8388608
Create_stored_outlines string
Cursor_sharing string EXACT
Cursor_space_for_time boolean FALSE
Db_16k_cache_size big integer 0
Db_2k_cache_size big integer 0
Db_32k_cache_size big integer 0
Db_4k_cache_size big integer 0
Db_8k_cache_size big integer 0
Db_block_buffers integer 0
Db_block_checking string FALSE
Db_block_checksum string TYPICAL
Db_block_size integer 8192
Db_cache_advice string ON
Db_cache_size big integer 0
Db_create_file_dest string
Db_create_online_log_dest_1 string
Db_create_online_log_dest_2 string
Db_create_online_log_dest_3 string
Db_create_online_log_dest_4 string
Db_create_online_log_dest_5 string
Db_domain string
Db_file_multiblock_read_count integer 30
Db_file_name_convert string
Db_files integer 200
Db_flash_cache_file string
Db_flash_cache_size big integer 0
Db_flashback_retention_target integer 1440
Db_keep_cache_size big integer 0
Db_lost_write_protect string NONE
Db_name string ORCL
Db_recovery_file_dest string / u01/app/oracle/flash_recovery
_ area
Db_recovery_file_dest_size big integer 10G
Db_recycle_cache_size big integer 0
Db_securefile string PERMITTED
Db_ultra_safe string OFF
Db_unique_name string ORCL
Db_writer_processes integer 1
Dbwr_io_slaves integer 0
Ddl_lock_timeout integer 0
Deferred_segment_creation boolean TRUE
Dg_broker_config_file1 string / u01/app/oracle/product/11.2.2
/ db_1/dbs/dr1ORCL.dat
Dg_broker_config_file2 string / u01/app/oracle/product/11.2.2
/ db_1/dbs/dr2ORCL.dat
Dg_broker_start boolean FALSE
Diagnostic_dest string / u01/app/oracle
Disk_asynch_io boolean TRUE
Dispatchers string (PROTOCOL=TCP) (SERVICE=ORCLXD
b)
Distributed_lock_timeout integer 60
Dml_locks integer 1088
Dst_upgrade_insert_conv boolean TRUE
Enable_ddl_logging boolean FALSE
Event string
Fal_client string
Fal_server string
Fast_start_io_target integer 0
Fast_start_mttr_target integer 0
Fast_start_parallel_rollback string LOW
File_mapping boolean FALSE
Fileio_network_adapters string
Filesystemio_options string none
Fixed_date string
Gcs_server_processes integer 0
Global_context_pool_size string
Global_names boolean FALSE
Global_txn_processes integer 1
Hash_area_size integer 131072
Hi_shared_memory_address integer 0
Hs_autoregister boolean TRUE
Ifile file
Instance_groups string
Instance_name string ORCL
Instance_number integer 0
Instance_type string RDBMS
Java_jit_enabled boolean TRUE
Java_max_sessionspace_size integer 0
Java_pool_size big integer 0
Java_soft_sessionspace_limit integer 0
Job_queue_processes integer 1000
Large_pool_size big integer 0
Ldap_directory_access string NONE
Ldap_directory_sysauth string no
License_max_sessions integer 0
License_max_users integer 0
License_sessions_warning integer 0
Listener_networks string
Local_listener string
Lock_name_space string
Lock_sga boolean FALSE
Log_archive_config string
Log_archive_dest string
Log_archive_dest_1 string
Log_archive_dest_10 string
Log_archive_dest_11 string
Log_archive_dest_12 string
Log_archive_dest_13 string
Log_archive_dest_14 string
Log_archive_dest_15 string
Log_archive_dest_16 string
Log_archive_dest_17 string
Log_archive_dest_18 string
Log_archive_dest_19 string
Log_archive_dest_2 string
Log_archive_dest_20 string
Log_archive_dest_21 string
Log_archive_dest_22 string
Log_archive_dest_23 string
Log_archive_dest_24 string
Log_archive_dest_25 string
Log_archive_dest_26 string
Log_archive_dest_27 string
Log_archive_dest_28 string
Log_archive_dest_29 string
Log_archive_dest_3 string
Log_archive_dest_30 string
Log_archive_dest_31 string
Log_archive_dest_4 string
Log_archive_dest_5 string
Log_archive_dest_6 string
Log_archive_dest_7 string
Log_archive_dest_8 string
Log_archive_dest_9 string
Log_archive_dest_state_1 string enable
Log_archive_dest_state_10 string enable
Log_archive_dest_state_11 string enable
Log_archive_dest_state_12 string enable
Log_archive_dest_state_13 string enable
Log_archive_dest_state_14 string enable
Log_archive_dest_state_15 string enable
Log_archive_dest_state_16 string enable
Log_archive_dest_state_17 string enable
Log_archive_dest_state_18 string enable
Log_archive_dest_state_19 string enable
Log_archive_dest_state_2 string enable
Log_archive_dest_state_20 string enable
Log_archive_dest_state_21 string enable
Log_archive_dest_state_22 string enable
Log_archive_dest_state_23 string enable
Log_archive_dest_state_24 string enable
Log_archive_dest_state_25 string enable
Log_archive_dest_state_26 string enable
Log_archive_dest_state_27 string enable
Log_archive_dest_state_28 string enable
Log_archive_dest_state_29 string enable
Log_archive_dest_state_3 string enable
Log_archive_dest_state_30 string enable
Log_archive_dest_state_31 string enable
Log_archive_dest_state_4 string enable
Log_archive_dest_state_5 string enable
Log_archive_dest_state_6 string enable
Log_archive_dest_state_7 string enable
Log_archive_dest_state_8 string enable
Log_archive_dest_state_9 string enable
Log_archive_duplex_dest string
Log_archive_format string t_%s_%r.dbf
Log_archive_local_first boolean TRUE
Log_archive_max_processes integer 4
Log_archive_min_succeed_dest integer 1
Log_archive_start boolean FALSE
Log_archive_trace integer 0
Log_buffer integer 5898240
Log_checkpoint_interval integer 0
Log_checkpoint_timeout integer 1800
Log_checkpoints_to_alert boolean FALSE
Log_file_name_convert string
Max_dispatchers integer
Max_dump_file_size string unlimited
Max_enabled_roles integer 150
Max_shared_servers integer
Memory_max_target big integer 404M
Memory_target big integer 404M
Nls_calendar string
Nls_comp string BINARY
Nls_currency string
Nls_date_format string
Nls_date_language string
Nls_dual_currency string
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
Object_cache_max_size_percent integer 10
Object_cache_optimal_size integer 102400
Olap_page_pool_size big integer 0
Open_cursors integer 300
Open_links integer 4
Open_links_per_instance integer 4
Optimizer_capture_sql_plan_baselines boolean FALSE
Optimizer_dynamic_sampling integer 2
Optimizer_features_enable string 11.2.0.1
Optimizer_index_caching integer 0
Optimizer_index_cost_adj integer 100
Optimizer_mode string ALL_ROWS
Optimizer_secure_view_merging boolean TRUE
Optimizer_use_invisible_indexes boolean FALSE
Optimizer_use_pending_statistics boolean FALSE
Optimizer_use_sql_plan_baselines boolean TRUE
Os_authent_prefix string ops$
Os_roles boolean FALSE
Parallel_adaptive_multi_user boolean TRUE
Parallel_automatic_tuning boolean FALSE
Parallel_degree_limit string CPU
Parallel_degree_policy string MANUAL
Parallel_execution_message_size integer 16384
Parallel_force_local boolean FALSE
Parallel_instance_group string
Parallel_io_cap_enabled boolean FALSE
Parallel_max_servers integer 20
Parallel_min_percent integer 0
Parallel_min_servers integer 0
Parallel_min_time_threshold string AUTO
Parallel_server boolean FALSE
Parallel_server_instances integer 1
Parallel_servers_target integer 8
Parallel_threads_per_cpu integer 2
Permit_92_wrap_format boolean TRUE
Pga_aggregate_target big integer 0
Plscope_settings string IDENTIFIERS:NONE
Plsql_ccflags string
Plsql_code_type string INTERPRETED
Plsql_debug boolean FALSE
Plsql_optimize_level integer 2
Plsql_v2_compatibility boolean FALSE
Plsql_warnings string DISABLE:ALL
Pre_page_sga boolean FALSE
Processes integer 150
Query_rewrite_enabled string TRUE
Query_rewrite_integrity string enforced
Rdbms_server_dn string
Read_only_open_delayed boolean FALSE
Recovery_parallelism integer 0
Recyclebin string on
Redo_transport_user string
Remote_dependencies_mode string TIMESTAMP
Remote_listener string
Remote_login_passwordfile string EXCLUSIVE
Remote_os_authent boolean FALSE
Remote_os_roles boolean FALSE
Replication_dependency_tracking boolean TRUE
Resource_limit boolean FALSE
Resource_manager_cpu_allocation integer 2
Resource_manager_plan string
Result_cache_max_result integer 5
Result_cache_max_size big integer 1056K
Result_cache_mode string MANUAL
Result_cache_remote_expiration integer 0
Resumable_timeout integer 0
Rollback_segments string
Sec_case_sensitive_logon boolean TRUE
Sec_max_failed_login_attempts integer 10
Sec_protocol_error_further_action string CONTINUE
Sec_protocol_error_trace_action string TRACE
Sec_return_server_release_banner boolean FALSE
Serial_reuse string disable
Service_names string ORCL
Session_cached_cursors integer 50
Session_max_open_files integer 10
Sessions integer 248
Sga_max_size big integer 404M
Sga_target big integer 0
Shadow_core_dump string partial
Shared_memory_address integer 0
Shared_pool_reserved_size big integer 9227468
Shared_pool_size big integer 0
Shared_server_sessions integer
Shared_servers integer 1
Skip_unusable_indexes boolean TRUE
Smtp_out_server string
Sort_area_retained_size integer 0
Sort_area_size integer 65536
Spfile string / u01/app/oracle/product/11.2.2
/ db_1/dbs/spfileORCL.ora
Sql92_security boolean FALSE
Sql_trace boolean FALSE
Sqltune_category string DEFAULT
Standby_archive_dest string? / dbs/arch
Standby_file_management string MANUAL
Star_transformation_enabled string FALSE
Statistics_level string TYPICAL
Streams_pool_size big integer 0
Tape_asynch_io boolean TRUE
Thread integer 0
Timed_os_statistics integer 0
Timed_statistics boolean TRUE
Trace_enabled boolean TRUE
Tracefile_identifier string
Transactions integer 272
Transactions_per_rollback_segment integer 5
Undo_management string AUTO
Undo_retention integer 900
Undo_tablespace string UNDOTBS1
Use_indirect_data_buffers boolean FALSE
User_dump_dest string / u01/app/oracle/diag/rdbms/orc
L/ORCL/trace
Utl_file_dir string
Workarea_size_policy string AUTO
Xml_db_events string enable
