pat98's always & forever

[TEST]oracle@ora19c:/oracle/app/oracle/product/19.3.0/dbs# strings spfileTEST.ora

TEST.__data_transfer_cache_size=0

TEST.__db_cache_size=1124073472

TEST.__inmemory_ext_roarea=0

TEST.__inmemory_ext_rwarea=0

TEST.__java_pool_size=0

TEST.__large_pool_size=16777216

TEST.__oracle_base='/oracle/app'#ORACLE_BASE set from environment

TEST.__pga_aggregate_target=536870912

TEST.__sga_target=1610612736

TEST.__shared_io_pool_size=83886080

TEST.__shared_pool_size=369098752

TEST.__streams_pool_size=0

TEST.__unified_pga_pool_size=0

*.audit_file_dest='/oracle/app/admin/TEST/adump

*.audit_trail='db'

*.compatible='19.0.0'

*.control_files='/oracle/oradata/TEST/control01.ctl','/oracle/oradata/TEST/control02.ctl'

*.db_block_size=8192

*.db_name='TEST'

*.diagnostic_dest='/oracle/app'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'

*.nls_language='AMERICAN'

*.nls_territory='AMERICA'

*.open_cursors=300

*.pga_aggregate_target=512m

*.processes=300

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=1536m

*.undo_tablespace='UNDOTBS1'

[oracle:/home/oracle]#ss
SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 10 15:19:33 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select status from v$instance;

STATUS
------------------------
OPEN

