SPFile Parameter Values

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