Static or dynamic parameter in Oracle
FALSE -It requires changes to carry out to SPFILE ,All parameter that have the column ISSYS_MODIFIABLE value FALSE in the V$PARAMETER view are STATIC parameters and remaining are DYNAMIC parameters in Oracle database.
SQL> select name, value, issys_modifiable from v$parameter ;
NAME VALUE ISSYS_MOD
----------------------------------- ------------------------- ---------
lock_name_space FALSE
processes 300 FALSE
sessions 472 IMMEDIATE
timed_statistics TRUE IMMEDIATE
timed_os_statistics 0 IMMEDIATE
resource_limit TRUE IMMEDIATE
license_max_sessions 0 IMMEDIATE
license_sessions_warning 0 IMMEDIATE
long_module_action TRUE IMMEDIATE
standby_db_preserve_states NONE FALSE
instance_abort_delay_time 0 IMMEDIATE
cpu_count 2 IMMEDIATE
instance_groups FALSE
event FALSE
sga_max_size 1660944384 FALSE
use_large_pages TRUE FALSE
pre_page_sga TRUE FALSE
shared_memory_address 0 FALSE
hi_shared_memory_address 0 FALSE
lock_sga FALSE FALSE
processor_group_name FALSE
allow_group_access_to_sga FALSE FALSE
sga_min_size 0 IMMEDIATE
shared_pool_size 0 IMMEDIATE
large_pool_size 0 IMMEDIATE
java_pool_size 0 IMMEDIATE
streams_pool_size 0 IMMEDIATE
shared_pool_reserved_size 10905190 FALSE
java_soft_sessionspace_limit 0 FALSE
java_max_sessionspace_size 0 FALSE
pga_aggregate_limit 2147483648 IMMEDIATE
spfile /u01/app/oracle/product/1 IMMEDIATE
2.2.0/dbhome_1/dbs/spfile
orcl.ora
instance_type RDBMS FALSE
uniform_log_timestamp_format TRUE IMMEDIATE
nls_language AMERICAN FALSE
nls_territory AMERICA FALSE
nls_sort FALSE
nls_date_language FALSE
nls_date_format FALSE
nls_currency FALSE
nls_numeric_characters FALSE
nls_iso_currency FALSE
nls_calendar FALSE
nls_time_format FALSE
nls_timestamp_format FALSE
nls_time_tz_format FALSE
nls_timestamp_tz_format FALSE
nls_dual_currency FALSE
nls_comp BINARY FALSE
nls_length_semantics BYTE IMMEDIATE
nls_nchar_conv_excp FALSE IMMEDIATE
disk_asynch_io TRUE FALSE
tape_asynch_io TRUE FALSE
dbwr_io_slaves 0 FALSE
backup_tape_io_slaves FALSE DEFERRED
fileio_network_adapters FALSE
filesystemio_options none FALSE
dnfs_batch_size 4096 FALSE
clonedb FALSE FALSE
instant_restore FALSE FALSE
ofs_threads 4 IMMEDIATE
resource_manager_cpu_allocation 2 IMMEDIATE
resource_manager_plan SCHEDULER[0x4AC7]:DEFAULT IMMEDIATE
_MAINTENANCE_PLAN
db_performance_profile FALSE
max_iops 0 IMMEDIATE
max_mbps 0 IMMEDIATE
max_idle_time 0 IMMEDIATE
cluster_interconnects FALSE
exafusion_enabled 1 FALSE
file_mapping FALSE IMMEDIATE
max_datapump_jobs_per_pdb 100 IMMEDIATE
service_names ORCL IMMEDIATE
threaded_execution FALSE FALSE
clonedb_dir FALSE
enable_dnfs_dispatcher FALSE FALSE
gcs_server_processes 0 FALSE
active_instance_count FALSE
instance_mode READ-WRITE FALSE
sga_target 0 IMMEDIATE
memory_target 1660944384 IMMEDIATE
memory_max_target 1660944384 FALSE
control_files /u01/app/oracle/oradata/o FALSE
rcl/control01.ctl, /u01/a
pp/oracle/oradata/orcl/co
ntrol02.ctl
db_file_name_convert /u01/app/oracle/oradata/o FALSE
rcl/, /u01/app/oracle/ora
data/orcl/
log_file_name_convert /u01/app/oracle/oradata/o FALSE
rcl/, /u01/app/oracle/ora
data/orcl/
control_file_record_keep_time 7 IMMEDIATE
db_block_buffers 0 FALSE
db_block_checksum TYPICAL IMMEDIATE
db_ultra_safe OFF FALSE
db_block_size 8192 FALSE
db_cache_size 0 IMMEDIATE
db_2k_cache_size 0 IMMEDIATE
db_4k_cache_size 0 IMMEDIATE
db_8k_cache_size 0 IMMEDIATE
db_16k_cache_size 0 IMMEDIATE
db_32k_cache_size 0 IMMEDIATE
db_keep_cache_size 0 IMMEDIATE
db_recycle_cache_size 0 IMMEDIATE
db_big_table_cache_percent_target 0 IMMEDIATE
encrypt_new_tablespaces CLOUD_ONLY IMMEDIATE
db_writer_processes 1 FALSE
buffer_pool_keep FALSE
buffer_pool_recycle FALSE
db_flash_cache_file IMMEDIATE
db_flash_cache_size 0 IMMEDIATE
db_cache_advice ON IMMEDIATE
compatible 12.2.0 FALSE
log_archive_dest_1 location=/u01/app/oracle/ IMMEDIATE
product/12.2.0/dbhome_1/d
bs/arch valid_for=(all_lo
gfiles,all_roles) db_uniq
ue_name=ORCL
log_archive_dest_2 service=stand async valid IMMEDIATE
_for=(online_logfiles,pri
mary_role) db_unique_name
=DRORCL
log_archive_dest_3 IMMEDIATE
log_archive_dest_4 IMMEDIATE
log_archive_dest_5 IMMEDIATE
log_archive_dest_6 IMMEDIATE
log_archive_dest_7 IMMEDIATE
log_archive_dest_8 IMMEDIATE
log_archive_dest_9 IMMEDIATE
log_archive_dest_10 IMMEDIATE
log_archive_dest_11 IMMEDIATE
log_archive_dest_12 IMMEDIATE
log_archive_dest_13 IMMEDIATE
log_archive_dest_14 IMMEDIATE
log_archive_dest_15 IMMEDIATE
log_archive_dest_16 IMMEDIATE
log_archive_dest_17 IMMEDIATE
log_archive_dest_18 IMMEDIATE
log_archive_dest_19 IMMEDIATE
log_archive_dest_20 IMMEDIATE
log_archive_dest_21 IMMEDIATE
log_archive_dest_22 IMMEDIATE
log_archive_dest_23 IMMEDIATE
log_archive_dest_24 IMMEDIATE
log_archive_dest_25 IMMEDIATE
log_archive_dest_26 IMMEDIATE
log_archive_dest_27 IMMEDIATE
log_archive_dest_28 IMMEDIATE
log_archive_dest_29 IMMEDIATE
log_archive_dest_30 IMMEDIATE
log_archive_dest_31 IMMEDIATE
log_archive_dest_state_1 enable IMMEDIATE
log_archive_dest_state_2 ENABLE IMMEDIATE
log_archive_dest_state_3 enable IMMEDIATE
log_archive_dest_state_4 enable IMMEDIATE
log_archive_dest_state_5 enable IMMEDIATE
log_archive_dest_state_6 enable IMMEDIATE
log_archive_dest_state_7 enable IMMEDIATE
log_archive_dest_state_8 enable IMMEDIATE
log_archive_dest_state_9 enable IMMEDIATE
log_archive_dest_state_10 enable IMMEDIATE
log_archive_dest_state_11 enable IMMEDIATE
log_archive_dest_state_12 enable IMMEDIATE
log_archive_dest_state_13 enable IMMEDIATE
log_archive_dest_state_14 enable IMMEDIATE
log_archive_dest_state_15 enable IMMEDIATE
log_archive_dest_state_16 enable IMMEDIATE
log_archive_dest_state_17 enable IMMEDIATE
log_archive_dest_state_18 enable IMMEDIATE
log_archive_dest_state_19 enable IMMEDIATE
log_archive_dest_state_20 enable IMMEDIATE
log_archive_dest_state_21 enable IMMEDIATE
log_archive_dest_state_22 enable IMMEDIATE
log_archive_dest_state_23 enable IMMEDIATE
log_archive_dest_state_24 enable IMMEDIATE
log_archive_dest_state_25 enable IMMEDIATE
log_archive_dest_state_26 enable IMMEDIATE
log_archive_dest_state_27 enable IMMEDIATE
log_archive_dest_state_28 enable IMMEDIATE
log_archive_dest_state_29 enable IMMEDIATE
log_archive_dest_state_30 enable IMMEDIATE
log_archive_dest_state_31 enable IMMEDIATE
log_archive_start FALSE FALSE
log_archive_dest IMMEDIATE
log_archive_duplex_dest IMMEDIATE
log_archive_min_succeed_dest 1 IMMEDIATE
standby_archive_dest ?#/dbs/arch IMMEDIATE
fal_client PRIME IMMEDIATE
fal_server STAND IMMEDIATE
log_archive_trace 0 IMMEDIATE
data_guard_sync_latency 0 IMMEDIATE
log_archive_config dg_config=(ORCL,DRORCL) IMMEDIATE
log_archive_format %t_%s_%r.dbf FALSE
redo_transport_user IMMEDIATE
log_archive_max_processes 4 IMMEDIATE
log_buffer 7806976 FALSE
log_checkpoint_interval 0 IMMEDIATE
log_checkpoint_timeout 1800 IMMEDIATE
archive_lag_target 0 IMMEDIATE
db_files 200 FALSE
db_file_multiblock_read_count 128 IMMEDIATE
read_only_open_delayed FALSE FALSE
cluster_database FALSE FALSE
cluster_database_instances 1 FALSE
db_create_file_dest IMMEDIATE
db_create_online_log_dest_1 IMMEDIATE
db_create_online_log_dest_2 IMMEDIATE
db_create_online_log_dest_3 IMMEDIATE
db_create_online_log_dest_4 IMMEDIATE
db_create_online_log_dest_5 IMMEDIATE
db_recovery_file_dest /u01/app/oracle/FRA IMMEDIATE
db_recovery_file_dest_size 3221225472 IMMEDIATE
standby_file_management AUTO IMMEDIATE
db_unrecoverable_scn_tracking TRUE IMMEDIATE
thread 0 IMMEDIATE
enabled_PDBs_on_standby * IMMEDIATE
fast_start_io_target 0 IMMEDIATE
fast_start_mttr_target 0 IMMEDIATE
log_checkpoints_to_alert FALSE IMMEDIATE
db_lost_write_protect NONE IMMEDIATE
recovery_parallelism 0 FALSE
enable_goldengate_replication FALSE IMMEDIATE
inmemory_adg_enabled TRUE IMMEDIATE
db_flashback_retention_target 1440 IMMEDIATE
data_transfer_cache_size 0 IMMEDIATE
dml_locks 2076 FALSE
replication_dependency_tracking TRUE FALSE
transactions 519 FALSE
transactions_per_rollback_segment 5 FALSE
temp_undo_enabled FALSE IMMEDIATE
rollback_segments FALSE
undo_management AUTO FALSE
undo_tablespace UNDOTBS1 IMMEDIATE
undo_retention 900 IMMEDIATE
fast_start_parallel_rollback LOW IMMEDIATE
resumable_timeout 0 IMMEDIATE
instance_number 0 FALSE
heat_map OFF IMMEDIATE
inmemory_size 0 IMMEDIATE
db_block_checking FALSE IMMEDIATE
recyclebin on DEFERRED
db_index_compression_inheritance NONE IMMEDIATE
db_securefile PREFERRED IMMEDIATE
inmemory_clause_default IMMEDIATE
inmemory_force DEFAULT IMMEDIATE
inmemory_query ENABLE IMMEDIATE
inmemory_expressions_usage ENABLE IMMEDIATE
inmemory_virtual_columns MANUAL IMMEDIATE
inmemory_max_populate_servers 0 IMMEDIATE
inmemory_trickle_repopulate_servers 1 IMMEDIATE
_percent
create_stored_outlines IMMEDIATE
serial_reuse disable FALSE
ldap_directory_access NONE IMMEDIATE
ldap_directory_sysauth no FALSE
os_roles FALSE FALSE
rdbms_server_dn FALSE
remote_os_authent FALSE FALSE
remote_os_roles FALSE FALSE
sec_case_sensitive_logon TRUE IMMEDIATE
O7_DICTIONARY_ACCESSIBILITY FALSE FALSE
remote_login_passwordfile EXCLUSIVE FALSE
license_max_users 0 IMMEDIATE
audit_sys_operations TRUE FALSE
DBFIPS_140 FALSE FALSE
one_step_plugin_for_pdb_with_tde FALSE IMMEDIATE
external_keystore_credential_locati FALSE
on
unified_audit_sga_queue_size 1048576 FALSE
db_domain FALSE
global_names FALSE IMMEDIATE
distributed_lock_timeout 60 FALSE
commit_point_strength 1 FALSE
global_txn_processes 1 IMMEDIATE
instance_name orcl FALSE
dispatchers (PROTOCOL=TCP) (SERVICE=o IMMEDIATE
rclXDB)
shared_servers 1 IMMEDIATE
max_shared_servers IMMEDIATE
max_dispatchers IMMEDIATE
circuits IMMEDIATE
shared_server_sessions IMMEDIATE
local_listener LISTENER_ORCL IMMEDIATE
remote_listener IMMEDIATE
listener_networks IMMEDIATE
use_dedicated_broker FALSE IMMEDIATE
connection_brokers ((TYPE=DEDICATED)(BROKERS IMMEDIATE
=1)), ((TYPE=EMON)(BROKER
S=1))
cursor_space_for_time FALSE FALSE
session_cached_cursors 50 DEFERRED
remote_dependencies_mode TIMESTAMP IMMEDIATE
utl_file_dir FALSE
smtp_out_server IMMEDIATE
plsql_v2_compatibility FALSE IMMEDIATE
plsql_warnings DISABLE:ALL IMMEDIATE
plsql_code_type INTERPRETED IMMEDIATE
plsql_debug FALSE IMMEDIATE
plsql_optimize_level 2 IMMEDIATE
plsql_ccflags IMMEDIATE
plscope_settings IDENTIFIERS:NONE IMMEDIATE
permit_92_wrap_format TRUE FALSE
java_jit_enabled TRUE IMMEDIATE
java_restrict none FALSE
job_queue_processes 4000 IMMEDIATE
parallel_min_percent 0 FALSE
create_bitmap_area_size 8388608 FALSE
bitmap_merge_area_size 1048576 FALSE
cursor_sharing EXACT IMMEDIATE
result_cache_mode MANUAL IMMEDIATE
parallel_min_servers 8 IMMEDIATE
parallel_max_servers 80 IMMEDIATE
parallel_instance_group IMMEDIATE
parallel_execution_message_size 16384 FALSE
hash_area_size 131072 FALSE
result_cache_max_size 4161536 IMMEDIATE
result_cache_max_result 5 IMMEDIATE
result_cache_remote_expiration 0 IMMEDIATE
shadow_core_dump partial IMMEDIATE
background_core_dump partial IMMEDIATE
background_dump_dest /u01/app/oracle/product/1 IMMEDIATE
2.2.0/dbhome_1/rdbms/log
user_dump_dest /u01/app/oracle/product/1 IMMEDIATE
2.2.0/dbhome_1/rdbms/log
core_dump_dest /u01/app/oracle/diag/rdbm IMMEDIATE
s/orcl/orcl/cdump
audit_file_dest /u01/app/oracle/admin/orc DEFERRED
l/adump
audit_syslog_level FALSE
resource_manage_goldengate FALSE IMMEDIATE
object_cache_optimal_size 10240000 DEFERRED
object_cache_max_size_percent 10 DEFERRED
session_max_open_files 10 FALSE
open_links 4 FALSE
open_links_per_instance 4 FALSE
commit_write IMMEDIATE
commit_wait IMMEDIATE
commit_logging IMMEDIATE
optimizer_features_enable 12.2.0.1 IMMEDIATE
fixed_date IMMEDIATE
audit_trail DB FALSE
sort_area_size 65536 DEFERRED
sort_area_retained_size 0 DEFERRED
cell_offload_processing TRUE IMMEDIATE
cell_offload_decryption TRUE IMMEDIATE
cell_offload_parameters IMMEDIATE
cell_offload_compaction ADAPTIVE IMMEDIATE
cell_offload_plan_display AUTO IMMEDIATE
db_name orcl FALSE
db_unique_name ORCL FALSE
open_cursors 300 IMMEDIATE
ifile FALSE
sql_trace FALSE IMMEDIATE
os_authent_prefix ops$ FALSE
optimizer_mode ALL_ROWS IMMEDIATE
sql92_security TRUE FALSE
blank_trimming FALSE FALSE
star_transformation_enabled FALSE IMMEDIATE
parallel_degree_policy MANUAL IMMEDIATE
parallel_adaptive_multi_user FALSE IMMEDIATE
parallel_threads_per_cpu 2 IMMEDIATE
optimizer_index_cost_adj 100 IMMEDIATE
optimizer_index_caching 0 IMMEDIATE
query_rewrite_enabled TRUE IMMEDIATE
query_rewrite_integrity enforced IMMEDIATE
pga_aggregate_target 0 IMMEDIATE
workarea_size_policy AUTO IMMEDIATE
optimizer_dynamic_sampling 2 IMMEDIATE
statistics_level TYPICAL IMMEDIATE
cursor_bind_capture_destination memory+disk IMMEDIATE
skip_unusable_indexes TRUE IMMEDIATE
optimizer_secure_view_merging TRUE IMMEDIATE
ddl_lock_timeout 0 IMMEDIATE
deferred_segment_creation TRUE IMMEDIATE
optimizer_use_pending_statistics FALSE IMMEDIATE
optimizer_capture_sql_plan_baseline FALSE IMMEDIATE
s
optimizer_use_sql_plan_baselines TRUE IMMEDIATE
parallel_min_time_threshold AUTO IMMEDIATE
parallel_degree_limit CPU IMMEDIATE
parallel_force_local FALSE IMMEDIATE
optimizer_use_invisible_indexes FALSE IMMEDIATE
dst_upgrade_insert_conv TRUE IMMEDIATE
parallel_servers_target 32 IMMEDIATE
max_string_size STANDARD IMMEDIATE
optimizer_adaptive_reporting_only FALSE IMMEDIATE
optimizer_adaptive_plans TRUE IMMEDIATE
optimizer_inmemory_aware TRUE IMMEDIATE
cursor_invalidation IMMEDIATE IMMEDIATE
approx_for_aggregation FALSE IMMEDIATE
approx_for_count_distinct FALSE IMMEDIATE
approx_for_percentile none IMMEDIATE
optimizer_adaptive_statistics FALSE IMMEDIATE
sec_protocol_error_trace_action TRACE IMMEDIATE
sec_protocol_error_further_action (DROP,3) IMMEDIATE
sec_max_failed_login_attempts 3 FALSE
sec_return_server_release_banner FALSE FALSE
enable_ddl_logging FALSE IMMEDIATE
client_result_cache_size 0 FALSE
client_result_cache_lag 3000 FALSE
outbound_dblink_protocols ALL IMMEDIATE
allow_global_dblinks FALSE IMMEDIATE
aq_tm_processes 1 IMMEDIATE
hs_autoregister TRUE IMMEDIATE
xml_db_events enable IMMEDIATE
dg_broker_start FALSE IMMEDIATE
dg_broker_config_file1 /u01/app/oracle/product/1 IMMEDIATE
2.2.0/dbhome_1/dbs/dr1ORC
L.dat
dg_broker_config_file2 /u01/app/oracle/product/1 IMMEDIATE
2.2.0/dbhome_1/dbs/dr2ORC
L.dat
olap_page_pool_size 0 DEFERRED
asm_diskstring IMMEDIATE
asm_preferred_read_failure_groups IMMEDIATE
asm_diskgroups IMMEDIATE
asm_power_limit 1 IMMEDIATE
asm_io_processes 20 IMMEDIATE
control_management_pack_access DIAGNOSTIC+TUNING IMMEDIATE
awr_pdb_autoflush_enabled FALSE IMMEDIATE
awr_snapshot_time_offset 0 IMMEDIATE
sqltune_category DEFAULT IMMEDIATE
autotask_max_active_pdbs 2 IMMEDIATE
enable_automatic_maintenance_pdb TRUE IMMEDIATE
spatial_vector_acceleration FALSE IMMEDIATE
diagnostic_dest /u01/app/oracle IMMEDIATE
tracefile_identifier FALSE
max_dump_file_size unlimited IMMEDIATE
trace_enabled TRUE IMMEDIATE
cell_offloadgroup_name IMMEDIATE
enable_pluggable_database FALSE FALSE
pdb_os_credential FALSE
pdb_file_name_convert IMMEDIATE
noncdb_compatible FALSE FALSE
common_user_prefix C## FALSE
target_pdbs 0 FALSE
max_pdbs 4098 IMMEDIATE
cdb_cluster FALSE FALSE
cdb_cluster_name ORCL FALSE
remote_recovery_file_dest IMMEDIATE
disable_pdb_feature 0 IMMEDIATE
containers_parallel_degree 65535 IMMEDIATE
default_sharing metadata IMMEDIATE
pdb_lockdown IMMEDIATE
shrd_dupl_table_refresh_rate 60 IMMEDIATE
417 rows selected.
