Database Parameters

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 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

Back to top

All Parameters

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

Back to top