<!-- Oracle Remote Diagnostic Agent / Data Collection Results 4.23 -->
<!-- Module:S201DBA Version:2.12 Report:vparameters OS:linux -->
---+!! Database Parameters
%TOC%
---+ Nondefault Parameters
|*Parameter Name*|*Value*|*Modified*|
|audit_file_dest|/pcard18/admin/pcard/adump|FALSE|
|background_dump_dest|/pcard18/admin/pcard/bdump|FALSE|
|compatible|10.2.0.1.0|FALSE|
|control_files|/pcard02/oradata/pcard/control01.ctl, /pcard03/oradata/pcard/control02.ctl, /pcard04/oradata/pcard/control03.ctl|FALSE|
|core_dump_dest|/pcard18/admin/pcard/cdump|FALSE|
|db_block_size|8192|FALSE|
|db_domain|%NULL%|FALSE|
|db_file_multiblock_read_count|16|FALSE|
|db_name|pcard|FALSE|
|dispatchers|(PROTOCOL=TCP) (SERVICE=pcard)|FALSE|
|job_queue_processes|10|FALSE|
|log_archive_dest_1|LOCATION=/dbpcardarch/pcard1/PCARD/archivelog|FALSE|
|open_cursors|300|FALSE|
|pga_aggregate_target|602931200|FALSE|
|processes|500|FALSE|
|remote_login_passwordfile|EXCLUSIVE|FALSE|
|sga_max_size|2868903936|FALSE|
|sga_target|2868903936|FALSE|
|undo_management|AUTO|FALSE|
|undo_tablespace|UNDOTBS1|FALSE|
|user_dump_dest|/pcard18/admin/pcard/udump|FALSE|
[[#Top][Back to top]]
---+ All Parameters
|*Parameter Name*|*Value*|*Default*|*Modified*|
|O7_DICTIONARY_ACCESSIBILITY|FALSE|TRUE|FALSE|
|active_instance_count|%NULL%|TRUE|FALSE|
|aq_tm_processes|0|TRUE|FALSE|
|archive_lag_target|0|TRUE|FALSE|
|asm_diskgroups|%NULL%|TRUE|FALSE|
|asm_diskstring|%NULL%|TRUE|FALSE|
|asm_power_limit|1|TRUE|FALSE|
|audit_file_dest|/pcard18/admin/pcard/adump|FALSE|FALSE|
|audit_sys_operations|FALSE|TRUE|FALSE|
|audit_syslog_level|%NULL%|TRUE|FALSE|
|audit_trail|NONE|TRUE|FALSE|
|background_core_dump|partial|TRUE|FALSE|
|background_dump_dest|/pcard18/admin/pcard/bdump|FALSE|FALSE|
|backup_tape_io_slaves|FALSE|TRUE|FALSE|
|bitmap_merge_area_size|1048576|TRUE|FALSE|
|blank_trimming|FALSE|TRUE|FALSE|
|buffer_pool_keep|%NULL%|TRUE|FALSE|
|buffer_pool_recycle|%NULL%|TRUE|FALSE|
|circuits|%NULL%|TRUE|FALSE|
|cluster_database|FALSE|TRUE|FALSE|
|cluster_database_instances|1|TRUE|FALSE|
|cluster_interconnects|%NULL%|TRUE|FALSE|
|commit_point_strength|1|TRUE|FALSE|
|commit_write|%NULL%|TRUE|FALSE|
|compatible|10.2.0.1.0|FALSE|FALSE|
|control_file_record_keep_time|7|TRUE|FALSE|
|control_files|/pcard02/oradata/pcard/control01.ctl, /pcard03/oradata/pcard/control02.ctl, /pcard04/oradata/pcard/control03.ctl|FALSE|FALSE|
|core_dump_dest|/pcard18/admin/pcard/cdump|FALSE|FALSE|
|cpu_count|2|TRUE|FALSE|
|create_bitmap_area_size|8388608|TRUE|FALSE|
|create_stored_outlines|%NULL%|TRUE|FALSE|
|cursor_sharing|EXACT|TRUE|FALSE|
|cursor_space_for_time|FALSE|TRUE|FALSE|
|db_16k_cache_size|0|TRUE|FALSE|
|db_2k_cache_size|0|TRUE|FALSE|
|db_32k_cache_size|0|TRUE|FALSE|
|db_4k_cache_size|0|TRUE|FALSE|
|db_8k_cache_size|0|TRUE|FALSE|
|db_block_buffers|0|TRUE|FALSE|
|db_block_checking|FALSE|TRUE|FALSE|
|db_block_checksum|TRUE|TRUE|FALSE|
|db_block_size|8192|FALSE|FALSE|
|db_cache_advice|ON|TRUE|FALSE|
|db_cache_size|0|TRUE|FALSE|
|db_create_file_dest|%NULL%|TRUE|FALSE|
|db_create_online_log_dest_1|%NULL%|TRUE|FALSE|
|db_create_online_log_dest_2|%NULL%|TRUE|FALSE|
|db_create_online_log_dest_3|%NULL%|TRUE|FALSE|
|db_create_online_log_dest_4|%NULL%|TRUE|FALSE|
|db_create_online_log_dest_5|%NULL%|TRUE|FALSE|
|db_domain|%NULL%|FALSE|FALSE|
|db_file_multiblock_read_count|16|FALSE|FALSE|
|db_file_name_convert|%NULL%|TRUE|FALSE|
|db_files|200|TRUE|FALSE|
|db_flashback_retention_target|1440|TRUE|FALSE|
|db_keep_cache_size|0|TRUE|FALSE|
|db_name|pcard|FALSE|FALSE|
|db_recovery_file_dest|%NULL%|TRUE|FALSE|
|db_recovery_file_dest_size|0|TRUE|FALSE|
|db_recycle_cache_size|0|TRUE|FALSE|
|db_unique_name|pcard|TRUE|FALSE|
|db_writer_processes|1|TRUE|FALSE|
|dbwr_io_slaves|0|TRUE|FALSE|
|ddl_wait_for_locks|FALSE|TRUE|FALSE|
|dg_broker_config_file1|/u01/app/oracle/product/10.2.0/db_1/dbs/dr1pcard.dat|TRUE|FALSE|
|dg_broker_config_file2|/u01/app/oracle/product/10.2.0/db_1/dbs/dr2pcard.dat|TRUE|FALSE|
|dg_broker_start|FALSE|TRUE|FALSE|
|disk_asynch_io|TRUE|TRUE|FALSE|
|dispatchers|(PROTOCOL=TCP) (SERVICE=pcard)|FALSE|FALSE|
|distributed_lock_timeout|60|TRUE|FALSE|
|dml_locks|2440|TRUE|FALSE|
|drs_start|FALSE|TRUE|FALSE|
|event|%NULL%|TRUE|FALSE|
|fal_client|%NULL%|TRUE|FALSE|
|fal_server|%NULL%|TRUE|FALSE|
|fast_start_io_target|0|TRUE|FALSE|
|fast_start_mttr_target|0|TRUE|FALSE|
|fast_start_parallel_rollback|LOW|TRUE|FALSE|
|file_mapping|FALSE|TRUE|FALSE|
|fileio_network_adapters|%NULL%|TRUE|FALSE|
|filesystemio_options|none|TRUE|FALSE|
|fixed_date|%NULL%|TRUE|FALSE|
|gc_files_to_locks|%NULL%|TRUE|FALSE|
|gcs_server_processes|0|TRUE|FALSE|
|global_context_pool_size|%NULL%|TRUE|FALSE|
|global_names|FALSE|TRUE|FALSE|
|hash_area_size|131072|TRUE|FALSE|
|hi_shared_memory_address|0|TRUE|FALSE|
|hs_autoregister|TRUE|TRUE|FALSE|
|ifile|%NULL%|TRUE|FALSE|
|instance_groups|%NULL%|TRUE|FALSE|
|instance_name|pcard|TRUE|FALSE|
|instance_number|0|TRUE|FALSE|
|instance_type|RDBMS|TRUE|FALSE|
|java_max_sessionspace_size|0|TRUE|FALSE|
|java_pool_size|0|TRUE|FALSE|
|java_soft_sessionspace_limit|0|TRUE|FALSE|
|job_queue_processes|10|FALSE|FALSE|
|large_pool_size|0|TRUE|FALSE|
|ldap_directory_access|NONE|TRUE|FALSE|
|license_max_sessions|0|TRUE|FALSE|
|license_max_users|0|TRUE|FALSE|
|license_sessions_warning|0|TRUE|FALSE|
|local_listener|%NULL%|TRUE|FALSE|
|lock_name_space|%NULL%|TRUE|FALSE|
|lock_sga|FALSE|TRUE|FALSE|
|log_archive_config|%NULL%|TRUE|FALSE|
|log_archive_dest|%NULL%|TRUE|FALSE|
|log_archive_dest_1|LOCATION=/dbpcardarch/pcard1/PCARD/archivelog|FALSE|FALSE|
|log_archive_dest_10|%NULL%|TRUE|FALSE|
|log_archive_dest_2|%NULL%|TRUE|FALSE|
|log_archive_dest_3|%NULL%|TRUE|FALSE|
|log_archive_dest_4|%NULL%|TRUE|FALSE|
|log_archive_dest_5|%NULL%|TRUE|FALSE|
|log_archive_dest_6|%NULL%|TRUE|FALSE|
|log_archive_dest_7|%NULL%|TRUE|FALSE|
|log_archive_dest_8|%NULL%|TRUE|FALSE|
|log_archive_dest_9|%NULL%|TRUE|FALSE|
|log_archive_dest_state_1|enable|TRUE|FALSE|
|log_archive_dest_state_10|enable|TRUE|FALSE|
|log_archive_dest_state_2|enable|TRUE|FALSE|
|log_archive_dest_state_3|enable|TRUE|FALSE|
|log_archive_dest_state_4|enable|TRUE|FALSE|
|log_archive_dest_state_5|enable|TRUE|FALSE|
|log_archive_dest_state_6|enable|TRUE|FALSE|
|log_archive_dest_state_7|enable|TRUE|FALSE|
|log_archive_dest_state_8|enable|TRUE|FALSE|
|log_archive_dest_state_9|enable|TRUE|FALSE|
|log_archive_duplex_dest|%NULL%|TRUE|FALSE|
|log_archive_format|%t_%s_%r.dbf|TRUE|FALSE|
|log_archive_local_first|TRUE|TRUE|FALSE|
|log_archive_max_processes|2|TRUE|FALSE|
|log_archive_min_succeed_dest|1|TRUE|FALSE|
|log_archive_start|FALSE|TRUE|FALSE|
|log_archive_trace|0|TRUE|FALSE|
|log_buffer|14242816|TRUE|FALSE|
|log_checkpoint_interval|0|TRUE|FALSE|
|log_checkpoint_timeout|1800|TRUE|FALSE|
|log_checkpoints_to_alert|FALSE|TRUE|FALSE|
|log_file_name_convert|%NULL%|TRUE|FALSE|
|logmnr_max_persistent_sessions|1|TRUE|FALSE|
|max_commit_propagation_delay|0|TRUE|FALSE|
|max_dispatchers|%NULL%|TRUE|FALSE|
|max_dump_file_size|UNLIMITED|TRUE|FALSE|
|max_enabled_roles|150|TRUE|FALSE|
|max_shared_servers|%NULL%|TRUE|FALSE|
|nls_calendar|%NULL%|TRUE|FALSE|
|nls_comp|%NULL%|TRUE|FALSE|
|nls_currency|%NULL%|TRUE|FALSE|
|nls_date_format|%NULL%|TRUE|FALSE|
|nls_date_language|%NULL%|TRUE|FALSE|
|nls_dual_currency|%NULL%|TRUE|FALSE|
|nls_iso_currency|%NULL%|TRUE|FALSE|
|nls_language|AMERICAN|TRUE|FALSE|
|nls_length_semantics|BYTE|TRUE|FALSE|
|nls_nchar_conv_excp|FALSE|TRUE|FALSE|
|nls_numeric_characters|%NULL%|TRUE|FALSE|
|nls_sort|%NULL%|TRUE|FALSE|
|nls_territory|AMERICA|TRUE|FALSE|
|nls_time_format|%NULL%|TRUE|FALSE|
|nls_time_tz_format|%NULL%|TRUE|FALSE|
|nls_timestamp_format|%NULL%|TRUE|FALSE|
|nls_timestamp_tz_format|%NULL%|TRUE|FALSE|
|object_cache_max_size_percent|10|TRUE|FALSE|
|object_cache_optimal_size|102400|TRUE|FALSE|
|olap_page_pool_size|0|TRUE|FALSE|
|open_cursors|300|FALSE|FALSE|
|open_links|4|TRUE|FALSE|
|open_links_per_instance|4|TRUE|FALSE|
|optimizer_dynamic_sampling|2|TRUE|FALSE|
|optimizer_features_enable|10.2.0.4|TRUE|FALSE|
|optimizer_index_caching|0|TRUE|FALSE|
|optimizer_index_cost_adj|100|TRUE|FALSE|
|optimizer_mode|ALL_ROWS|TRUE|FALSE|
|optimizer_secure_view_merging|TRUE|TRUE|FALSE|
|os_authent_prefix|ops$|TRUE|FALSE|
|os_roles|FALSE|TRUE|FALSE|
|parallel_adaptive_multi_user|TRUE|TRUE|FALSE|
|parallel_automatic_tuning|FALSE|TRUE|FALSE|
|parallel_execution_message_size|2152|TRUE|FALSE|
|parallel_instance_group|%NULL%|TRUE|FALSE|
|parallel_max_servers|40|TRUE|FALSE|
|parallel_min_percent|0|TRUE|FALSE|
|parallel_min_servers|0|TRUE|FALSE|
|parallel_server|FALSE|TRUE|FALSE|
|parallel_server_instances|1|TRUE|FALSE|
|parallel_threads_per_cpu|2|TRUE|FALSE|
|pga_aggregate_target|602931200|FALSE|FALSE|
|plsql_ccflags|%NULL%|TRUE|FALSE|
|plsql_code_type|INTERPRETED|TRUE|FALSE|
|plsql_compiler_flags|INTERPRETED, NON_DEBUG|TRUE|FALSE|
|plsql_debug|FALSE|TRUE|FALSE|
|plsql_native_library_dir|%NULL%|TRUE|FALSE|
|plsql_native_library_subdir_count|0|TRUE|FALSE|
|plsql_optimize_level|2|TRUE|FALSE|
|plsql_v2_compatibility|FALSE|TRUE|FALSE|
|plsql_warnings|DISABLE:ALL|TRUE|FALSE|
|pre_11g_enable_capture|FALSE|TRUE|FALSE|
|pre_page_sga|FALSE|TRUE|FALSE|
|processes|500|FALSE|FALSE|
|query_rewrite_enabled|TRUE|TRUE|FALSE|
|query_rewrite_integrity|enforced|TRUE|FALSE|
|rdbms_server_dn|%NULL%|TRUE|FALSE|
|read_only_open_delayed|FALSE|TRUE|FALSE|
|recovery_parallelism|0|TRUE|FALSE|
|recyclebin|on|TRUE|FALSE|
|remote_archive_enable|true|TRUE|FALSE|
|remote_dependencies_mode|TIMESTAMP|TRUE|FALSE|
|remote_listener|%NULL%|TRUE|FALSE|
|remote_login_passwordfile|EXCLUSIVE|FALSE|FALSE|
|remote_os_authent|FALSE|TRUE|FALSE|
|remote_os_roles|FALSE|TRUE|FALSE|
|replication_dependency_tracking|TRUE|TRUE|FALSE|
|resource_limit|FALSE|TRUE|FALSE|
|resource_manager_plan|%NULL%|TRUE|FALSE|
|resumable_timeout|0|TRUE|FALSE|
|rollback_segments|%NULL%|TRUE|FALSE|
|serial_reuse|disable|TRUE|FALSE|
|service_names|pcard|TRUE|FALSE|
|session_cached_cursors|20|TRUE|FALSE|
|session_max_open_files|10|TRUE|FALSE|
|sessions|555|TRUE|FALSE|
|sga_max_size|2868903936|FALSE|FALSE|
|sga_target|2868903936|FALSE|FALSE|
|shadow_core_dump|partial|TRUE|FALSE|
|shared_memory_address|0|TRUE|FALSE|
|shared_pool_reserved_size|27682406|TRUE|FALSE|
|shared_pool_size|0|TRUE|FALSE|
|shared_server_sessions|%NULL%|TRUE|FALSE|
|shared_servers|1|TRUE|FALSE|
|skip_unusable_indexes|TRUE|TRUE|FALSE|
|smtp_out_server|%NULL%|TRUE|FALSE|
|sort_area_retained_size|0|TRUE|FALSE|
|sort_area_size|65536|TRUE|FALSE|
|spfile|/u01/app/oracle/product/10.2.0/db_1/dbs/spfilepcard.ora|TRUE|FALSE|
|sql92_security|FALSE|TRUE|FALSE|
|sql_trace|FALSE|TRUE|FALSE|
|sql_version|NATIVE|TRUE|FALSE|
|sqltune_category|DEFAULT|TRUE|FALSE|
|standby_archive_dest|?/dbs/arch|TRUE|FALSE|
|standby_file_management|MANUAL|TRUE|FALSE|
|star_transformation_enabled|FALSE|TRUE|FALSE|
|statistics_level|TYPICAL|TRUE|FALSE|
|streams_pool_size|0|TRUE|FALSE|
|tape_asynch_io|TRUE|TRUE|FALSE|
|thread|0|TRUE|FALSE|
|timed_os_statistics|0|TRUE|FALSE|
|timed_statistics|TRUE|TRUE|FALSE|
|trace_enabled|TRUE|TRUE|FALSE|
|tracefile_identifier|%NULL%|TRUE|FALSE|
|transactions|610|TRUE|FALSE|
|transactions_per_rollback_segment|5|TRUE|FALSE|
|undo_management|AUTO|FALSE|FALSE|
|undo_retention|900|TRUE|FALSE|
|undo_tablespace|UNDOTBS1|FALSE|FALSE|
|use_indirect_data_buffers|FALSE|TRUE|FALSE|
|user_dump_dest|/pcard18/admin/pcard/udump|FALSE|FALSE|
|utl_file_dir|%NULL%|TRUE|FALSE|
|workarea_size_policy|AUTO|TRUE|FALSE|
[[#Top][Back to top]]
