NAME RECOMMENDATION

I U
REMARK SET IS_VALUE
SHOULD_BE_VALUE ID INST_I
D
---------------------------------------- ---------------------------------------
--------------------------------------------------------------------------------
- --- --- ------------------------------------------------------------ --------
-------------------------------------------------- -----------------------------
--------------------- --- ----------
*** INFORMATION 1 *** Parametercheck for Oracle 11.2 based on
Note/Version: 1431798/90 *
-1
*** INFORMATION 2 *** Parametercheck last changed: 2014-08-14
*
-1
*** INFORMATION 3 *** Parametercheck Execution: 2014-09-08 00
:14:10 *
-1
*** INFORMATION 4 *** DB Startup: 2014-09-04 21:51:14
*
-1
*** INFORMATION 5 *** DB SID: SBA
*
-1
*** INFORMATION 6 *** DB Environment: OLTP, ABAP stack, not R
AC, not ASM, not EXADATA *
-1
*** INFORMATION 7 *** DB Platform: Linux x86 64-bit
*
-1
*** INFORMATION 8 *** DB Patchset: 11.2.0.4.0
*
-1
*** INFORMATION 9 *** Last detectable SAP Bundle Patch: 2014-
08-10 (identified by bugno 18405517) *
-1
*** INFORMATION 10 *** Reliability checks: events passed, _fix
_controls passed *
-1
*** INFORMATION 11 *** - no further information -
*
-1
_ktb_debug_flags add with value "8"
1 f
avoid invalid index block SCNs on STDBY; note 2005311 N
8 B 1
optimizer_index_cost_adj add with value "20"
1 p
N 100
20 B 1
db_files add with value ">=39"
N 2
00 >=39
B 1
_enable_numa_support check if default value " " is suitable
(set optionally to TRUE after successful test) 2 p
N
set optionally to TRUE after successful test
E 1
local_listener check if default value "" is suitable (
set to (ADDRESS = (PROTOCOL=TCP) (HOST=[hostname]>) (PORT=[port]))) N
set to (ADDRESS = (PROTOCOL=TC
P) (HOST=[hostname]> E 1

) (PORT
=[port]))
use_large_pages check if default value "TRUE" is suitab
le (can be set according to note 1672954) N T
RUE can be set according to note 1
672954 E 1
control_files check if value "/oracle/SBA/sapdata1/cn
trl/cntrlSBA.dbf, ..." is suitable (three copies on different disk areas)
Y /
oracle/SBA/sapdata1/cntrl/cntrlSBA.dbf, ... three copies on different disk
areas F 1
db_cache_size check if value "234881024" is suitable
(appropriately set) Y 2
34881024 appropriately set
F 1
log_buffer check if value "1703936" is suitable (d
epends on number of CPUs; details in note 1627481) CPU_COUN
T=[CPU_COUNT] Y 1703936
depends on number of CPUs; details in note 1627481 F
1
remote_os_authent check if value "TRUE" is suitable (set
to TRUE on systems with a Unix App. Server without SSFS (note 1622837))
Y T
RUE set to TRUE on systems with a
Unix App. Server wit F 1

hout SS
FS (note 1622837)
_b_tree_bitmap_plans check why set but mentioned with other
prerequisites/not mentioned in note Y F
ALSE
G 1
_in_memory_undo check why set but mentioned with other
prerequisites/not mentioned in note Y F
ALSE
G 1
_index_join_enabled check why set but mentioned with other
prerequisites/not mentioned in note Y F
ALSE
G 1
_optimizer_mjc_enabled check why set but mentioned with other
prerequisites/not mentioned in note Y F
ALSE
G 1
_sort_elimination_cost_ratio check why set but mentioned with other
prerequisites/not mentioned in note Y 1
0
G 1
_table_lookup_prefetch_size check why set but mentioned with other
prerequisites/not mentioned in note Y 0

