Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.