NAME TYPE VALUE------------------------------------ ----------- ------------------------------active_instance_count integeraq_tm_processes integer 1archive_lag_target integer 0asm_diskgroups stringasm_diskstring stringasm_power_limit integer 1asm_preferred_read_failure_groups stringaudit_file_dest string /u01/app/oracle/admin/bi01/adu mpaudit_syslog_level stringaudit_sys_operations boolean TRUEaudit_trail string DB_EXTENDEDawr_snapshot_time_offset integer 0background_core_dump string partialbackground_dump_dest string /u01/app/oracle/diag/rdbms/bi0 1/bi011/tracebackup_tape_io_slaves boolean FALSEbitmap_merge_area_size integer 1048576blank_trimming boolean FALSEbuffer_pool_keep stringbuffer_pool_recycle stringcell_offload_compaction string ADAPTIVEcell_offload_decryption boolean TRUEcell_offloadgroup_name stringcell_offload_parameters stringcell_offload_plan_display string AUTOcell_offload_processing boolean TRUEcircuits integerclient_result_cache_lag big integer 3000client_result_cache_size big integer 0clonedb boolean FALSEcluster_database boolean TRUEcluster_database_instances integer 2cluster_interconnects stringcommit_logging stringcommit_point_strength integer 1commit_wait stringcommit_write stringcompatible string 11.2.0.4.0control_file_record_keep_time integer 7control_files string +DATA/bi01/controlfile/current .289.780499659, +RECO/bi01/con trolfile/current.284.780499659control_management_pack_access string DIAGNOSTIC+TUNINGcore_dump_dest string /u01/app/oracle/diag/rdbms/bi0 1/bi011/cdumpcpu_count integer 24create_bitmap_area_size integer 8388608create_stored_outlines stringcursor_bind_capture_destination string memory+diskcursor_sharing string EXACTcursor_space_for_time boolean FALSEdb_block_buffers integer 0db_block_checking string OFFdb_block_checksum string typicaldb_block_size integer 8192db_cache_advice string ONdb_cache_size big integer 0db_create_file_dest string +DATAdb_create_online_log_dest_1 stringdb_create_online_log_dest_2 stringdb_create_online_log_dest_3 stringdb_create_online_log_dest_4 stringdb_create_online_log_dest_5 stringdb_domain stringdb_file_multiblock_read_count integer 128db_file_name_convert stringdb_files integer 2000db_flashback_retention_target integer 1440db_flash_cache_file stringdb_flash_cache_size big integer 0db_keep_cache_size big integer 0db_lost_write_protect string typicaldb_name string bi01db_recovery_file_dest string +RECOdb_recovery_file_dest_size big integer 5000000Mdb_recycle_cache_size big integer 0db_securefile string PERMITTEDdb_ultra_safe string OFFdb_unique_name string bi01db_unrecoverable_scn_tracking boolean TRUEdbwr_io_slaves integer 0db_writer_processes integer 8db_16k_cache_size big integer 0db_2k_cache_size big integer 0db_32k_cache_size big integer 256Mdb_4k_cache_size big integer 0db_8k_cache_size big integer 0ddl_lock_timeout integer 0deferred_segment_creation boolean TRUEdg_broker_config_file1 string /u01/app/oracle/product/11.2.0 .4/dbprod/dbs/dr1bi01.datdg_broker_config_file2 string /u01/app/oracle/product/11.2.0 .4/dbprod/dbs/dr2bi01.datdg_broker_start boolean FALSEdiagnostic_dest string /u01/app/oracledisk_asynch_io boolean TRUEdispatchers stringdistributed_lock_timeout integer 60dml_locks integer 6864dnfs_batch_size integer 4096dst_upgrade_insert_conv boolean TRUEenable_ddl_logging boolean FALSEenable_goldengate_replication boolean FALSEevent stringfal_client stringfal_server stringfast_start_io_target integer 0fast_start_mttr_target integer 0fast_start_parallel_rollback string LOWfileio_network_adapters stringfile_mapping boolean FALSE_file_size_increase_increment big integer 2044Mfilesystemio_options string nonefixed_date stringgcs_server_processes integer 2global_context_pool_size stringglobal_names boolean FALSEglobal_txn_processes integer 1hash_area_size integer 131072hi_shared_memory_address integer 0hs_autoregister boolean TRUEifile fileinstance_groups stringinstance_name string bi011instance_number integer 1instance_type string RDBMSinstant_restore boolean FALSEjava_jit_enabled boolean TRUEjava_max_sessionspace_size integer 0java_pool_size big integer 0java_restrict string nonejava_soft_sessionspace_limit integer 0job_queue_processes integer 1000_kill_diagnostics_timeout integer 140large_pool_size big integer 3Gldap_directory_access string NONEldap_directory_sysauth string nolicense_max_sessions integer 0license_max_users integer 0license_sessions_warning integer 0listener_networks string_lm_rcvr_hang_allow_time integer 140local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=TCP)(HOST=10.1 13.64.136)(PORT=1523))))lock_name_space stringlock_sga boolean FALSElog_archive_config stringlog_archive_dest stringlog_archive_dest_state_1 string enablelog_archive_dest_state_10 string enablelog_archive_dest_state_11 string enablelog_archive_dest_state_12 string enablelog_archive_dest_state_13 string enablelog_archive_dest_state_14 string enablelog_archive_dest_state_15 string enablelog_archive_dest_state_16 string enablelog_archive_dest_state_17 string enablelog_archive_dest_state_18 string enablelog_archive_dest_state_19 string enablelog_archive_dest_state_2 string enablelog_archive_dest_state_20 string enablelog_archive_dest_state_21 string enablelog_archive_dest_state_22 string enablelog_archive_dest_state_23 string enablelog_archive_dest_state_24 string enablelog_archive_dest_state_25 string enablelog_archive_dest_state_26 string enablelog_archive_dest_state_27 string enablelog_archive_dest_state_28 string enablelog_archive_dest_state_29 string enablelog_archive_dest_state_3 string enablelog_archive_dest_state_30 string enablelog_archive_dest_state_31 string enablelog_archive_dest_state_4 string enablelog_archive_dest_state_5 string enablelog_archive_dest_state_6 string enablelog_archive_dest_state_7 string enablelog_archive_dest_state_8 string enablelog_archive_dest_state_9 string enablelog_archive_dest_1 stringlog_archive_dest_10 stringlog_archive_dest_11 stringlog_archive_dest_12 stringlog_archive_dest_13 stringlog_archive_dest_14 stringlog_archive_dest_15 stringlog_archive_dest_16 stringlog_archive_dest_17 stringlog_archive_dest_18 stringlog_archive_dest_19 stringlog_archive_dest_2 stringlog_archive_dest_20 stringlog_archive_dest_21 stringlog_archive_dest_22 stringlog_archive_dest_23 stringlog_archive_dest_24 stringlog_archive_dest_25 stringlog_archive_dest_26 stringlog_archive_dest_27 stringlog_archive_dest_28 stringlog_archive_dest_29 stringlog_archive_dest_3 stringlog_archive_dest_30 stringlog_archive_dest_31 stringlog_archive_dest_4 stringlog_archive_dest_5 stringlog_archive_dest_6 stringlog_archive_dest_7 stringlog_archive_dest_8 stringlog_archive_dest_9 stringlog_archive_duplex_dest stringlog_archive_format string %t_%s_%r.dbflog_archive_local_first boolean TRUElog_archive_max_processes integer 4log_archive_min_succeed_dest integer 1log_archive_start boolean FALSElog_archive_trace integer 0log_buffer integer 134217728log_checkpoint_interval integer 0log_checkpoints_to_alert boolean FALSElog_checkpoint_timeout integer 1800log_file_name_convert stringmax_dispatchers integermax_dump_file_size string unlimitedmax_enabled_roles integer 150max_shared_servers integermemory_max_target big integer 0memory_target big integer 0nls_calendar string GREGORIANnls_comp string BINARYnls_currency string R$nls_date_format string dd/mm/yyyy hh24:mi:ssnls_date_language string BRAZILIAN PORTUGUESEnls_dual_currency string Cr$nls_iso_currency string BRAZILnls_language string BRAZILIAN PORTUGUESEnls_length_semantics string BYTEnls_nchar_conv_excp string FALSEnls_numeric_characters string ,.nls_sort string WEST_EUROPEANnls_territory string BRAZILnls_time_format string HH24:MI:SSXFFnls_timestamp_format string DD/MM/RR HH24:MI:SSXFFnls_timestamp_tz_format string DD/MM/RR HH24:MI:SSXFF TZRnls_time_tz_format string HH24:MI:SSXFF TZRobject_cache_max_size_percent integer 10object_cache_optimal_size integer 102400olap_page_pool_size big integer 0open_cursors integer 1000open_links integer 4open_links_per_instance integer 4optimizer_capture_sql_plan_baselines boolean FALSEoptimizer_dynamic_sampling integer 2optimizer_features_enable string 11.2.0.4optimizer_index_caching integer 0optimizer_index_cost_adj integer 100optimizer_mode string ALL_ROWSoptimizer_secure_view_merging boolean TRUEoptimizer_use_invisible_indexes boolean FALSEoptimizer_use_pending_statistics boolean FALSEoptimizer_use_sql_plan_baselines boolean TRUEos_authent_prefix string BI01$os_roles boolean FALSEO7_DICTIONARY_ACCESSIBILITY boolean FALSEparallel_adaptive_multi_user boolean FALSEparallel_automatic_tuning boolean FALSEparallel_degree_limit string CPUparallel_degree_policy string MANUALparallel_execution_message_size integer 16384parallel_force_local boolean FALSEparallel_instance_group stringparallel_io_cap_enabled boolean FALSEparallel_max_servers integer 256parallel_min_percent integer 0parallel_min_servers integer 64parallel_min_time_threshold string AUTOparallel_server boolean TRUEparallel_server_instances integer 2parallel_servers_target integer 256parallel_threads_per_cpu