G 1
db_recovery_file_dest check why set but mentioned with other
prerequisites/not mentioned in note Y /
oracle/SBA/oraflash
G 1
db_recovery_file_dest_size check why set but mentioned with other
prerequisites/not mentioned in note Y 3
1457280000
G 1
remote_login_passwordfile check why set but mentioned with other
prerequisites/not mentioned in note Y E
XCLUSIVE
G 1
parallel_max_servers automatic check ok; doublecheck if defa
ult value "20" is suitable (Number of DB machine CPU CORES*10) Max used
(gv$resource_limit): 0 (0%); CPU_COUNT=2 N 20
Number of DB machine CPU CORES*10
H 1
undo_retention automatic check ok; doublecheck if defa
ult value "900" is suitable (appropriately set) Max unex
pired stolen blocks (gv$undostat): 0 N 900
appropriately set H 1
pga_aggregate_target automatic check ok; doublecheck if valu
e "354083143" is suitable (appropriately set) Max used
MB (gv$pgastat): 298 (88%) Y 354083143
appropriately set I 1
processes automatic check ok; doublecheck if valu
e "150" is suitable (formula how to set in parameter note) Max used
(gv$resource_limit): 49 (32%) Y 150
formula how to set in parameter note I
1
sessions automatic check ok; doublecheck if valu
e "260" is suitable (2*PROCESSES) Max used
(gv$resource_limit): 60 (23%); PROCESSES=150 Y 260
2*PROCESSES I 1
shared_pool_size automatic check ok; doublecheck if valu
e "494927872" is suitable (appropriately set; note 690241) current:
472 MB; calculated: 554 MB Y 494927872
appropriately set; note 690241
I 1
commit_logging ok (is not set; not to be set as explic
itly mentioned in note) 1 f
N
deleted from parameter file K 1
commit_wait ok (is not set; not to be set as explic
itly mentioned in note) 1 f
N
deleted from parameter file K 1
commit_write ok (is not set; not to be set as explic
itly mentioned in note) 1 f
N
deleted from parameter file K 1
db_file_multiblock_read_count ok (is not set; not to be set as explic
itly mentioned in note) 1 p
N 120
deleted from parameter file K 1
optimizer_dynamic_sampling ok (is not set; not to be set as explic
itly mentioned in note) 1 p
N 2
deleted from parameter file K 1
optimizer_features_enable ok (is not set; not to be set as explic
itly mentioned in note) 1 p
N 11.2.0.4
deleted from parameter file K 1
optimizer_mode ok (is not set; not to be set as explic
itly mentioned in note) 1 p
N ALL_ROWS
deleted from parameter file K 1
nls_length_semantics ok (is not set; not to be set as explic
itly mentioned in note) 2 f
N BYTE
deleted from parameter file K 1
optimizer_index_caching ok (is not set; not to be set as explic
itly mentioned in note) 2 p
est. % of index cached (inlist, nested loop) N 0
deleted from parameter file
K 1
background_dump_dest ok (is not set; not to be set as explic
itly mentioned in note) N /
oracle/SBA/saptrace/diag/rdbms/sba/SBA/trace deleted from parameter file
K 1
core_dump_dest ok (is not set; not to be set as explic
itly mentioned in note) N /
oracle/SBA/saptrace/diag/rdbms/sba/SBA/cdump deleted from parameter file
K 1
user_dump_dest ok (is not set; not to be set as explic
itly mentioned in note) N /
oracle/SBA/saptrace/diag/rdbms/sba/SBA/trace deleted from parameter file
K 1
compatible ok (is set correctly =)
1 f
Y 11.2.0
11.2.0 L 1
event (38087) ok (is set correctly =)
1 f
avoid ora-600 at star transformation Y 38087
38087 L 1
recyclebin ok (is set correctly =)
1 f
Y off
OFF L 1
_optim_peek_user_binds ok (is set correctly =)
1 p
avoid bind value peeking Y FALSE
FALSE L 1
event (10183) ok (is set correctly =)
1 p
avoid rounding during cost calculation Y 10183
10183 L 1
filesystemio_options ok (is set correctly =)
1 p
note 793113 Y setall
SETALL L 1
star_transformation_enabled ok (is set correctly =)
1 p
Y true
TRUE L 1
_fix_control (7168184) ok (is set correctly =)
2 f
avoid multi-column/bloom filter problems on comp. Tab. Y 7168184:OFF
7168184:OFF L 1
_fix_control (8937971) ok (is set correctly =)
2 f
correct clause definition dbms_metadata.get_ddl Y 8937971:O
N 8937971:ON L 1
event (10027) ok (is set correctly =)
2 f
avoid process state dump at deadlock Y 10027
10027 L 1
event (10028) ok (is set correctly =)
2 f
do not wait while writing deadlock trace Y 10028
10028 L 1
event (10191) ok (is set correctly =)
2 f
avoid high CBO memory consumption Y 10191
10191 L 1
event (10995) ok (is set correctly =)
2 f
avoid flush shared pool during online reorg Y 10995 lev
el 2 10995 level 2 L 1
_fix_control (13077335) ok (is set correctly =)
2 p
correct long varchar cardinality calculation with histgr Y 13077335:ON
13077335:ON L 1
_fix_control (13627489) ok (is set correctly =)
2 p
use good access for merge in dbms_redefinition Y 13627489:ON
13627489:ON L 1
_fix_control (14255600) ok (is set correctly =)
2 p
statistic collection during index creation Y 14255600:
ON 14255600:ON L 1
_fix_control (14595273) ok (is set correctly =)
2 p
Y 14595273:ON
14595273:ON L 1
_fix_control (18405517) ok (is set correctly =)
2 p
Y 18405517:2
18405517:2 L 1
_fix_control (5099019) ok (is set correctly =)
2 p
dbms_stats counts leaf blocks correctly Y 5099019:O
N 5099019:ON L 1
_fix_control (5705630) ok (is set correctly =)
2 p
use optimal OR concatenation; note 176754 Y 5705630:O
N 5705630:ON L 1
_fix_control (6055658) ok (is set correctly =)
2 p
calculate correct join card. with histograms Y 6055658:O
FF 6055658:OFF L 1
_fix_control (6120483) ok (is set correctly =)
2 p
Y 6120483:OFF
6120483:OFF L 1
_fix_control (6399597) ok (is set correctly =)
2 p
sort group by instead of hash group by; note 176754 Y 6399597:O
N 6399597:ON L 1
_fix_control (6430500) ok (is set correctly =)
2 p
avoid that unique index not chosen Y 6430500:O
N 6430500:ON L 1
_fix_control (6440977) ok (is set correctly =)
2 p
consider redundant predicates in join; note 981875 Y 6440977:O
N 6440977:ON L 1
_fix_control (6626018) ok (is set correctly =)
2 p
avoid to low filter costs; note 981875 Y 6626018:ON
6626018:ON L 1
_fix_control (6972291) ok (is set correctly =)
2 p
use column group selectivity with hgrm;note 1165319 Y 6972291:O
N 6972291:ON L 1
_fix_control (9196440) ok (is set correctly =)
2 p
fixes low distinct keys in index stats Y 9196440:ON
9196440:ON L 1
_fix_control (9495669) ok (is set correctly =)
2 p
disable histogram use for join cardinality Y 9495669:O
N 9495669:ON L 1
_mutex_wait_scheme ok (is set correctly =)
2 p
controls mutex spins/waits; note 1588876 Y 1
1 L 1
_mutex_wait_time ok (is set correctly =)
2 p
controls mutex spins/waits; note 1588876 Y 10
10 L 1
_optimizer_adaptive_cursor_sharing ok (is set correctly =)
2 p
Y FALSE
FALSE L 1
_optimizer_extended_cursor_sharing_rel ok (is set correctly =)
2 p
Y NONE
NONE L 1
_optimizer_use_feedback ok (is set correctly =)
2 p
avoid preference of index supporting inlist Y FALSE
FALSE L 1
_securefiles_concurrency_estimate ok (is set correctly =)
2 p
Avoids buffer busy waits (free list) during LOB inserts Y 50
50 L 1
event (10142) ok (is set correctly =)
2 p
avoid btree bitmap conversion plans Y 10142
10142 L 1
event (31991) ok (is set correctly =)
2 p
avoid too many recursive calls Y 31991
31991 L 1
event (38068) ok (is set correctly =)
2 p
long raw statistic; implement note 948197 Y 38068 lev
el 100 38068 level 100 L 1
event (38085) ok (is set correctly =)
2 p
consider cost adjust for index fast full scan Y 38085
38085 L 1
event (44951) ok (is set correctly =)
2 p
avoid HW enqueues during LOB inserts Y 44951 lev
el 1024 44951 level 1024 L 1
parallel_execution_message_size ok (is set correctly =)
2 p
Y 16384
16384 L 1
parallel_threads_per_cpu ok (is set correctly =)
2 p
Y 1
1 L 1
query_rewrite_enabled ok (is set correctly =)
2 p
Y false
FALSE L 1
_awr_mmon_deep_purge_all_expired ok (is set correctly =)
Y T
RUE TRUE
L 1
audit_file_dest ok (is set correctly =)
Y /
oracle/SBA/saptrace/audit /oracle/SBA/saptrace/audit
L 1
db_block_size ok (is set correctly =)
Y 8
192 8192
L 1
db_name ok (is set correctly =)
Y S
BA SBA
L 1
diagnostic_dest ok (is set correctly =)
Y /
oracle/SBA/saptrace /oracle/SBA/saptrace
L 1
log_archive_dest_1 ok (is set correctly =)
note 966
073 Y LOCATION=/oracle/
SBA/oraarch/SBAarch LOCATION=/oracle/SBA/oraarch/SBAarch
L 1
log_archive_format ok (is set correctly =)
Y %
t_%s_%r.dbf %t_%s_%r.dbf
L 1
log_checkpoints_to_alert ok (is set correctly =)
Y T
RUE TRUE
L 1
max_dump_file_size ok (is set correctly =)
Y 2
0000 20000
L 1
undo_tablespace ok (is set correctly =)
Y P
SAPUNDO PSAPUNDO
L 1
control_file_record_keep_time ok (is set correctly >=)
Y 3
0 >=30
M 1
open_cursors ok (is set correctly between)
Y 2
000 between 800 and 2000
N 1
replication_dependency_tracking ok (is set; any value recommended)
Y F
ALSE any value
O 1
_bug16850197_enable_fix_for_13602883 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_disable_cell_optimized_backups ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_fifth_spare_parameter ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_file_size_increase_increment ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_first_spare_parameter ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_fix_control (12693573) ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_fix_control (4728348) ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_gc_override_force_cr ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_ninth_spare_parameter ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_optimizer_use_cbqt_star_transformation ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_second_spare_parameter ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
_simple_view_merging ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
active_instance_count ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
aq_tm_processes ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1

