Comparison between Oracle and Tibero Initialization Parameters
- True/False values are (Y/N) in most cases for Tibero, in few cases it is True/False as well.
- Most parameters that you expect to have in the “sqlnet.ora” file in Oracle, in Tibero they are parameters.
CLUSTER_DATABASE | ![]() |
– |
COMPATIBLE | ![]() |
|
CONTROL_FILES | ![]() |
– |
DB_BLOCK_SIZE | ![]() |
2K – 32K |
DB_CREATE_FILE_DEST | ![]() |
Static |
DB_CREATE_ONLINE_LOG_DEST_n | ![]() |
|
DB_DOMAIN | ![]() |
|
DB_NAME | ![]() |
40 Characters, it must match the TIP file = $TB_SID.tip file |
DB_RECOVERY_FILE_DEST | ![]() |
|
DB_RECOVERY_FILE_DEST_SIZE | ![]() |
|
DB_UNIQUE_NAME | ![]() |
|
INSTANCE_NUMBER | ![]() |
Default value = THREAD It is often configured at 0 in Tibero for the first instance. |
LDAP_DIRECTORY_SYSAUTH | ![]() |
It is configured differently |
LOG_ARCHIVE_DEST | ![]() |
|
LOG_ARCHIVE_DEST_n | 9 available instead of 30 Only for local replication of archivelogs | |
LOG_ARCHIVE_DEST_STATE_n | ![]() |
|
NLS_DATE_LANGUAGE | ![]() |
Values = KOREAN | AMERICAN | JAPANESE | VIETNAMESE | BRAZILIAN PORTUGUESE | TRADITIONAL CHINESE |
NLS_TERRITORY | ![]() |
64 characters max. |
OPEN_CURSORS | ![]() |
Range 10 – 1000 != 65535 |
PGA_AGGREGATE_TARGET | Range 1 – 10000 PGA works very different to Working Threads in Tibero | |
PROCESSES | ![]() |
Check Description |
REMOTE_LISTENER | ![]() |
|
REMOTE_LOGIN_PASSWORDFILE | ![]() |
|
SESSIONS | ![]() |
|
SGA_TARGET |
|
Different, ASSM in Oracle is the default in Tibero, AMM Oracle is default in Tibero and therefore possible configuration at the same time to get the maximum in-memory flexibility. |
SHARED_SERVERS | ![]() |
Available in Tibero 7 |
STAR_TRANSFORMATION_ENABLED | ![]() |
|
UNDO_TABLESPACE | ![]() |
|
THREADED_EXECUTION | ![]() |
|
THREAD (Def=0) | ![]() |
0 is often the first number to be used. |
CONTROL_MANAGEMENT_PACK_ACCESS | ![]() |
Default: Yes |
ALTER DATABASE SET DEFAULT TEMPORARY TABLESPACE | ![]() |
|
– | ![]() |
Easy to use |
RECYCLEBIN | ![]() |
|
– | ![]() |
~= ASH, Default = N |
ASM_DISKSTRING | ![]() |
DISK_PATH |
ASM_DISKGROUPS | ![]() |
|
ASM_POWER_LIMIT (Def: 1) ASM_IO_PROCESSES (Increases Perf.) | ![]() ![]() |
It spawns processes automatically when required. |
AUDIT_FILE_DEST | ![]() |
|
AUDIT_SYS_OPERATIONS | ![]() |
|
CURSOR_BIND_CAPTURE_DESTINATION | ![]() |
Tibero has several parameters available for tuning. |
ALTER SYSTEM statement |
+ ALTER SYSTEM … ENABLE/DISABLE; (without location) |
|
Cache Fusion is tunable at Clusterware level, as Tibero DB has Cluster Mgmt Software embedded, these are the parameters to tune. |
|
CCC (Cluster Cache Control) |
– |
|
Cluster Manager Parameters |
Columnar Compression (CC) Only available on Exadata or ZetaData configuration |
Allows you to defined the Compresion Unit and tune Columnar Compression behaviour | |
CPU_COUNT | ![]() |
|
CREATE_STORED_OUTLINES | ![]() |
|
CREATE_STORED_OUTLINES | ![]() |
|
DIAGNOSTIC_DEST | ![]() |
|
~= Similar to ADRCI retention |
Max. size per log file. Performs Log Rotation |
Easier to define this 2 important variables for log management |
DB_WRITER_PROCESSES Formula in Oracle: 1 or CPU_COUNT / 8 |
Formula in Tibero: DBWR_USE_AIO ? 1 : MAX(1, get_ncpu()/4) |
Tibero uses more DBWR processes when having more than 8 cores available. |
DB_CACHE_SIZE |
Formula: |
Formula is different for Single-Instance than HA configuration: |
DB_FILE_MULTIBLOCK_READ_COUNT |
DB_FILE_MULTIBLOCK_READ_COUNT Formula: MAX(1, MIN( / 100 / 2, 64)) |
|
DB_KEEP_CACHE_SIZE | ![]() |
|
DB_RECYCLE_CACHE_SIZE |
Formula: * _CACHE_BATCH_AREA_PCT / 100.0 |
|
Definable only per sequence, not globally | Helps handling global setup for sequences at once | |
![]() |
Interesting description | |
Specifiable at sqlnet.ora file | ![]() |
|
Modify listener.ora and restart listener | ![]() |
Add extra ports for the database listener |
Fine-tune PGA auto-sizing | ||
– | Tune Flashback buffer pool and logs format | |
STATISTICS_LEVEL = ALL + TIMED_OS_STATISTICS + TIMED_STATISTICS | Similar | |
INSTANCE_TYPE |
Values: TIBERO | AS | ACTIVE_STORAGE | SSVR |
Tibero = Regular DB Instance AS | ACTIVE_STORAGE = For TAS type deployment ~= ASM SSVR = Storage Server deployment type = ZetaData |
Only definable at OS Level |
Default if not specified: DB_CREATE_FILE_DEST/java |
Static |
Definable at listener.ora | ![]() |
|
Managed by system views + tracing tools | Easier | |
– | Automatically adjusted. | |
Configured at Clusterware + oifcfg tool | Easy | |
LOG_BUFFER (Def: 2MB – 32 MB) | ![]() |
(DB_BLOCK_SIZE) * 4 – 1G |
Same default values | ||
lsnrctl set <listener_name> LSNRCTL> SET TRC_LEVEL level (off | user | admin | support)
|
LOG_LVL_LIS (Def: 2) Values range: 1 – 6 |
Also available: |
ALTER DATABASE | dgmgrl | ![]() |
Easy |
PARALLEL_MIN_TIME_THRESHOLD (Default: 10 sec) |
||
This is managed between:
|
As well to add “invited IPs” in form of a file list. Allows you to move listener log location very easy. =Useful |
|
MEMORY_MAX_TARGET MEMORY_TARGET | ![]() |
|
|
||
OPTIMIZER_MODE | ![]() |
|
OPTIMIZER_USE_INVISIBLE_INDEXES | ![]() |
|
OS_AUTHENT_PREFIX (Def: OPS$) | ![]() |
|
PARALLEL_SERVERS_TARGET – PARALLEL_MAX_SERVERS | ![]() |
Easy |
PARALLEL_EXECUTION_MESSAGE_SIZE | ![]() |
Different, in bytes for Oracle, in number of blocks (granule) for Tibero |
PARALLEL_THREADS_PER_CPU (Def: 2) | ![]() |
|
PLSQL_DEBUG (Deprecated) | ![]() |
|
(Default: Y) TOTAL_SHM_SIZE / 100 |
||
{ enforced | trusted | stale_tolerated } |
STALE_TOLERATED | ENFORCED |
|
FAST_START_PARALLEL_ROLLBACK regards to transactions recovery Instance recovery is done by 1 instance in RAC configurations |
RECO_PROC_WTHR_CNT (Def: 16) |
|
RESUMABLE_TIMEOUT (Def: 0 = disabled) | ||
It must be specified as an absolute path outside active storage. | ||
V$SESSION DBA_RSRC_AUDIT DBA_RSRC_PLANS DBA_RSRC_CONSUMER_GROUPS DBA_RSRC_PLAN_DIRECTIVES |
||
Different, configured as privileges per user. |
SEPARATION_OF_DUTIES (Def: N) Y = Creates SYSADM, SYSSEC and SYSAUD users at db creation time. SYS account becomes locked and cannot be unlocked. |
Increased security. More hard configuration. Read description |
Using srvctl, only, as per service. srvctl modify service -d db_unique_name \ -s batchconn -j LONG srvctl modify service -d db_unique_name \ -s oltpapp -j SHORT
|
SERVER_SIDE_LOAD_BALANCE (NONE | SHORT | LONG) |
Definable at Instance Level. |
spfile resides on ASM | ![]() |
|
Log rotation only manual, trace files through ADRCI retention values ~= BACKGROUND_DUMP_DEST + Rotation |
(100K – 1G in bytes) (SLOG + Trace files) |
|
(Def: 64K) |
Formula: (MEMORY_TARGET – TOTAL_SHM_SIZE) * 0.3 |
Improved: Depends on Instance size |
Definable at listener.ora as per listener | ||
SQL_TRACE | ![]() |
|
DBMS_SQL_TRANSLATOR | ![]() ![]() |
|
+ Standby file management is AUTO by default |
||
– | ![]() |
|
STATISTICS_LEVEL | ![]() |
|
HEAT_MAP | ![]() |
|
dbms_workload_repository. modify_snapshot_settings (retention=>64800,- interval=>60,- topnsql=>100,- bid=>1992878807); |
Easy | |
CORE_DUMP_DEST | ||
CREATE_STORED_OUTLINES | ![]() ![]() |
|
At sqlnet.ora | ![]() |
|
UTL_FILE_DIR |
(Def: PSM_SHLIB_DIR => Def: DB_CREATE_FILE_DEST/psm) |
|
By privileges only | ![]() |
Security |
![]() |
||
Undo Auto Shrink Interval not configurable through public parameters | ![]() |