Init Parameters
name value
tracefile_identifier
lock_name_space
processes 50
sessions 60
timed_statistics TRUE
timed_os_statistics 0
resource_limit FALSE
license_max_sessions 0
license_sessions_warning 0
cpu_count 1
instance_groups
event
sga_max_size 83886080
pre_page_sga FALSE
shared_memory_address 0
hi_shared_memory_address 0
use_indirect_data_buffers FALSE
lock_sga FALSE
shared_pool_size 0
large_pool_size 0
java_pool_size 0
streams_pool_size 0
shared_pool_reserved_size 2516582
java_soft_sessionspace_limit 0
java_max_sessionspace_size 0
spfile D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SPFILEORCL10.ORA
instance_type RDBMS
trace_enabled TRUE
nls_language SIMPLIFIED CHINESE
nls_territory CHINA
nls_sort
nls_date_language
nls_date_format
nls_currency
nls_numeric_characters
nls_iso_currency
nls_calendar
nls_time_format
nls_timestamp_format
nls_time_tz_format
nls_timestamp_tz_format
nls_dual_currency
nls_comp
nls_length_semantics BYTE
nls_nchar_conv_excp FALSE
fileio_network_adapters
filesystemio_options
disk_asynch_io TRUE
tape_asynch_io TRUE
dbwr_io_slaves 0
backup_tape_io_slaves FALSE
resource_manager_plan
cluster_interconnects
file_mapping FALSE
gcs_server_processes 0
active_instance_count
sga_target 83886080
control_files D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL10\CONTROL01.CTL, D:\OR
ACLE\PRODUCT\10.2.0\ORADATA\ORCL10\CONTROL02.CTL, D:\ORACLE\
PRODUCT\10.2.0\ORADATA\ORCL10\CONTROL03.CTL
db_file_name_convert
log_file_name_convert
control_file_record_keep_time 7
db_block_buffers 0
db_block_checksum TRUE
db_block_size 8192
db_cache_size 0
db_2k_cache_size 0
db_4k_cache_size 0
db_8k_cache_size 0
db_16k_cache_size 0
db_32k_cache_size 0
db_keep_cache_size 0
db_recycle_cache_size 0
db_writer_processes 1
buffer_pool_keep
buffer_pool_recycle
db_cache_advice ON
max_commit_propagation_delay 0
compatible 10.2.0.3.0
remote_archive_enable TRUE
log_archive_config
log_archive_start FALSE
log_archive_dest
log_archive_duplex_dest
log_archive_dest_1
log_archive_dest_2
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_10
log_archive_dest_state_1 enable
log_archive_dest_state_2 enable
log_archive_dest_state_3 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_dest_state_6 enable
log_archive_dest_state_7 enable
log_archive_dest_state_8 enable
log_archive_dest_state_9 enable
log_archive_dest_state_10 enable
log_archive_max_processes 2
log_archive_min_succeed_dest 1
standby_archive_dest %ORACLE_HOME%\RDBMS
log_archive_trace 0
log_archive_local_first TRUE
log_archive_format ARC%S_%R.%T
fal_client
fal_server
log_buffer 2859008
log_checkpoint_interval 0
log_checkpoint_timeout 1800
archive_lag_target 0
db_files 200
db_file_multiblock_read_count 16
read_only_open_delayed FALSE
cluster_database FALSE
parallel_server FALSE
parallel_server_instances 1
cluster_database_instances 1
db_create_file_dest
db_create_online_log_dest_1
db_create_online_log_dest_2
db_create_online_log_dest_3
db_create_online_log_dest_4
db_create_online_log_dest_5
db_recovery_file_dest D:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size 629145600
standby_file_management MANUAL
gc_files_to_locks
thread 0
fast_start_io_target 0
fast_start_mttr_target 0
log_checkpoints_to_alert FALSE
recovery_parallelism 0
logmnr_max_persistent_sessions 1
db_flashback_retention_target 1440
dml_locks 264
ddl_wait_for_locks FALSE
replication_dependency_tracking TRUE
instance_number 0
transactions 66
transactions_per_rollback_segment 5
rollback_segments
undo_management AUTO
undo_tablespace UNDOTBS1
undo_retention 900
fast_start_parallel_rollback LOW
resumable_timeout 0
db_block_checking FALSE
recyclebin on
create_stored_outlines
serial_reuse disable
ldap_directory_access NONE
os_roles FALSE
rdbms_server_dn
max_enabled_roles 150
remote_os_authent FALSE
remote_os_roles FALSE
O7_DICTIONARY_ACCESSIBILITY FALSE
remote_login_passwordfile EXCLUSIVE
license_max_users 0
audit_sys_operations FALSE
global_context_pool_size
db_domain
global_names FALSE
distributed_lock_timeout 60
commit_point_strength 1
instance_name orcl10
service_names orcl10
dispatchers
shared_servers 0
max_shared_servers
max_dispatchers
circuits
shared_server_sessions
local_listener
remote_listener
cursor_space_for_time FALSE
session_cached_cursors 20
remote_dependencies_mode TIMESTAMP
utl_file_dir
smtp_out_server
plsql_v2_compatibility FALSE
plsql_compiler_flags INTERPRETED, NON_DEBUG
plsql_native_library_dir
plsql_native_library_subdir_count 0
plsql_warnings DISABLE:ALL
plsql_code_type INTERPRETED
plsql_debug FALSE
plsql_optimize_level 2
plsql_ccflags
job_queue_processes 10
parallel_min_percent 0
create_bitmap_area_size 8388608
bitmap_merge_area_size 1048576
cursor_sharing EXACT
parallel_min_servers 0
parallel_max_servers 20
parallel_instance_group
parallel_execution_message_size 2148
hash_area_size 131072
audit_file_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL10\ADUMP
shadow_core_dump partial
background_core_dump partial
background_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL10\BDUMP
user_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL10\UDUMP
max_dump_file_size UNLIMITED
core_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL10\CDUMP
object_cache_optimal_size 102400
object_cache_max_size_percent 10
session_max_open_files 10
open_links 4
open_links_per_instance 4
commit_write
optimizer_features_enable 10.2.0.3
fixed_date
audit_trail NONE
sort_area_size 65536
sort_area_retained_size 0
db_name orcl10
db_unique_name orcl10
open_cursors 300
ifile
sql_trace FALSE
os_authent_prefix OPS$
optimizer_mode ALL_ROWS
sql92_security FALSE
blank_trimming FALSE
star_transformation_enabled FALSE
parallel_adaptive_multi_user TRUE
parallel_threads_per_cpu 2
parallel_automatic_tuning FALSE
optimizer_index_cost_adj 100
optimizer_index_caching 0
query_rewrite_enabled TRUE
query_rewrite_integrity enforced
sql_version NATIVE
pga_aggregate_target 16777216
workarea_size_policy AUTO
optimizer_dynamic_sampling 2
statistics_level TYPICAL
skip_unusable_indexes TRUE
optimizer_secure_view_merging TRUE
aq_tm_processes 0
hs_autoregister TRUE
dg_broker_start FALSE
drs_start FALSE
dg_broker_config_file1 D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\DR1ORCL10.DAT
dg_broker_config_file2 D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\DR2ORCL10.DAT
olap_page_pool_size 0
select * from v$parameter;