Q 1
archive_lag_target ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
asm_diskgroups ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
asm_diskstring ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
asm_power_limit ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1

Q 1
asm_preferred_read_failure_groups ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
audit_sys_operations ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
audit_syslog_level ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
audit_trail ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N N
ONE
Q 1
awr_snapshot_time_offset ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
background_core_dump ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N p
artial
Q 1
backup_tape_io_slaves ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
bitmap_merge_area_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
048576
Q 1
blank_trimming ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
buffer_pool_keep ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
buffer_pool_recycle ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
cell_offload_compaction ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N A
DAPTIVE
Q 1
cell_offload_decryption ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
cell_offload_parameters ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
cell_offload_plan_display ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N A
UTO
Q 1
cell_offload_processing ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
cell_offloadgroup_name ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
circuits ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
client_result_cache_lag ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 3
000
Q 1
client_result_cache_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
clonedb ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
cluster_database ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
cluster_database_instances ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1

Q 1
cluster_interconnects ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
commit_point_strength ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1

Q 1
control_management_pack_access ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N D
IAGNOSTIC+TUNING
Q 1
cpu_count ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 2

Q 1
create_bitmap_area_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 8
388608
Q 1
create_stored_outlines ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
cursor_bind_capture_destination ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N m
emory+disk
Q 1
cursor_sharing ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N E
XACT
Q 1
cursor_space_for_time ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
db_16k_cache_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
db_2k_cache_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
db_32k_cache_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
db_4k_cache_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
db_8k_cache_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
db_block_buffers ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
db_block_checking ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
db_block_checksum ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
YPICAL
Q 1
db_cache_advice ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N O
N
Q 1
db_create_file_dest ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
db_create_online_log_dest_1 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
db_create_online_log_dest_2 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
db_create_online_log_dest_3 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
db_create_online_log_dest_4 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
db_create_online_log_dest_5 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
db_domain ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
db_file_name_convert ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
db_flash_cache_file ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
db_flash_cache_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
db_flashback_retention_target ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
440
Q 1
db_keep_cache_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
db_lost_write_protect ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N N
ONE
Q 1
db_recycle_cache_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
db_securefile ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N P
ERMITTED
Q 1
db_ultra_safe ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N O
FF
Q 1
db_unique_name ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N S
BA
Q 1
db_unrecoverable_scn_tracking ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
db_writer_processes ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1

Q 1
dbwr_io_slaves ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
ddl_lock_timeout ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
deferred_segment_creation ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
dg_broker_config_file1 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N /
oracle/SBA/112_64/dbs/dr1SBA.dat
Q 1
dg_broker_config_file2 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N /
oracle/SBA/112_64/dbs/dr2SBA.dat
Q 1
dg_broker_start ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
disk_asynch_io ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
dispatchers ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
distributed_lock_timeout ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 6
0
Q 1
dml_locks ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
144
Q 1
dnfs_batch_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 4
096
Q 1
dst_upgrade_insert_conv ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
enable_ddl_logging ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
enable_goldengate_replication ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
event (10198) ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
fal_client ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
fal_server ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
fast_start_io_target ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
fast_start_mttr_target ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
fast_start_parallel_rollback ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N L
OW
Q 1
file_mapping ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
fileio_network_adapters ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
fixed_date ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
gcs_server_processes ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
global_context_pool_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
global_names ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
global_txn_processes ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1

Q 1
hash_area_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
31072
Q 1
hi_shared_memory_address ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
hs_autoregister ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
ifile ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
instance_groups ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
instance_name ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N S
BA
Q 1
instance_number ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
instance_type ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N R
DBMS
Q 1
instant_restore ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
java_jit_enabled ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
java_max_sessionspace_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
java_pool_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 4
194304
Q 1
java_restrict ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N n
one
Q 1
java_soft_sessionspace_limit ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
job_queue_processes ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
000
Q 1
large_pool_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
ldap_directory_access ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N N
ONE
Q 1
ldap_directory_sysauth ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N n
o
Q 1
license_max_sessions ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
license_max_users ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
license_sessions_warning ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
listener_networks ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
lock_name_space ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
lock_sga ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
log_archive_config ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_10 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_11 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_12 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_13 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_14 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_15 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_16 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_17 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_18 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_19 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_2 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_20 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_21 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_22 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_23 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_24 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_25 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_26 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_27 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_28 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_29 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_3 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_30 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_31 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_4 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_5 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_6 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_7 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_8 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_9 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_dest_state_1 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_10 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_11 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_12 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_13 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_14 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_15 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_16 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_17 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_18 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_19 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_2 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_20 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_21 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_22 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_23 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_24 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_25 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_26 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_27 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_28 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_29 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_3 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_30 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_31 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_4 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_5 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_6 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_7 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_8 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_dest_state_9 ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
log_archive_duplex_dest ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
log_archive_local_first ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
log_archive_max_processes ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 4

