Created
November 19, 2018 13:16
-
-
Save mago1chi/69162b47a4c1947ec42a11d62fa17a64 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SQL> select name,value,isdefault from v$parameter; | |
NAME VALUE ISDEFAULT | |
---------------------------------------- ---------------------------------------- ------------------ | |
lock_name_space TRUE | |
processes 10000 FALSE | |
sessions 100 FALSE | |
timed_statistics TRUE TRUE | |
timed_os_statistics 0 TRUE | |
resource_limit TRUE TRUE | |
license_max_sessions 0 TRUE | |
license_sessions_warning 0 TRUE | |
long_module_action TRUE TRUE | |
standby_db_preserve_states NONE TRUE | |
instance_abort_delay_time 0 TRUE | |
cpu_count 1 FALSE | |
instance_groups TRUE | |
event TRUE | |
sga_max_size 322122547200 FALSE | |
use_large_pages TRUE TRUE | |
pre_page_sga TRUE TRUE | |
shared_memory_address 0 TRUE | |
hi_shared_memory_address 0 TRUE | |
lock_sga FALSE TRUE | |
processor_group_name TRUE | |
allow_group_access_to_sga FALSE TRUE | |
sga_min_size 0 TRUE | |
shared_pool_size 0 TRUE | |
large_pool_size 0 TRUE | |
java_pool_size 0 TRUE | |
streams_pool_size 0 TRUE | |
shared_pool_reserved_size 1717986918 TRUE | |
java_soft_sessionspace_limit 0 TRUE | |
java_max_sessionspace_size 0 TRUE | |
pga_aggregate_limit 6291456000 FALSE | |
spfile +DATA/EHS1POD/PARAMETERFILE/spfile.256.9 TRUE | |
73829791 | |
instance_type RDBMS TRUE | |
uniform_log_timestamp_format TRUE TRUE | |
nls_language JAPANESE FALSE | |
nls_territory JAPAN FALSE | |
nls_sort BINARY TRUE | |
nls_date_language JAPANESE TRUE | |
nls_date_format RR-MM-DD TRUE | |
nls_currency \ TRUE | |
nls_numeric_characters ., TRUE | |
nls_iso_currency JAPAN TRUE | |
nls_calendar GREGORIAN TRUE | |
nls_time_format HH24:MI:SSXFF TRUE | |
nls_timestamp_format RR-MM-DD HH24:MI:SSXFF TRUE | |
nls_time_tz_format HH24:MI:SSXFF TZR TRUE | |
nls_timestamp_tz_format RR-MM-DD HH24:MI:SSXFF TZR TRUE | |
nls_dual_currency \ TRUE | |
nls_comp BINARY TRUE | |
nls_length_semantics BYTE TRUE | |
nls_nchar_conv_excp FALSE TRUE | |
disk_asynch_io TRUE TRUE | |
tape_asynch_io TRUE TRUE | |
dbwr_io_slaves 0 TRUE | |
backup_tape_io_slaves FALSE TRUE | |
fileio_network_adapters TRUE | |
filesystemio_options none TRUE | |
dnfs_batch_size 4096 TRUE | |
clonedb FALSE TRUE | |
instant_restore FALSE TRUE | |
ofs_threads 40 FALSE | |
resource_manager_cpu_allocation 84 TRUE | |
resource_manager_plan FORCE:OLTP_PLAN FALSE | |
db_performance_profile TRUE | |
max_iops 0 TRUE | |
max_mbps 0 TRUE | |
max_idle_time 0 TRUE | |
_rm_exadata_pdb_cpu_cnt TRUE FALSE | |
_rm_exadata_partition_fc TRUE FALSE | |
max_idle_blocker_time 5 FALSE | |
_pdb_lockdown_ddl_clauses 131066 FALSE | |
_kd_rows_chk FALSE FALSE | |
cluster_interconnects TRUE | |
exafusion_enabled 1 TRUE | |
file_mapping FALSE TRUE | |
max_datapump_jobs_per_pdb 100 TRUE | |
_datapump_gather_stats_on_load TRUE FALSE | |
service_names ehs1pod TRUE | |
threaded_execution FALSE TRUE | |
clonedb_dir TRUE | |
enable_dnfs_dispatcher FALSE TRUE | |
gcs_server_processes 4 TRUE | |
active_instance_count TRUE | |
instance_mode READ-WRITE TRUE | |
sga_target 8388608000 FALSE | |
memory_target 0 TRUE | |
memory_max_target 0 TRUE | |
control_files +DATA/EHS1POD/CONTROLFILE/current.307.97 FALSE | |
3829335 | |
db_file_name_convert TRUE | |
log_file_name_convert TRUE | |
control_file_record_keep_time 7 TRUE | |
db_block_buffers 0 TRUE | |
db_block_checksum TYPICAL TRUE | |
db_ultra_safe OFF TRUE | |
db_block_size 8192 FALSE | |
db_cache_size 0 TRUE | |
db_2k_cache_size 0 TRUE | |
db_4k_cache_size 0 TRUE | |
db_8k_cache_size 0 TRUE | |
db_16k_cache_size 0 TRUE | |
db_32k_cache_size 0 TRUE | |
db_keep_cache_size 0 TRUE | |
db_recycle_cache_size 0 TRUE | |
db_big_table_cache_percent_target 0 TRUE | |
encrypt_new_tablespaces CLOUD_ONLY TRUE | |
db_writer_processes 10 TRUE | |
buffer_pool_keep TRUE | |
buffer_pool_recycle TRUE | |
_db_full_caching FALSE FALSE | |
db_flash_cache_file TRUE | |
db_flash_cache_size 0 TRUE | |
db_cache_advice ON TRUE | |
compatible 12.2.0 FALSE | |
log_archive_dest_1 TRUE | |
log_archive_dest_2 TRUE | |
log_archive_dest_3 TRUE | |
log_archive_dest_4 TRUE | |
log_archive_dest_5 TRUE | |
log_archive_dest_6 TRUE | |
log_archive_dest_7 TRUE | |
log_archive_dest_8 TRUE | |
log_archive_dest_9 TRUE | |
log_archive_dest_10 TRUE | |
log_archive_dest_11 TRUE | |
log_archive_dest_12 TRUE | |
log_archive_dest_13 TRUE | |
log_archive_dest_14 TRUE | |
log_archive_dest_15 TRUE | |
log_archive_dest_16 TRUE | |
log_archive_dest_17 TRUE | |
log_archive_dest_18 TRUE | |
log_archive_dest_19 TRUE | |
log_archive_dest_20 TRUE | |
log_archive_dest_21 TRUE | |
log_archive_dest_22 TRUE | |
log_archive_dest_23 TRUE | |
log_archive_dest_24 TRUE | |
log_archive_dest_25 TRUE | |
log_archive_dest_26 TRUE | |
log_archive_dest_27 TRUE | |
log_archive_dest_28 TRUE | |
log_archive_dest_29 TRUE | |
log_archive_dest_30 TRUE | |
log_archive_dest_31 TRUE | |
log_archive_dest_state_1 enable TRUE | |
log_archive_dest_state_2 enable TRUE | |
log_archive_dest_state_3 enable TRUE | |
log_archive_dest_state_4 enable TRUE | |
log_archive_dest_state_5 enable TRUE | |
log_archive_dest_state_6 enable TRUE | |
log_archive_dest_state_7 enable TRUE | |
log_archive_dest_state_8 enable TRUE | |
log_archive_dest_state_9 enable TRUE | |
log_archive_dest_state_10 enable TRUE | |
log_archive_dest_state_11 enable TRUE | |
log_archive_dest_state_12 enable TRUE | |
log_archive_dest_state_13 enable TRUE | |
log_archive_dest_state_14 enable TRUE | |
log_archive_dest_state_15 enable TRUE | |
log_archive_dest_state_16 enable TRUE | |
log_archive_dest_state_17 enable TRUE | |
log_archive_dest_state_18 enable TRUE | |
log_archive_dest_state_19 enable TRUE | |
log_archive_dest_state_20 enable TRUE | |
log_archive_dest_state_21 enable TRUE | |
log_archive_dest_state_22 enable TRUE | |
log_archive_dest_state_23 enable TRUE | |
log_archive_dest_state_24 enable TRUE | |
log_archive_dest_state_25 enable TRUE | |
log_archive_dest_state_26 enable TRUE | |
log_archive_dest_state_27 enable TRUE | |
log_archive_dest_state_28 enable TRUE | |
log_archive_dest_state_29 enable TRUE | |
log_archive_dest_state_30 enable TRUE | |
log_archive_dest_state_31 enable TRUE | |
log_archive_start FALSE TRUE | |
log_archive_dest TRUE | |
log_archive_duplex_dest TRUE | |
log_archive_min_succeed_dest 1 TRUE | |
standby_archive_dest ?#/dbs/arch TRUE | |
fal_client TRUE | |
fal_server TRUE | |
log_archive_trace 0 TRUE | |
data_guard_sync_latency 0 TRUE | |
log_archive_config TRUE | |
log_archive_format %t_%s_%r.dbf FALSE | |
redo_transport_user TRUE | |
log_archive_max_processes 4 TRUE | |
log_buffer 491356160 TRUE | |
log_checkpoint_interval 0 TRUE | |
log_checkpoint_timeout 1800 TRUE | |
archive_lag_target 0 TRUE | |
db_files 25 FALSE | |
db_file_multiblock_read_count 128 TRUE | |
read_only_open_delayed FALSE TRUE | |
cluster_database TRUE FALSE | |
cluster_database_instances 8 TRUE | |
db_create_file_dest +DATA FALSE | |
db_create_online_log_dest_1 +DATA FALSE | |
db_create_online_log_dest_2 TRUE | |
db_create_online_log_dest_3 TRUE | |
db_create_online_log_dest_4 TRUE | |
db_create_online_log_dest_5 TRUE | |
db_recovery_file_dest +RECO FALSE | |
db_recovery_file_dest_size 39033956728832 FALSE | |
standby_file_management MANUAL TRUE | |
db_unrecoverable_scn_tracking TRUE TRUE | |
thread 8 FALSE | |
enabled_PDBs_on_standby * TRUE | |
fast_start_io_target 0 TRUE | |
fast_start_mttr_target 0 TRUE | |
log_checkpoints_to_alert FALSE TRUE | |
db_lost_write_protect TYPICAL FALSE | |
recovery_parallelism 0 TRUE | |
_disable_cell_optimized_backups TRUE FALSE | |
enable_goldengate_replication TRUE FALSE | |
inmemory_adg_enabled TRUE TRUE | |
db_flashback_retention_target 480 FALSE | |
data_transfer_cache_size 0 TRUE | |
dml_locks 66156 TRUE | |
replication_dependency_tracking TRUE TRUE | |
transactions 16539 TRUE | |
transactions_per_rollback_segment 5 TRUE | |
temp_undo_enabled FALSE TRUE | |
rollback_segments TRUE | |
undo_management AUTO TRUE | |
undo_tablespace UNDOTBS1 FALSE | |
_undo_autotune FALSE FALSE | |
undo_retention 900 TRUE | |
fast_start_parallel_rollback LOW TRUE | |
resumable_timeout 0 TRUE | |
instance_number 8 FALSE | |
heat_map OFF TRUE | |
inmemory_size 1073741824 FALSE | |
db_block_checking MEDIUM FALSE | |
recyclebin on TRUE | |
db_index_compression_inheritance NONE TRUE | |
db_securefile ALWAYS FALSE | |
inmemory_clause_default TRUE | |
inmemory_force DEFAULT TRUE | |
inmemory_query ENABLE TRUE | |
inmemory_expressions_usage ENABLE TRUE | |
inmemory_virtual_columns MANUAL TRUE | |
inmemory_max_populate_servers 42 TRUE | |
inmemory_trickle_repopulate_servers_perc 1 TRUE | |
ent | |
create_stored_outlines TRUE | |
serial_reuse disable TRUE | |
ldap_directory_access NONE TRUE | |
ldap_directory_sysauth no TRUE | |
os_roles FALSE TRUE | |
rdbms_server_dn TRUE | |
remote_os_authent FALSE TRUE | |
remote_os_roles FALSE TRUE | |
sec_case_sensitive_logon TRUE TRUE | |
O7_DICTIONARY_ACCESSIBILITY FALSE TRUE | |
remote_login_passwordfile EXCLUSIVE FALSE | |
license_max_users 0 TRUE | |
audit_sys_operations TRUE TRUE | |
DBFIPS_140 FALSE TRUE | |
one_step_plugin_for_pdb_with_tde FALSE TRUE | |
external_keystore_credential_location +DATA/encrypt_wallet/tde_seps FALSE | |
unified_audit_sga_queue_size 1048576 TRUE | |
db_domain TRUE | |
global_names FALSE TRUE | |
distributed_lock_timeout 60 TRUE | |
commit_point_strength 1 TRUE | |
global_txn_processes 1 TRUE | |
instance_name ehs1pod8 TRUE | |
dispatchers (PROTOCOL=TCP) (SERVICE=ehs1podXDB) FALSE | |
shared_servers 1 TRUE | |
max_shared_servers TRUE | |
max_dispatchers TRUE | |
circuits TRUE | |
shared_server_sessions TRUE | |
use_dedicated_broker FALSE TRUE | |
connection_brokers ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EM TRUE | |
ON)(BROKERS=1)) | |
cursor_space_for_time FALSE TRUE | |
session_cached_cursors 50 TRUE | |
remote_dependencies_mode TIMESTAMP TRUE | |
utl_file_dir TRUE | |
smtp_out_server TRUE | |
plsql_v2_compatibility FALSE TRUE | |
plsql_warnings DISABLE:ALL TRUE | |
plsql_code_type INTERPRETED TRUE | |
plsql_debug FALSE TRUE | |
plsql_optimize_level 2 TRUE | |
plsql_ccflags TRUE | |
plscope_settings IDENTIFIERS:NONE TRUE | |
permit_92_wrap_format TRUE TRUE | |
java_jit_enabled TRUE TRUE | |
java_restrict none TRUE | |
job_queue_processes 4000 TRUE | |
parallel_min_percent 0 TRUE | |
create_bitmap_area_size 8388608 TRUE | |
bitmap_merge_area_size 1048576 TRUE | |
cursor_sharing EXACT TRUE | |
result_cache_mode MANUAL TRUE | |
parallel_min_servers 704 FALSE | |
parallel_max_servers 12 FALSE | |
parallel_instance_group TRUE | |
parallel_execution_message_size 32768 FALSE | |
hash_area_size 131072 TRUE | |
result_cache_max_size 10485760 FALSE | |
result_cache_max_result 5 TRUE | |
result_cache_remote_expiration 0 TRUE | |
shadow_core_dump partial TRUE | |
background_core_dump partial TRUE | |
background_dump_dest /u02/app/oracle/product/12.2.0.1/dbhome_ TRUE | |
1/rdbms/log | |
user_dump_dest /u02/app/oracle/product/12.2.0.1/dbhome_ TRUE | |
1/rdbms/log | |
core_dump_dest /u02/app/oracle/diag/rdbms/ehs1pod/ehs1p TRUE | |
od8/cdump | |
audit_file_dest /u02/app/oracle/admin/ehs1pod/adump FALSE | |
audit_syslog_level TRUE | |
_datapump_inherit_svcname TRUE FALSE | |
resource_manage_goldengate FALSE TRUE | |
object_cache_optimal_size 10240000 TRUE | |
object_cache_max_size_percent 10 TRUE | |
session_max_open_files 10 TRUE | |
open_links 4 TRUE | |
open_links_per_instance 4 TRUE | |
commit_write TRUE | |
commit_wait TRUE | |
commit_logging TRUE | |
optimizer_features_enable 12.2.0.1 TRUE | |
fixed_date TRUE | |
audit_trail DB FALSE | |
sort_area_size 65536 TRUE | |
sort_area_retained_size 0 TRUE | |
cell_offload_processing TRUE TRUE | |
cell_offload_decryption TRUE TRUE | |
cell_offload_parameters TRUE | |
cell_offload_compaction ADAPTIVE TRUE | |
cell_offload_plan_display AUTO TRUE | |
_cell_offload_vector_groupby FALSE FALSE | |
db_name ehs1pod FALSE | |
db_unique_name ehs1pod TRUE | |
open_cursors 300 FALSE | |
ifile TRUE | |
sql_trace FALSE TRUE | |
os_authent_prefix ops$ TRUE | |
optimizer_mode ALL_ROWS TRUE | |
sql92_security TRUE TRUE | |
blank_trimming FALSE TRUE | |
star_transformation_enabled FALSE TRUE | |
_px_xtgranule_size 128000 FALSE | |
parallel_degree_policy MANUAL TRUE | |
parallel_adaptive_multi_user FALSE TRUE | |
parallel_threads_per_cpu 1 FALSE | |
_parallel_cluster_cache_policy ADAPTIVE FALSE | |
optimizer_index_cost_adj 100 TRUE | |
optimizer_index_caching 0 TRUE | |
query_rewrite_enabled TRUE TRUE | |
query_rewrite_integrity TRUSTED FALSE | |
pga_aggregate_target 3145728000 FALSE | |
workarea_size_policy AUTO TRUE | |
optimizer_dynamic_sampling 2 TRUE | |
statistics_level TYPICAL TRUE | |
cursor_bind_capture_destination memory+disk TRUE | |
skip_unusable_indexes TRUE TRUE | |
optimizer_ignore_hints FALSE TRUE | |
optimizer_secure_view_merging TRUE TRUE | |
ddl_lock_timeout 0 TRUE | |
deferred_segment_creation TRUE TRUE | |
optimizer_use_pending_statistics FALSE TRUE | |
optimizer_capture_sql_plan_baselines FALSE TRUE | |
optimizer_use_sql_plan_baselines TRUE TRUE | |
_sqlmon_max_plan 4000 FALSE | |
parallel_min_time_threshold AUTO TRUE | |
parallel_degree_limit CPU TRUE | |
parallel_force_local FALSE TRUE | |
optimizer_use_invisible_indexes FALSE TRUE | |
dst_upgrade_insert_conv TRUE TRUE | |
parallel_servers_target 12 FALSE | |
max_string_size EXTENDED FALSE | |
optimizer_adaptive_reporting_only FALSE TRUE | |
optimizer_adaptive_plans TRUE TRUE | |
optimizer_inmemory_aware TRUE TRUE | |
cursor_invalidation IMMEDIATE TRUE | |
approx_for_aggregation FALSE TRUE | |
approx_for_count_distinct FALSE TRUE | |
approx_for_percentile none TRUE | |
optimizer_adaptive_statistics FALSE TRUE | |
optimizer_ignore_parallel_hints FALSE TRUE | |
_enable_parallel_dml TRUE FALSE | |
parallel_min_degree 1 TRUE | |
_optimizer_gather_stats_on_load_all TRUE FALSE | |
_optimizer_gather_stats_on_load_hist TRUE FALSE | |
sec_protocol_error_trace_action ALERT FALSE | |
sec_protocol_error_further_action (DROP,3) TRUE | |
sec_max_failed_login_attempts 3 TRUE | |
sec_return_server_release_banner FALSE TRUE | |
enable_ddl_logging FALSE TRUE | |
client_result_cache_size 0 TRUE | |
client_result_cache_lag 3000 TRUE | |
outbound_dblink_protocols ALL TRUE | |
allow_global_dblinks FALSE TRUE | |
_spfoc DRIVERS FALSE | |
_spfdc ON FALSE | |
aq_tm_processes 40 FALSE | |
hs_autoregister TRUE TRUE | |
xml_db_events enable TRUE | |
dg_broker_start FALSE TRUE | |
dg_broker_config_file1 /u02/app/oracle/product/12.2.0.1/dbhome_ TRUE | |
1/dbs/dr1ehs1pod.dat | |
dg_broker_config_file2 /u02/app/oracle/product/12.2.0.1/dbhome_ TRUE | |
1/dbs/dr2ehs1pod.dat | |
olap_page_pool_size 0 TRUE | |
asm_diskstring TRUE | |
asm_preferred_read_failure_groups TRUE | |
asm_diskgroups TRUE | |
asm_power_limit 1 TRUE | |
asm_io_processes 20 TRUE | |
control_management_pack_access DIAGNOSTIC+TUNING TRUE | |
awr_pdb_autoflush_enabled TRUE FALSE | |
awr_snapshot_time_offset 0 TRUE | |
sqltune_category DEFAULT TRUE | |
autotask_max_active_pdbs 10 FALSE | |
enable_automatic_maintenance_pdb TRUE TRUE | |
spatial_vector_acceleration FALSE TRUE | |
diagnostic_dest /u02/app/oracle FALSE | |
tracefile_identifier TRUE | |
max_dump_file_size 1073741824 FALSE | |
trace_enabled TRUE TRUE | |
cell_offloadgroup_name TRUE | |
enable_pluggable_database TRUE FALSE | |
pdb_os_credential TRUE | |
pdb_file_name_convert TRUE | |
noncdb_compatible FALSE TRUE | |
common_user_prefix TRUE | |
target_pdbs 600 TRUE | |
max_pdbs 4098 TRUE | |
cdb_cluster FALSE TRUE | |
cdb_cluster_name TRUE | |
standby_pdb_source_file_directory TRUE | |
standby_pdb_source_file_dblink TRUE | |
remote_recovery_file_dest TRUE | |
disable_pdb_feature 0 TRUE | |
_pdb_inherit_cfd TRUE FALSE | |
_auto_start_pdb_services TRUE FALSE | |
_edition_enable_oracle_users C##CLOUD$SERVICE, OML, C##OMLREST FALSE | |
_pdb_max_diag_size 104857600 FALSE | |
_pdb_max_audit_size 209715200 FALSE | |
_cloud_service_type OLTP FALSE | |
_no_catalog XDB FALSE | |
containers_parallel_degree 65535 TRUE | |
_enable_guid_endpoint_service FALSE FALSE | |
default_sharing METADATA TRUE | |
pdb_lockdown OLTP FALSE | |
_pdb_ldp_cascade 0 FALSE | |
_cdb_port 5950 FALSE | |
pdb_template TRUE | |
_restrict_pdb_gv TRUE FALSE | |
_link_ts_name SAMPLESCHEMA FALSE | |
shrd_dupl_table_refresh_rate 60 TRUE | |
451行が選択されました。 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment