| 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 value | 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 |
| Parameter Name | Value | Default | Modified |
|---|---|---|---|
| O7_DICTIONARY_ACCESSIBILITY | FALSE | TRUE | FALSE |
| active_instance_count | Null value | TRUE | FALSE |
| aq_tm_processes | 0 | TRUE | FALSE |
| archive_lag_target | 0 | TRUE | FALSE |
| asm_diskgroups | Null value | TRUE | FALSE |
| asm_diskstring | Null value | 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 value | 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 value | TRUE | FALSE |
| buffer_pool_recycle | Null value | TRUE | FALSE |
| circuits | Null value | TRUE | FALSE |
| cluster_database | FALSE | TRUE | FALSE |
| cluster_database_instances | 1 | TRUE | FALSE |
| cluster_interconnects | Null value | TRUE | FALSE |
| commit_point_strength | 1 | TRUE | FALSE |
| commit_write | Null value | 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 value | 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 value | TRUE | FALSE |
| db_create_online_log_dest_1 | Null value | TRUE | FALSE |
| db_create_online_log_dest_2 | Null value | TRUE | FALSE |
| db_create_online_log_dest_3 | Null value | TRUE | FALSE |
| db_create_online_log_dest_4 | Null value | TRUE | FALSE |
| db_create_online_log_dest_5 | Null value | TRUE | FALSE |
| db_domain | Null value | FALSE | FALSE |
| db_file_multiblock_read_count | 16 | FALSE | FALSE |
| db_file_name_convert | Null value | 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 value | 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 value | TRUE | FALSE |
| fal_client | Null value | TRUE | FALSE |
| fal_server | Null value | 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 value | TRUE | FALSE |
| filesystemio_options | none | TRUE | FALSE |
| fixed_date | Null value | TRUE | FALSE |
| gc_files_to_locks | Null value | TRUE | FALSE |
| gcs_server_processes | 0 | TRUE | FALSE |
| global_context_pool_size | Null value | 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 value | TRUE | FALSE |
| instance_groups | Null value | 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 value | TRUE | FALSE |
| lock_name_space | Null value | TRUE | FALSE |
| lock_sga | FALSE | TRUE | FALSE |
| log_archive_config | Null value | TRUE | FALSE |
| log_archive_dest | Null value | TRUE | FALSE |
| log_archive_dest_1 | LOCATION=/dbpcardarch/pcard1/PCARD/archivelog | FALSE | FALSE |
| log_archive_dest_10 | Null value | TRUE | FALSE |
| log_archive_dest_2 | Null value | TRUE | FALSE |
| log_archive_dest_3 | Null value | TRUE | FALSE |
| log_archive_dest_4 | Null value | TRUE | FALSE |
| log_archive_dest_5 | Null value | TRUE | FALSE |
| log_archive_dest_6 | Null value | TRUE | FALSE |
| log_archive_dest_7 | Null value | TRUE | FALSE |
| log_archive_dest_8 | Null value | TRUE | FALSE |
| log_archive_dest_9 | Null value | 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 value | 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 value | TRUE | FALSE |
| logmnr_max_persistent_sessions | 1 | TRUE | FALSE |
| max_commit_propagation_delay | 0 | TRUE | FALSE |
| max_dispatchers | Null value | TRUE | FALSE |
| max_dump_file_size | UNLIMITED | TRUE | FALSE |
| max_enabled_roles | 150 | TRUE | FALSE |
| max_shared_servers | Null value | TRUE | FALSE |
| nls_calendar | Null value | TRUE | FALSE |
| nls_comp | Null value | TRUE | FALSE |
| nls_currency | Null value | TRUE | FALSE |
| nls_date_format | Null value | TRUE | FALSE |
| nls_date_language | Null value | TRUE | FALSE |
| nls_dual_currency | Null value | TRUE | FALSE |
| nls_iso_currency | Null value | TRUE | FALSE |
| nls_language | AMERICAN | TRUE | FALSE |
| nls_length_semantics | BYTE | TRUE | FALSE |
| nls_nchar_conv_excp | FALSE | TRUE | FALSE |
| nls_numeric_characters | Null value | TRUE | FALSE |
| nls_sort | Null value | TRUE | FALSE |
| nls_territory | AMERICA | TRUE | FALSE |
| nls_time_format | Null value | TRUE | FALSE |
| nls_time_tz_format | Null value | TRUE | FALSE |
| nls_timestamp_format | Null value | TRUE | FALSE |
| nls_timestamp_tz_format | Null value | 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 value | 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 value | 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 value | 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 value | 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 value | 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 value | TRUE | FALSE |
| resumable_timeout | 0 | TRUE | FALSE |
| rollback_segments | Null value | 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 value | TRUE | FALSE |
| shared_servers | 1 | TRUE | FALSE |
| skip_unusable_indexes | TRUE | TRUE | FALSE |
| smtp_out_server | Null value | 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 value | 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 value | TRUE | FALSE |
| workarea_size_policy | AUTO | TRUE | FALSE |