Q 1
log_archive_min_succeed_dest ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1

Q 1
log_archive_start ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
log_archive_trace ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
log_checkpoint_interval ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
log_checkpoint_timeout ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
800
Q 1
log_file_name_convert ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
max_dispatchers ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
max_enabled_roles ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
50
Q 1
max_shared_servers ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
memory_max_target ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
memory_target ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
nls_nchar_conv_excp ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
o7_dictionary_accessibility ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
object_cache_max_size_percent ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
0
Q 1
object_cache_optimal_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
02400
Q 1
olap_page_pool_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
open_links ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 4

Q 1
open_links_per_instance ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 4

Q 1
optimizer_capture_sql_plan_baselines ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
optimizer_secure_view_merging ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
optimizer_use_invisible_indexes ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
optimizer_use_pending_statistics ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
optimizer_use_sql_plan_baselines ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
os_authent_prefix ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N o
ps$
Q 1
os_roles ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
parallel_adaptive_multi_user ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
parallel_automatic_tuning ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
parallel_degree_limit ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N C
PU
Q 1
parallel_degree_policy ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N M
ANUAL
Q 1
parallel_force_local ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
parallel_instance_group ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
parallel_io_cap_enabled ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
parallel_min_percent ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
parallel_min_servers ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
parallel_min_time_threshold ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N A
UTO
Q 1
parallel_server ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
parallel_server_instances ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1

Q 1
parallel_servers_target ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 8