SQL> show parameter

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
DBFIPS_140                             boolean                FALSE
active_instance_count                  integer
adg_account_info_tracking              string                 LOCAL
adg_redirect_dml                       boolean                FALSE
allow_global_dblinks                   boolean                FALSE
allow_group_access_to_sga              boolean                FALSE
allow_rowid_column_type                boolean                FALSE
approx_for_aggregation                 boolean                FALSE
approx_for_count_distinct              boolean                FALSE
approx_for_percentile                  string                 none
aq_tm_processes                        integer                1
archive_lag_target                     integer                0
asm_diskstring                         string
asm_preferred_read_failure_groups      string
audit_file_dest                        string                 /oracle/app/admin/ORA19/adump
audit_sys_operations                   boolean                TRUE
audit_syslog_level                     string
audit_trail                            string                 DB
autotask_max_active_pdbs               integer                2
awr_pdb_autoflush_enabled              boolean                FALSE
awr_pdb_max_parallel_slaves            integer                10
awr_snapshot_time_offset               integer                0
background_core_dump                   string                 partial
background_dump_dest                   string                 /oracle/app/product/19.3.0/rdbms/log
backup_tape_io_slaves                  boolean                FALSE
bitmap_merge_area_size                 integer                1048576
blank_trimming                         boolean                FALSE
buffer_pool_keep                       string
buffer_pool_recycle                    string
cdb_cluster                            boolean                FALSE
cdb_cluster_name                       string
cell_offload_compaction                string                 ADAPTIVE
cell_offload_decryption                boolean                TRUE
cell_offload_parameters                string
cell_offload_plan_display              string                 AUTO
cell_offload_processing                boolean                TRUE
cell_offloadgroup_name                 string
circuits                               integer
client_result_cache_lag                big integer            3000
client_result_cache_size               big integer            0
client_statistics_level                string                 TYPICAL
clonedb                                boolean                FALSE
clonedb_dir                            string
cluster_database                       boolean                FALSE
cluster_database_instances             integer                1
cluster_interconnects                  string
commit_logging                         string
commit_point_strength                  integer                1
commit_wait                            string
commit_write                           string
common_user_prefix                     string                 C##
compatible                             string                 19.0.0
connection_brokers                     string                 ((TYPE=DEDICATED)(BROKERS=1)),((TYPE=EMON)(BROKERS=1))
containers_parallel_degree             integer                65535
control_file_record_keep_time          integer                7
control_files                          string                 /oradata/ORA19/control01.ctl,/oradata/ORA19/control02.ctl
control_management_pack_access         string                 DIAGNOSTIC+TUNING
core_dump_dest                         string                 /oracle/app/diag/rdbms/ora19/ORA19/cdump
cpu_count                              integer                1
cpu_min_count                          string                 1
create_bitmap_area_size                integer                8388608
create_stored_outlines                 string
cursor_bind_capture_destination        string                 memory+disk
cursor_invalidation                    string                 IMMEDIATE
cursor_sharing                         string                 EXACT
cursor_space_for_time                  boolean                FALSE
data_guard_max_io_time                 integer                240
data_guard_max_longio_time             integer                240
data_guard_sync_latency                integer                0
data_transfer_cache_size               big integer            0
db_16k_cache_size                      big integer            0
db_2k_cache_size                       big integer            0
db_32k_cache_size                      big integer            0
db_4k_cache_size                       big integer            0
db_8k_cache_size                       big integer            0
db_big_table_cache_percent_target      string                 0
db_block_buffers                       integer                0
db_block_checking                      string                 FALSE
db_block_checksum                      string                 TYPICAL
db_block_size                          integer                8192
db_cache_advice                        string                 ON
db_cache_size                          big integer            0
db_create_file_dest                    string
db_create_online_log_dest_1            string
db_create_online_log_dest_2            string
db_create_online_log_dest_3            string
db_create_online_log_dest_4            string
db_create_online_log_dest_5            string
db_domain                              string
db_file_multiblock_read_count          integer                128
db_file_name_convert                   string
db_files                               integer                200
db_flash_cache_file                    string
db_flash_cache_size                    big integer            0
db_flashback_retention_target          integer                1440
db_index_compression_inheritance       string                 NONE
db_keep_cache_size                     big integer            0
db_lost_write_protect                  string                 NONE
db_name                                string                 ORA19
db_performance_profile                 string
db_recovery_file_dest                  string
db_recovery_file_dest_size             big integer            0
db_recycle_cache_size                  big integer            0
db_securefile                          string                 PREFERRED
db_ultra_safe                          string                 OFF
db_unique_name                         string                 ORA19
db_unrecoverable_scn_tracking          boolean                TRUE
db_writer_processes                    integer                1
dbwr_io_slaves                         integer                0
ddl_lock_timeout                       integer                0
default_sharing                        string                 metadata
deferred_segment_creation              boolean                TRUE
dg_broker_config_file1                 string                 /oracle/app/product/19.3.0/dbs/dr1ORA19.dat
dg_broker_config_file2                 string                 /oracle/app/product/19.3.0/dbs/dr2ORA19.dat
dg_broker_start                        boolean                FALSE
diagnostic_dest                        string                 /oracle/app
disable_pdb_feature                    big integer            0
disk_asynch_io                         boolean                TRUE
dispatchers                            string                 (PROTOCOL=TCP) (SERVICE=ORA19XDB)
distributed_lock_timeout               integer                60
dml_locks                              integer                2076
dnfs_batch_size                        integer                4096
dst_upgrade_insert_conv                boolean                TRUE
enable_automatic_maintenance_pdb       boolean                TRUE
enable_ddl_logging                     boolean                FALSE
enable_dnfs_dispatcher                 boolean                FALSE
enable_goldengate_replication          boolean                FALSE
enable_imc_with_mira                   boolean                FALSE
enable_pluggable_database              boolean                TRUE
enabled_PDBs_on_standby                string                 *
encrypt_new_tablespaces                string                 CLOUD_ONLY
event                                  string
external_keystore_credential_location  string
fal_client                             string
fal_server                             string
fast_start_io_target                   integer                0
fast_start_mttr_target                 integer                0
fast_start_parallel_rollback           string                 LOW
file_mapping                           boolean                FALSE
fileio_network_adapters                string
filesystemio_options                   string                 none
fixed_date                             string
forward_listener                       string
gcs_server_processes                   integer                0
global_names                           boolean                FALSE
global_txn_processes                   integer                1
hash_area_size                         integer                131072
heat_map                               string                 OFF
hi_shared_memory_address               integer                0
hs_autoregister                        boolean                TRUE
http_proxy                             string
ifile                                  file
inmemory_adg_enabled                   boolean                TRUE
inmemory_automatic_level               string                 OFF
inmemory_clause_default                string
inmemory_expressions_usage             string                 ENABLE
inmemory_force                         string                 DEFAULT
inmemory_max_populate_servers          integer                0
inmemory_optimized_arithmetic          string                 DISABLE
inmemory_prefer_xmem_memcompress       string
inmemory_prefer_xmem_priority          string
inmemory_query                         string                 ENABLE
inmemory_size                          big integer            0
inmemory_trickle_repopulate_servers_   integer                1
percent                               
inmemory_virtual_columns               string                 MANUAL
inmemory_xmem_size                     big integer            0
instance_abort_delay_time              integer                0
instance_groups                        string
instance_mode                          string                 READ-WRITE
instance_name                          string                 ORA19
instance_number                        integer                0
instance_type                          string                 RDBMS
instant_restore                        boolean                FALSE
java_jit_enabled                       boolean                TRUE
java_max_sessionspace_size             integer                0
java_pool_size                         big integer            0
java_restrict                          string                 none
java_soft_sessionspace_limit           integer                0
job_queue_processes                    integer                20
large_pool_size                        big integer            0
ldap_directory_access                  string                 NONE
ldap_directory_sysauth                 string                 no
license_max_sessions                   integer                0
license_max_users                      integer                0
license_sessions_warning               integer                0
listener_networks                      string
lob_signature_enable                   boolean                FALSE
local_listener                         string                 LISTENER_ORA19
lock_name_space                        string
lock_sga                               boolean                FALSE
log_archive_config                     string
log_archive_dest                       string
log_archive_dest_1                     string
log_archive_dest_10                    string
log_archive_dest_11                    string
log_archive_dest_12                    string
log_archive_dest_13                    string
log_archive_dest_14                    string
log_archive_dest_15                    string
log_archive_dest_16                    string
log_archive_dest_17                    string
log_archive_dest_18                    string
log_archive_dest_19                    string
log_archive_dest_2                     string
log_archive_dest_20                    string
log_archive_dest_21                    string
log_archive_dest_22                    string
log_archive_dest_23                    string
log_archive_dest_24                    string
log_archive_dest_25                    string
log_archive_dest_26                    string
log_archive_dest_27                    string
log_archive_dest_28                    string
log_archive_dest_29                    string
log_archive_dest_3                     string
log_archive_dest_30                    string
log_archive_dest_31                    string
log_archive_dest_4                     string
log_archive_dest_5                     string
log_archive_dest_6                     string
log_archive_dest_7                     string
log_archive_dest_8                     string
log_archive_dest_9                     string
log_archive_dest_state_1               string                 enable
log_archive_dest_state_10              string                 enable
log_archive_dest_state_11              string                 enable
log_archive_dest_state_12              string                 enable
log_archive_dest_state_13              string                 enable
log_archive_dest_state_14              string                 enable
log_archive_dest_state_15              string                 enable
log_archive_dest_state_16              string                 enable
log_archive_dest_state_17              string                 enable
log_archive_dest_state_18              string                 enable
log_archive_dest_state_19              string                 enable
log_archive_dest_state_2               string                 enable
log_archive_dest_state_20              string                 enable
log_archive_dest_state_21              string                 enable
log_archive_dest_state_22              string                 enable
log_archive_dest_state_23              string                 enable
log_archive_dest_state_24              string                 enable
log_archive_dest_state_25              string                 enable
log_archive_dest_state_26              string                 enable
log_archive_dest_state_27              string                 enable
log_archive_dest_state_28              string                 enable
log_archive_dest_state_29              string                 enable
log_archive_dest_state_3               string                 enable
log_archive_dest_state_30              string                 enable
log_archive_dest_state_31              string                 enable
log_archive_dest_state_4               string                 enable
log_archive_dest_state_5               string                 enable
log_archive_dest_state_6               string                 enable
log_archive_dest_state_7               string                 enable
log_archive_dest_state_8               string                 enable
log_archive_dest_state_9               string                 enable
log_archive_duplex_dest                string
log_archive_format                     string                 %t_%s_%r.dbf
log_archive_max_processes              integer                4
log_archive_min_succeed_dest           integer                1
log_archive_start                      boolean                FALSE
log_archive_trace                      integer                0
log_buffer                             big integer            7136K
log_checkpoint_interval                integer                0
log_checkpoint_timeout                 integer                1800
log_checkpoints_to_alert               boolean                FALSE
log_file_name_convert                  string
long_module_action                     boolean                TRUE
max_datapump_jobs_per_pdb              string                 100
max_datapump_parallel_per_job          string                 50
max_dispatchers                        integer
max_dump_file_size                     string                 unlimited
max_idle_blocker_time                  integer                0
max_idle_time                          integer                0
max_iops                               integer                0
max_mbps                               integer                0
max_pdbs                               integer                254
max_shared_servers                     integer
max_string_size                        string                 STANDARD
memoptimize_pool_size                  big integer            0
memory_max_target                      big integer            0
memory_target                          big integer            0
multishard_query_data_consistency      string                 strong
multishard_query_partial_results       string                 not allowed
nls_calendar                           string                 GREGORIAN
nls_comp                               string                 BINARY
nls_currency                           string                 $
nls_date_format                        string                 DD-MON-RR
nls_date_language                      string                 AMERICAN
nls_dual_currency                      string                 $
nls_iso_currency                       string                 AMERICA
nls_language                           string                 AMERICAN
nls_length_semantics                   string                 BYTE
nls_nchar_conv_excp                    string                 FALSE
nls_numeric_characters                 string                 .,
nls_sort                               string                 BINARY
nls_territory                          string                 AMERICA
nls_time_format                        string                 HH.MI.SSXFF AM
nls_time_tz_format                     string                 HH.MI.SSXFF AM TZR
nls_timestamp_format                   string                 DD-MON-RR HH.MI.SSXFF AM
nls_timestamp_tz_format                string                 DD-MON-RR HH.MI.SSXFF AM TZR
noncdb_compatible                      boolean                FALSE
object_cache_max_size_percent          integer                10
object_cache_optimal_size              integer                10240000
ofs_threads                            integer                4
olap_page_pool_size                    big integer            0
one_step_plugin_for_pdb_with_tde       boolean                FALSE
open_cursors                           integer                300
open_links                             integer                4
open_links_per_instance                integer                4
optimizer_adaptive_plans               boolean                TRUE
optimizer_adaptive_reporting_only      boolean                FALSE
optimizer_adaptive_statistics          boolean                FALSE
optimizer_capture_sql_plan_baselines   boolean                FALSE
optimizer_dynamic_sampling             integer                2
optimizer_features_enable              string                 19.1.0
optimizer_ignore_hints                 boolean                FALSE
optimizer_ignore_parallel_hints        boolean                FALSE
optimizer_index_caching                integer                0
optimizer_index_cost_adj               integer                100
optimizer_inmemory_aware               boolean                TRUE
optimizer_mode                         string                 ALL_ROWS
optimizer_secure_view_merging          boolean                TRUE
optimizer_use_invisible_indexes        boolean                FALSE
optimizer_use_pending_statistics       boolean                FALSE
optimizer_use_sql_plan_baselines       boolean                TRUE
os_authent_prefix                      string                 ops$
os_roles                               boolean                FALSE
outbound_dblink_protocols              string                 ALL
parallel_adaptive_multi_user           boolean                FALSE
parallel_degree_limit                  string                 CPU
parallel_degree_policy                 string                 MANUAL
parallel_execution_message_size        integer                16384
parallel_force_local                   boolean                FALSE
parallel_instance_group                string
parallel_max_servers                   integer                20
parallel_min_degree                    string                 1
parallel_min_percent                   integer                0
parallel_min_servers                   integer                2
parallel_min_time_threshold            string                 AUTO
parallel_servers_target                integer                20
parallel_threads_per_cpu               integer                1
pdb_file_name_convert                  string
pdb_lockdown                           string
pdb_os_credential                      string
pdb_template                           string
permit_92_wrap_format                  boolean                TRUE
pga_aggregate_limit                    big integer            2G
pga_aggregate_target                   big integer            788M
plscope_settings                       string                 IDENTIFIERS:NONE
plsql_ccflags                          string
plsql_code_type                        string                 INTERPRETED
plsql_debug                            boolean                FALSE
plsql_optimize_level                   integer                2
plsql_v2_compatibility                 boolean                FALSE
plsql_warnings                         string                 DISABLE:ALL
pre_page_sga                           boolean                TRUE
private_temp_table_prefix              string                 ORA$PTT_
processes                              integer                300
processor_group_name                   string
query_rewrite_enabled                  string                 TRUE
query_rewrite_integrity                string                 enforced
rdbms_server_dn                        string
read_only_open_delayed                 boolean                FALSE
recovery_parallelism                   integer                0
recyclebin                             string                 on
redo_transport_user                    string
remote_dependencies_mode               string                 TIMESTAMP
remote_listener                        string
remote_login_passwordfile              string                 EXCLUSIVE
remote_os_authent                      boolean                FALSE
remote_os_roles                        boolean                FALSE
remote_recovery_file_dest              string
replication_dependency_tracking        boolean                TRUE
resource_limit                         boolean                TRUE
resource_manage_goldengate             boolean                FALSE
resource_manager_cpu_allocation        integer                1
resource_manager_plan                  string
result_cache_max_result                integer                5
result_cache_max_size                  big integer            12128K
result_cache_mode                      string                 MANUAL
result_cache_remote_expiration         integer                0
resumable_timeout                      integer                0
rollback_segments                      string
scheduler_follow_pdbtz                 boolean                FALSE
sec_case_sensitive_logon               boolean                TRUE
sec_max_failed_login_attempts          integer                3
sec_protocol_error_further_action      string                 (DROP,3)
sec_protocol_error_trace_action        string                 TRACE
sec_return_server_release_banner       boolean                FALSE
serial_reuse                           string                 disable
service_names                          string                 ORA19
session_cached_cursors                 integer                50
session_max_open_files                 integer                10
sessions                               integer                472
sga_max_size                           big integer            2368M
sga_min_size                           big integer            0
sga_target                             big integer            2368M
shadow_core_dump                       string                 partial
shared_memory_address                  integer                0
shared_pool_reserved_size              big integer            26004684
shared_pool_size                       big integer            0
shared_server_sessions                 integer
shared_servers                         integer                1
shrd_dupl_table_refresh_rate           integer                60
skip_unusable_indexes                  boolean                TRUE
smtp_out_server                        string
sort_area_retained_size                integer                0
sort_area_size                         integer                65536
spatial_vector_acceleration            boolean                FALSE
spfile                                 string                 /oracle/app/product/19.3.0/dbs/spfileORA19.ora
sql92_security                         boolean                TRUE
sql_trace                              boolean                FALSE
sqltune_category                       string                 DEFAULT
ssl_wallet                             string
standby_db_preserve_states             string                 NONE
standby_file_management                string                 MANUAL
standby_pdb_source_file_dblink         string
standby_pdb_source_file_directory      string
star_transformation_enabled            string                 FALSE
statistics_level                       string                 TYPICAL
streams_pool_size                      big integer            0
tape_asynch_io                         boolean                TRUE
target_pdbs                            integer                4
tde_configuration                      string
temp_undo_enabled                      boolean                FALSE
thread                                 integer                0
threaded_execution                     boolean                FALSE
timed_os_statistics                    integer                0
timed_statistics                       boolean                TRUE
trace_enabled                          boolean                TRUE
tracefile_identifier                   string
transactions                           integer                519
transactions_per_rollback_segment      integer                5
undo_management                        string                 AUTO
undo_retention                         integer                900
undo_tablespace                        string                 UNDOTBS1
unified_audit_common_systemlog         string
unified_audit_sga_queue_size           integer                1048576
unified_audit_systemlog                string
uniform_log_timestamp_format           boolean                TRUE
use_dedicated_broker                   boolean                FALSE
use_large_pages                        string                 TRUE
user_dump_dest                         string                 /oracle/app/product/19.3.0/rdbms/log
wallet_root                            string
workarea_size_policy                   string                 AUTO
xml_db_events                          string                 enable

제품 Support 소식입니다.

Oracle 19c RAC 에는 더이상 SE2 를 지원하지 않는다고 합니다. 

오라클 메뉴얼과 오라클 RAC Product Manager 인 Markus Michalewicz 의 발표 자료에서 퍼 왔습니다.

앞으로 SE2 RAC 사용 고객들은

1. RAC -> Single 로 변경

2. Eneterprise 로 업그레이드

3. SE2 ->클라우드로 이전 

위의 3가지 사항들에 대해 고민거리가 생길 듯 합니다.