| SID | Name | Value | Is Specified? | Ordinal | Update Comment |
|---|---|---|---|---|---|
| * | O7_DICTIONARY_ACCESSIBILITY | FALSE | 0 | ||
| * | active_instance_count | FALSE | 0 | ||
| * | aq_tm_processes | FALSE | 0 | ||
| * | archive_lag_target | FALSE | 0 | ||
| * | asm_diskgroups | FALSE | 0 | ||
| * | asm_diskstring | FALSE | 0 | ||
| * | asm_power_limit | FALSE | 0 | ||
| * | audit_file_dest | /pcard18/admin/pcard/adump | TRUE | 1 | |
| * | audit_sys_operations | FALSE | 0 | ||
| * | audit_syslog_level | FALSE | 0 | ||
| * | audit_trail | FALSE | 0 | ||
| * | background_core_dump | FALSE | 0 | ||
| * | background_dump_dest | /pcard18/admin/pcard/bdump | TRUE | 1 | |
| * | backup_tape_io_slaves | FALSE | 0 | ||
| * | bitmap_merge_area_size | FALSE | 0 | ||
| * | blank_trimming | FALSE | 0 | ||
| * | buffer_pool_keep | FALSE | 0 | ||
| * | buffer_pool_recycle | FALSE | 0 | ||
| * | circuits | FALSE | 0 | ||
| * | cluster_database | FALSE | 0 | ||
| * | cluster_database_instances | FALSE | 0 | ||
| * | cluster_interconnects | FALSE | 0 | ||
| * | commit_point_strength | FALSE | 0 | ||
| * | commit_write | FALSE | 0 | ||
| * | compatible | 10.2.0.1.0 | TRUE | 1 | |
| * | control_file_record_keep_time | FALSE | 0 | ||
| * | control_files | /pcard02/oradata/pcard/control01.ctl | TRUE | 1 | |
| * | control_files | /pcard03/oradata/pcard/control02.ctl | TRUE | 2 | |
| * | control_files | /pcard04/oradata/pcard/control03.ctl | TRUE | 3 | |
| * | core_dump_dest | /pcard18/admin/pcard/cdump | TRUE | 1 | |
| * | cpu_count | FALSE | 0 | ||
| * | create_bitmap_area_size | FALSE | 0 | ||
| * | create_stored_outlines | FALSE | 0 | ||
| * | cursor_sharing | FALSE | 0 | ||
| * | cursor_space_for_time | FALSE | 0 | ||
| * | db_16k_cache_size | FALSE | 0 | ||
| * | db_2k_cache_size | FALSE | 0 | ||
| * | db_32k_cache_size | FALSE | 0 | ||
| * | db_4k_cache_size | FALSE | 0 | ||
| * | db_8k_cache_size | FALSE | 0 | ||
| * | db_block_buffers | FALSE | 0 | ||
| * | db_block_checking | FALSE | 0 | ||
| * | db_block_checksum | FALSE | 0 | ||
| * | db_block_size | 8192 | TRUE | 1 | |
| * | db_cache_advice | FALSE | 0 | ||
| * | db_cache_size | FALSE | 0 | ||
| * | db_create_file_dest | FALSE | 0 | ||
| * | db_create_online_log_dest_1 | FALSE | 0 | ||
| * | db_create_online_log_dest_2 | FALSE | 0 | ||
| * | db_create_online_log_dest_3 | FALSE | 0 | ||
| * | db_create_online_log_dest_4 | FALSE | 0 | ||
| * | db_create_online_log_dest_5 | FALSE | 0 | ||
| * | db_domain | TRUE | 1 | ||
| * | db_file_multiblock_read_count | 16 | TRUE | 1 | |
| * | db_file_name_convert | FALSE | 0 | ||
| * | db_files | FALSE | 0 | ||
| * | db_flashback_retention_target | FALSE | 0 | ||
| * | db_keep_cache_size | FALSE | 0 | ||
| * | db_name | pcard | TRUE | 1 | |
| * | db_recovery_file_dest | FALSE | 0 | ||
| * | db_recovery_file_dest_size | FALSE | 0 | ||
| * | db_recycle_cache_size | FALSE | 0 | ||
| * | db_unique_name | FALSE | 0 | ||
| * | db_writer_processes | FALSE | 0 | ||
| * | dbwr_io_slaves | FALSE | 0 | ||
| * | ddl_wait_for_locks | FALSE | 0 | ||
| * | dg_broker_config_file1 | FALSE | 0 | ||
| * | dg_broker_config_file2 | FALSE | 0 | ||
| * | dg_broker_start | FALSE | 0 | ||
| * | disk_asynch_io | FALSE | 0 | ||
| * | dispatchers | (PROTOCOL=TCP) (SERVICE=pcard) | TRUE | 1 | |
| * | distributed_lock_timeout | FALSE | 0 | ||
| * | dml_locks | FALSE | 0 | ||
| * | drs_start | FALSE | 0 | ||
| * | event | FALSE | 0 | ||
| * | fal_client | FALSE | 0 | ||
| * | fal_server | FALSE | 0 | ||
| * | fast_start_io_target | FALSE | 0 | ||
| * | fast_start_mttr_target | FALSE | 0 | ||
| * | fast_start_parallel_rollback | FALSE | 0 | ||
| * | file_mapping | FALSE | 0 | ||
| * | fileio_network_adapters | FALSE | 0 | ||
| * | filesystemio_options | FALSE | 0 | ||
| * | fixed_date | FALSE | 0 | ||
| * | gc_files_to_locks | FALSE | 0 | ||
| * | gcs_server_processes | FALSE | 0 | ||
| * | global_context_pool_size | FALSE | 0 | ||
| * | global_names | FALSE | 0 | ||
| * | hash_area_size | FALSE | 0 | ||
| * | hi_shared_memory_address | FALSE | 0 | ||
| * | hs_autoregister | FALSE | 0 | ||
| * | ifile | FALSE | 0 | ||
| * | instance_groups | FALSE | 0 | ||
| * | instance_name | FALSE | 0 | ||
| * | instance_number | FALSE | 0 | ||
| * | instance_type | FALSE | 0 | ||
| * | java_max_sessionspace_size | FALSE | 0 | ||
| * | java_pool_size | FALSE | 0 | ||
| * | java_soft_sessionspace_limit | FALSE | 0 | ||
| * | job_queue_processes | 10 | TRUE | 1 | |
| * | large_pool_size | FALSE | 0 | ||
| * | ldap_directory_access | FALSE | 0 | ||
| * | license_max_sessions | FALSE | 0 | ||
| * | license_max_users | FALSE | 0 | ||
| * | license_sessions_warning | FALSE | 0 | ||
| * | local_listener | FALSE | 0 | ||
| * | lock_name_space | FALSE | 0 | ||
| * | lock_sga | FALSE | 0 | ||
| * | log_archive_config | FALSE | 0 | ||
| * | log_archive_dest | FALSE | 0 | ||
| * | log_archive_dest_1 | LOCATION=/dbpcardarch/pcard1/PCARD/archivelog | TRUE | 1 | |
| * | log_archive_dest_10 | FALSE | 0 | ||
| * | log_archive_dest_2 | FALSE | 0 | ||
| * | log_archive_dest_3 | FALSE | 0 | ||
| * | log_archive_dest_4 | FALSE | 0 | ||
| * | log_archive_dest_5 | FALSE | 0 | ||
| * | log_archive_dest_6 | FALSE | 0 | ||
| * | log_archive_dest_7 | FALSE | 0 | ||
| * | log_archive_dest_8 | FALSE | 0 | ||
| * | log_archive_dest_9 | FALSE | 0 | ||
| * | log_archive_dest_state_1 | FALSE | 0 | ||
| * | log_archive_dest_state_10 | FALSE | 0 | ||
| * | log_archive_dest_state_2 | FALSE | 0 | ||
| * | log_archive_dest_state_3 | FALSE | 0 | ||
| * | log_archive_dest_state_4 | FALSE | 0 | ||
| * | log_archive_dest_state_5 | FALSE | 0 | ||
| * | log_archive_dest_state_6 | FALSE | 0 | ||
| * | log_archive_dest_state_7 | FALSE | 0 | ||
| * | log_archive_dest_state_8 | FALSE | 0 | ||
| * | log_archive_dest_state_9 | FALSE | 0 | ||
| * | log_archive_duplex_dest | FALSE | 0 | ||
| * | log_archive_format | FALSE | 0 | ||
| * | log_archive_local_first | FALSE | 0 | ||
| * | log_archive_max_processes | FALSE | 0 | ||
| * | log_archive_min_succeed_dest | FALSE | 0 | ||
| * | log_archive_start | FALSE | 0 | ||
| * | log_archive_trace | FALSE | 0 | ||
| * | log_buffer | FALSE | 0 | ||
| * | log_checkpoint_interval | FALSE | 0 | ||
| * | log_checkpoint_timeout | FALSE | 0 | ||
| * | log_checkpoints_to_alert | FALSE | 0 | ||
| * | log_file_name_convert | FALSE | 0 | ||
| * | logmnr_max_persistent_sessions | FALSE | 0 | ||
| * | max_commit_propagation_delay | FALSE | 0 | ||
| * | max_dispatchers | FALSE | 0 | ||
| * | max_dump_file_size | FALSE | 0 | ||
| * | max_enabled_roles | FALSE | 0 | ||
| * | max_shared_servers | FALSE | 0 | ||
| * | nls_calendar | FALSE | 0 | ||
| * | nls_comp | FALSE | 0 | ||
| * | nls_currency | FALSE | 0 | ||
| * | nls_date_format | FALSE | 0 | ||
| * | nls_date_language | FALSE | 0 | ||
| * | nls_dual_currency | FALSE | 0 | ||
| * | nls_iso_currency | FALSE | 0 | ||
| * | nls_language | FALSE | 0 | ||
| * | nls_length_semantics | FALSE | 0 | ||
| * | nls_nchar_conv_excp | FALSE | 0 | ||
| * | nls_numeric_characters | FALSE | 0 | ||
| * | nls_sort | FALSE | 0 | ||
| * | nls_territory | FALSE | 0 | ||
| * | nls_time_format | FALSE | 0 | ||
| * | nls_time_tz_format | FALSE | 0 | ||
| * | nls_timestamp_format | FALSE | 0 | ||
| * | nls_timestamp_tz_format | FALSE | 0 | ||
| * | object_cache_max_size_percent | FALSE | 0 | ||
| * | object_cache_optimal_size | FALSE | 0 | ||
| * | olap_page_pool_size | FALSE | 0 | ||
| * | open_cursors | 300 | TRUE | 1 | |
| * | open_links | FALSE | 0 | ||
| * | open_links_per_instance | FALSE | 0 | ||
| * | optimizer_dynamic_sampling | FALSE | 0 | ||
| * | optimizer_features_enable | FALSE | 0 | ||
| * | optimizer_index_caching | FALSE | 0 | ||
| * | optimizer_index_cost_adj | FALSE | 0 | ||
| * | optimizer_mode | FALSE | 0 | ||
| * | optimizer_secure_view_merging | FALSE | 0 | ||
| * | os_authent_prefix | FALSE | 0 | ||
| * | os_roles | FALSE | 0 | ||
| * | parallel_adaptive_multi_user | FALSE | 0 | ||
| * | parallel_automatic_tuning | FALSE | 0 | ||
| * | parallel_execution_message_size | FALSE | 0 | ||
| * | parallel_instance_group | FALSE | 0 | ||
| * | parallel_max_servers | FALSE | 0 | ||
| * | parallel_min_percent | FALSE | 0 | ||
| * | parallel_min_servers | FALSE | 0 | ||
| * | parallel_server | FALSE | 0 | ||
| * | parallel_server_instances | FALSE | 0 | ||
| * | parallel_threads_per_cpu | FALSE | 0 | ||
| * | pga_aggregate_target | 602931200 | TRUE | 1 | |
| * | plsql_ccflags | FALSE | 0 | ||
| * | plsql_code_type | FALSE | 0 | ||
| * | plsql_compiler_flags | FALSE | 0 | ||
| * | plsql_debug | FALSE | 0 | ||
| * | plsql_native_library_dir | FALSE | 0 | ||
| * | plsql_native_library_subdir_count | FALSE | 0 | ||
| * | plsql_optimize_level | FALSE | 0 | ||
| * | plsql_v2_compatibility | FALSE | 0 | ||
| * | plsql_warnings | FALSE | 0 | ||
| * | pre_11g_enable_capture | FALSE | 0 | ||
| * | pre_page_sga | FALSE | 0 | ||
| * | processes | 500 | TRUE | 1 | |
| * | query_rewrite_enabled | FALSE | 0 | ||
| * | query_rewrite_integrity | FALSE | 0 | ||
| * | rdbms_server_dn | FALSE | 0 | ||
| * | read_only_open_delayed | FALSE | 0 | ||
| * | recovery_parallelism | FALSE | 0 | ||
| * | recyclebin | FALSE | 0 | ||
| * | remote_archive_enable | FALSE | 0 | ||
| * | remote_dependencies_mode | FALSE | 0 | ||
| * | remote_listener | FALSE | 0 | ||
| * | remote_login_passwordfile | EXCLUSIVE | TRUE | 1 | |
| * | remote_os_authent | FALSE | 0 | ||
| * | remote_os_roles | FALSE | 0 | ||
| * | replication_dependency_tracking | FALSE | 0 | ||
| * | resource_limit | FALSE | 0 | ||
| * | resource_manager_plan | FALSE | 0 | ||
| * | resumable_timeout | FALSE | 0 | ||
| * | rollback_segments | FALSE | 0 | ||
| * | serial_reuse | FALSE | 0 | ||
| * | service_names | FALSE | 0 | ||
| * | session_cached_cursors | FALSE | 0 | ||
| * | session_max_open_files | FALSE | 0 | ||
| * | sessions | FALSE | 0 | ||
| * | sga_max_size | 2862612480 | TRUE | 1 | |
| * | sga_target | 2862612480 | TRUE | 1 | |
| * | shadow_core_dump | FALSE | 0 | ||
| * | shared_memory_address | FALSE | 0 | ||
| * | shared_pool_reserved_size | FALSE | 0 | ||
| * | shared_pool_size | FALSE | 0 | ||
| * | shared_server_sessions | FALSE | 0 | ||
| * | shared_servers | FALSE | 0 | ||
| * | skip_unusable_indexes | FALSE | 0 | ||
| * | smtp_out_server | FALSE | 0 | ||
| * | sort_area_retained_size | FALSE | 0 | ||
| * | sort_area_size | FALSE | 0 | ||
| * | spfile | FALSE | 0 | ||
| * | sql92_security | FALSE | 0 | ||
| * | sql_trace | FALSE | 0 | ||
| * | sql_version | FALSE | 0 | ||
| * | sqltune_category | FALSE | 0 | ||
| * | standby_archive_dest | FALSE | 0 | ||
| * | standby_file_management | FALSE | 0 | ||
| * | star_transformation_enabled | FALSE | 0 | ||
| * | statistics_level | FALSE | 0 | ||
| * | streams_pool_size | FALSE | 0 | ||
| * | tape_asynch_io | FALSE | 0 | ||
| * | thread | FALSE | 0 | ||
| * | timed_os_statistics | FALSE | 0 | ||
| * | timed_statistics | FALSE | 0 | ||
| * | trace_enabled | FALSE | 0 | ||
| * | tracefile_identifier | FALSE | 0 | ||
| * | transactions | FALSE | 0 | ||
| * | transactions_per_rollback_segment | FALSE | 0 | ||
| * | undo_management | AUTO | TRUE | 1 | |
| * | undo_retention | FALSE | 0 | ||
| * | undo_tablespace | UNDOTBS1 | TRUE | 1 | |
| * | use_indirect_data_buffers | FALSE | 0 | ||
| * | user_dump_dest | /pcard18/admin/pcard/udump | TRUE | 1 | |
| * | utl_file_dir | FALSE | 0 | ||
| * | workarea_size_policy | FALSE | 0 |