Q 1
permit_92_wrap_format ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
plscope_settings ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N I
DENTIFIERS:NONE
Q 1
plsql_ccflags ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
plsql_code_type ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N I
NTERPRETED
Q 1
plsql_debug ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
plsql_optimize_level ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 2

Q 1
plsql_v2_compatibility ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
plsql_warnings ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N D
ISABLE:ALL
Q 1
pre_page_sga ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
processor_group_name ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
query_rewrite_integrity ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nforced
Q 1
rdbms_server_dn ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
read_only_open_delayed ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
recovery_parallelism ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
redo_transport_user ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
remote_dependencies_mode ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
IMESTAMP
Q 1
remote_listener ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
remote_os_roles ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
resource_limit ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
resource_manager_cpu_allocation ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 2

Q 1
resource_manager_plan ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N S
CHEDULER[0x318F]:DEFAULT_MAINTENANCE_PLAN
Q 1
result_cache_max_result ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 5

Q 1
result_cache_max_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 4
980736
Q 1
result_cache_mode ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N M
ANUAL
Q 1
result_cache_remote_expiration ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
resumable_timeout ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
rollback_segments ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
sec_case_sensitive_logon ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
sec_max_failed_login_attempts ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
0
Q 1
sec_protocol_error_further_action ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N C
ONTINUE
Q 1
sec_protocol_error_trace_action ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RACE
Q 1
sec_return_server_release_banner ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
serial_reuse ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N d
isable
Q 1
service_names ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N S
BA
Q 1
session_cached_cursors ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 5
0
Q 1
session_max_open_files ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 1
0
Q 1
sga_max_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 7
75946240
Q 1
sga_target ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
shadow_core_dump ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N p
artial
Q 1
shared_memory_address ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
shared_pool_reserved_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 2
4746393
Q 1
shared_server_sessions ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
shared_servers ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
skip_unusable_indexes ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
smtp_out_server ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
sort_area_retained_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
sort_area_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 6
5536
Q 1
spfile ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N /
oracle/SBA/112_64/dbs/spfileSBA.ora
Q 1
sql92_security ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
sql_trace ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
sqltune_category ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N D
EFAULT
Q 1
standby_archive_dest ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N ?
/dbs/arch
Q 1
standby_file_management ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N M
ANUAL
Q 1
statistics_level ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
YPICAL
Q 1
streams_pool_size ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
tape_asynch_io ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
thread ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
timed_os_statistics ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 0

Q 1
timed_statistics ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
trace_enabled ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N T
RUE
Q 1
tracefile_identifier ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
transactions ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 2
86
Q 1
transactions_per_rollback_segment ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N 5

Q 1
undo_management ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N A
UTO
Q 1
use_indirect_data_buffers ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N F
ALSE
Q 1
utl_file_dir ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N

Q 1
workarea_size_policy ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N A
UTO
Q 1
xml_db_events ok (is not set; mentioned with other pr
erequisites/not mentioned in note) N e
nable
Q 1
nls_calendar ok (ignored dynamically changed paramet
er) N G
REGORIAN
R 1
nls_comp ok (ignored dynamically changed paramet
er) N B
INARY
R 1
nls_currency ok (ignored dynamically changed paramet
er) N $

R 1
nls_date_format ok (ignored dynamically changed paramet
er) N D
D-MON-RR
R 1
nls_date_language ok (ignored dynamically changed paramet
er) N A
MERICAN
R 1
nls_dual_currency ok (ignored dynamically changed paramet
N $
nls_iso_currency ok (ignored dynamically changed paramet
N A
MERICA
nls_language ok (ignored dynamically changed paramet
N A
MERICAN
nls_numeric_characters ok (ignored dynamically changed paramet
N .
,
nls_sort ok (ignored dynamically changed paramet
N B
INARY
nls_territory ok (ignored dynamically changed paramet
N A
MERICA
nls_time_format ok (ignored dynamically changed paramet
N H
H.MI.SSXFF AM
nls_time_tz_format ok (ignored dynamically changed paramet
N H
H.MI.SSXFF AM TZR
nls_timestamp_format ok (ignored dynamically changed paramet
N D
D-MON-RR HH.MI.SSXFF AM
nls_timestamp_tz_format ok (ignored dynamically changed paramet
N D
D-MON-RR HH.MI.SSXFF AM TZR
420 rows selected.