Question

oracle数据库，修改哪些配置需要停库之后重启才能生效？

多多益善，先谢谢啦

Answer 1

select NAME,DESCRIPTION from v$system_parameter
where ISSYS_MODIFIABLE='FALSE'
查询出来的全部都是
lock_name_space
processes
sessions
instance_groups
event
sga_max_size
pre_page_sga
shared_memory_address
hi_shared_memory_address
use_indirect_data_buffers
lock_sga
shared_pool_reserved_size
java_soft_sessionspace_limit
java_max_sessionspace_size
instance_type
nls_language
nls_territory
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
fileio_network_adapters
filesystemio_options
disk_asynch_io
tape_asynch_io
dbwr_io_slaves
cluster_interconnects
gcs_server_processes
active_instance_count
memory_max_target
control_files
db_file_name_convert
log_file_name_convert
db_block_buffers
db_ultra_safe
db_block_size
db_writer_processes
buffer_pool_keep
buffer_pool_recycle
db_flash_cache_file
compatible
log_archive_start
log_archive_format
log_buffer
db_files
read_only_open_delayed
cluster_database
parallel_server
parallel_server_instances
cluster_database_instances
recovery_parallelism
dml_locks
replication_dependency_tracking
transactions
transactions_per_rollback_segment
rollback_segments
undo_management
instance_number
serial_reuse
ldap_directory_sysauth
os_roles
rdbms_server_dn
max_enabled_roles
remote_os_authent
remote_os_roles
O7_DICTIONARY_ACCESSIBILITY
remote_login_passwordfile
audit_sys_operations
global_context_pool_size
db_domain
distributed_lock_timeout
commit_point_strength
instance_name
cursor_space_for_time
session_cached_cursors
utl_file_dir
permit_92_wrap_format
parallel_min_percent
create_bitmap_area_size
bitmap_merge_area_size
parallel_execution_message_size
hash_area_size
shadow_core_dump
background_core_dump
audit_syslog_level
session_max_open_files
open_links
open_links_per_instance
audit_trail
db_name
db_unique_name
ifile
os_authent_prefix
sql92_security
blank_trimming
parallel_automatic_tuning
sec_max_failed_login_attempts
sec_return_server_release_banner
client_result_cache_size
client_result_cache_lag
tracefile_identifier

Answer 2

修改db 文件家里面 一个叫oracle的文本文件，改修里面的计算机名时候，或者连接地址localhost,要重启

Answer 3

修改数据库的归档模式。