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	CLUSTER_DATABASE	–
COMPATIBLE
CONTROL_FILES	CONTROL_FILES	–
DB_BLOCK_SIZE	DB_BLOCK_SIZE	2K – 32K
DB_CREATE_FILE_DEST	DB_CREATE_FILE_DEST	Static
DB_CREATE_ONLINE_LOG_DEST_n
DB_DOMAIN
DB_NAME	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	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
LOG_ARCHIVE_DEST_n	LOG_ARCHIVE_DEST LOG_ARCHIVE_DEST_1 – 9	9 available instead of 30 Only for local replication of archivelogs
LOG_ARCHIVE_DEST_STATE_n
NLS_DATE_LANGUAGE	NLS_DATE_LANGUAGE	Values = KOREAN \| AMERICAN \| JAPANESE \| VIETNAMESE \| BRAZILIAN PORTUGUESE \| TRADITIONAL CHINESE
NLS_TERRITORY	NLS_TERRITORY	64 characters max.
OPEN_CURSORS	OPEN_CURSORS	Range 10 – 1000 != 65535
PGA_AGGREGATE_TARGET	WTHR_PROC_CNT WTHR_PROC_CNT_MAX	Range 1 – 10000 PGA works very different to Working Threads in Tibero
PROCESSES	MAX_SESSION_COUNT	Check Description
REMOTE_LISTENER	Achievable with:LISTENER_IP LISTENER_PORT
REMOTE_LOGIN_PASSWORDFILE	It is different. SYSDBA users have a exclusive administrative PORT.
SESSIONS	It is different. Handled as Working Threads (WTHR)
SGA_TARGET	TOTAL_SHM_SIZE + TOTAL_SHM_MAX_SIZE + MEMORY_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	STAR_TRANSFORMATION_ENABLED
UNDO_TABLESPACE	UNDO_TABLESPACE
THREADED_EXECUTION	Tibero has thread arquitecture by default.
THREAD (Def=0)	THREAD	0 is often the first number to be used.
CONTROL_MANAGEMENT_PACK_ACCESS	TIBERO_PERFORMANCE_REPOSITORY	Default: Yes
ALTER DATABASE SET DEFAULT TEMPORARY TABLESPACE	TEMP_TABLESPACE
–	CURRENT_SESSION_TEMP_TS	Easy to use
RECYCLEBIN	USE_RECYCLEBIN
–	ACTIVE_SESSION_HISTORY	~= ASH, Default = N
ASM_DISKSTRING	AS_DISKSTRING (specify at AS type Instance)	DISK_PATH
ASM_DISKGROUPS	Tibero mounts all disk spaces (~=diskgroups) available automatically.
ASM_POWER_LIMIT (Def: 1) ASM_IO_PROCESSES (Increases Perf.)	AS_WTHR_CNT (Def: 10)	It spawns processes automatically when required.
AUDIT_FILE_DEST	AUDIT_FILE_DEST
AUDIT_SYS_OPERATIONS	AUDIT_SYS_OPERATIONS
CURSOR_BIND_CAPTURE_DESTINATION	BIND_VARIABLE_CAPTURE	Tibero has several parameters available for tuning.
ALTER SYSTEM statement	BLOCK_CHANGE_TRACKING + 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_CATH_CNT CCC_MASTERING_UNIT CCC_RECL_MAX_RESOURCES CCC_RSBTBL_SIZE CWS_RECL_MAX_RESOURCES CWS_RSBTBL_SIZE	CCC (Cluster Cache Control)
–	CM_ENABLE_FAST_NET_ERROR_DETECTION CM_FENCE CM_GUARD_LOG_DEST CM_HEARTBEAT_EXPIRE CM_LOG_DEST CM_LOG_FILE_SIZE CM_LOG_TOTAL_SIZE_LIMIT CM_NAME CM_NET_EXPIRE_MARGIN CM_PORT CM_RESOURCE_FILE CM_RESOURCE_FILE_BACKUP CM_RESOURCE_FILE_BACKUP_INTERVAL CM_TIME_UNIT CM_UI_PORT CM_WATCHDOG_EXPIRE	Cluster Manager Parameters
Columnar Compression (CC) Only available on Exadata or ZetaData configuration	CC_CU_BLKCNT CC_CU_PCTUSE CC_EXPECTED_RATE CC_TYPICAL_ROW_SIZE	Allows you to defined the Compresion Unit and tune Columnar Compression behaviour
CPU_COUNT	CPU_COUNT
CREATE_STORED_OUTLINES	CREATE_STORED_OUTLINES
CREATE_STORED_OUTLINES	CREATE_STORED_OUTLINES
DIAGNOSTIC_DEST	DBMS_LOG_DEST
~= Similar to ADRCI retention	DBMS_LOG_FILE_SIZE Max. size per log file. DBMS_LOG_TOTAL_SIZE_LIMIT Performs Log Rotation	Easier to define this 2 important variables for log management
DB_WRITER_PROCESSES Formula in Oracle: `1` or `CPU_COUNT` / 8	DBWR_CNT 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	DB_CACHE_SIZE Formula: CLUSTER_DATABASE ? TB_CEIL(TOTAL_SHM_SIZE * 1 / 2, 1) : TB_CEIL(TOTAL_SHM_SIZE * 2 / 3, 1)	Formula is different for Single-Instance than HA configuration:
DB_FILE_MULTIBLOCK_READ_COUNT	DB_FILE_MULTIBLOCK_READ_COUNT Formula: MAX(1, MIN( DB_CACHE_SIZE / DB_BLOCK_SIZE / _DB_BLOCK_LRU_LATCHES * _DB_BLOCK_MAX_SCAN_PCT / 100 / 2, 64))
DB_KEEP_CACHE_SIZE	DB_KEEP_CACHE_SIZE
DB_RECYCLE_CACHE_SIZE	DB_RECYCLE_CACHE_SIZE Formula: DB_CACHE_SIZE * _CACHE_BATCH_AREA_PCT / 100.0
Definable only per sequence, not globally	DEFAULT_SEQ_CACHE_SIZE	Helps handling global setup for sequences at once
	DPL_INDEX_METHOD	Interesting description
Specifiable at sqlnet.ora file	ENCRYPTION_WALLET_FILE
Modify listener.ora and restart listener	EXTRA_LISTENER_PORTS	Add extra ports for the database listener
PGA_AGGREGATE_LIMIT PGA_AGGREGATE_TARGET	EX_MEMORY_AUTO_MANAGEMENT EX_MEMORY_COMPENSATE_INTERVAL EX_MEMORY_DRIFT_CHECK_INTERVAL EX_MEMORY_DRIFT_RATIO	Fine-tune PGA auto-sizing
–	FLASHBACK_BUFFER_RATIO FLASHBACK_LOG_ARCHIVE_FORMAT	Tune Flashback buffer pool and logs format
STATISTICS_LEVEL = ALL + TIMED_OS_STATISTICS + TIMED_STATISTICS	GATHER_SQL_EXEC_TIME GATHER_SQL_PLAN_STAT	Similar
RESULT_CACHE_MAX_RESULT RESULT_CACHE_MAX_SIZE RESULT_CACHE_MODE	RESULT_CACHE_MAX_RATIO RESULT_CACHE_MAX_SIZE RESULT_CACHE_MODE
INSTANCE_TYPE	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	JAVA_CLASS_PATH Default if not specified: DB_CREATE_FILE_DEST/java	Static
Definable at listener.ora	IP_VERSION
Managed by system views + tracing tools	JOB_HISTORY_LOG JOB_TRACE_LOG	Easier
–	~~LIBRARY_CACHE_MAX~~ LIBRARY_DD_CACHE_MAX	Automatically adjusted.
Configured at Clusterware + oifcfg tool	LOCAL_CLUSTER_ADDR LOCAL_CLUSTER_IP_VERSION LOCAL_CLUSTER_PORT	Easy
LOG_BUFFER (Def: 2MB – 32 MB)	LOG_BUFFER (Def: 10MB – X)	(DB_BLOCK_SIZE) * 4 – 1G
LOG_CHECKPOINT_INTERVAL LOG_CHECKPOINT_TIMEOUT LOG_CHECKPOINTS_TO_ALERT	LOG_CHECKPOINT_INTERVAL LOG_CHECKPOINT_TIMEOUT	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: LOG_LVL_AS LOG_LVL_CM
ALTER DATABASE \| dgmgrl	LOG_REPLICATION_MODE	Easy
PARALLEL_MIN_TIME_THRESHOLD (Default: 10 sec)	LONGOPS_KEEP_INTERVAL LONGOPS_THRESHOLD_SEC
This is managed between: listener.ora sqlnet.ora Requires manual workaround to rotate the listener. DIAG_ADR_ENABLED<_listener_name> <ON \| OFF>	LSNR_DENIED_IP LSNR_DENIED_IP_FILE LSNR_INVITED_IP As well to add “invited IPs” in form of a file list. LSNR_INVITED_IP_FILE LSNR_LISTEN_BACKLOG LSNR_LOG_DEST Allows you to move listener log location very easy. LSNR_LOG_FILE_SIZE LSNR_LOG_TOTAL_SIZE_LIMIT =Useful
MEMORY_MAX_TARGET MEMORY_TARGET	MEMORY_MAX_TARGET MEMORY_TARGET
`NLS_CALENDAR` `NLS_COMP` `NLS_CURRENCY` `NLS_DATE_FORMAT` `NLS_DATE_LANGUAGE` ~~`NLS_DUAL_CURRENCY`~~ `NLS_ISO_CURRENCY` `NLS_LANGUAGE` `NLS_LENGTH_SEMANTICS` ~~`NLS_NCHAR_CONV_EXCP`~~ `NLS_NUMERIC_CHARACTERS` `NLS_SORT` `NLS_TERRITORY` `NLS_TIMESTAMP_FORMAT` `NLS_TIMESTAMP_TZ_FORMAT`	NLS_CALENDAR NLS_COMP NLS_CURRENCY NLS_DATE_FORMAT NLS_DATE_LANGUAGE NLS_ISO_CURRENCY NLS_LANGUAGE NLS_LANG_AT_BOOT NLS_LENGTH_SEMANTICS NLS_NUMERIC_CHARACTERS NLS_SORT NLS_TERRITORY NLS_TIMESTAMP_FORMAT NLS_TIMESTAMP_TZ_FORMAT NLS_TIME_FORMAT
OPTIMIZER_MODE	OPTIMIZER_MODE
OPTIMIZER_USE_INVISIBLE_INDEXES	OPTIMIZER_USE_INVISIBLE_INDEXES
OS_AUTHENT_PREFIX (Def: OPS$)	OS_AUTH_PREFIX (Def: OSA$)
PARALLEL_SERVERS_TARGET – PARALLEL_MAX_SERVERS	PARALLEL_DEFAULT_DOP (Def: 4) + PEP_PROC_CNT (Def: 4)	Easy
PARALLEL_EXECUTION_MESSAGE_SIZE	PARALLEL_GRANULE_SIZE	Different, in bytes for Oracle, in number of blocks (granule) for Tibero
PARALLEL_THREADS_PER_CPU (Def: 2)	PARALLEL_THREADS_PER_CPU
PLSQL_DEBUG (Deprecated)	PSM_DEBUG
RESULT_CACHE_MAX_RESULT RESULT_CACHE_MAX_SIZE RESULT_CACHE_MODE RESULT_CACHE_REMOTE_EXPIRATION	PSM_SQL_RESULT_CACHE (Default: Y) RESULT_CACHE_MAX_RATIO RESULT_CACHE_MAX_SIZE TOTAL_SHM_SIZE / 100 RESULT_CACHE_MODE
QUERY_REWRITE_ENABLED QUERY_REWRITE_INTEGRITY { enforced \| trusted \| stale_tolerated }	QUERY_REWRITE_ENABLED QUERY_REWRITE_INTEGRITY 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)	RESUMABLE_SPACE_ALLOC RESUMABLE_SPACE_ALLOC_TIMEOUT
DB_RECOVERY_FILE_DEST DB_RECOVERY_FILE_DEST_SIZE	RMGR_BACKUP_DEST RMGR_TAR_PATH	It must be specified as an absolute path outside active storage.
MAX_IDLE_TIME RESOURCE_LIMIT RESOURCE_MANAGER_CPU_ALLOCATION RESOURCE_MANAGER_PLAN	USE_RESOURCE_MANAGER = ACTIVE_SESSION_TIMEOUT (Def: 0 seconds – disabled) RSRC_CHECK_INTERVAL (Def: 3 seconds) RSRC_CONTROL_THRESHOLD (Def: 90% of system resources) + DBMS_RESOURCE_MANAGER PSM Package + system views V$SESSION V$RSRC_PLAN V$RSRC_CONSUMER_GROUPS V$RSRC_SESSION_INFO 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_LOAD_TOLERANCE (5) SERVER_SIDE_LOAD_BALANCE (NONE \| SHORT \| LONG)	Definable at Instance Level.
spfile resides on ASM	SHARED_PARAMETER_FILE
Log rotation only manual, trace files through ADRCI retention values ~= BACKGROUND_DUMP_DEST + Rotation	SLOG_DEST SLOG_FILE_SIZE (100K – 1G in bytes) SLOG_TOTAL_SIZE_LIMIT (SLOG + Trace files)
SORT_AREA_RETAINED_SIZE SORT_AREA_SIZE (Def: 64K)	SORT_AREA_SIZE Formula: (MEMORY_TARGET – TOTAL_SHM_SIZE) * 0.3	Improved: Depends on Instance size
Definable at listener.ora as per listener	TCP_RCVBUF_SIZE TCP_SNDBUF_SIZE

SQL_TRACE	SQL_TRACE SQL_TRACE_DEST
DBMS_SQL_TRANSLATOR	DBMS_SQL_TRANSLATOR + session adjustable parameter SQL_TRANSLATION_PROFILE
DB_FILE_NAME_CONVERT LOG_FILE_NAME_CONVERT + STANDBY_FILE_MANAGEMENT	STANDBY_FILE_NAME_CONVERT + Standby file management is AUTO by default
–	TPR_AGGREGATION
STATISTICS_LEVEL	TPR_METRIC
HEAT_MAP	TPR_SEGMENT_STATISTICS
dbms_workload_repository. modify_snapshot_settings (retention=>64800,- interval=>60,- topnsql=>100,- bid=>1992878807);	TPR_SNAPSHOT_RETENTION TPR_SNAPSHOT_SAMPLING_INTERVAL TPR_SNAPSHOT_TOP_SEGMENT_CNT TPR_SNAPSHOT_TOP_SQL_CNT	Easy
CORE_DUMP_DEST	TRACE_DUMP_DEST TRACE_LOG_DEST TRACE_LOG_DISPLAY_YEAR TRACE_LOG_FILE_SIZE TRACE_LOG_FILE_TRUNC TRACE_LOG_TOTAL_SIZE_LIMIT
CREATE_STORED_OUTLINES	USE_STORED_OUTLINES
At sqlnet.ora	USE_NET_KEEPALIVE
UTL_FILE_DIR	UTL_FILE_DIR (Def: PSM_SHLIB_DIR => Def: DB_CREATE_FILE_DEST/psm)
By privileges only	USE_TRUNCATE_PRIVILEGE	Security
	USE_TS_QUOTA
Undo Auto Shrink Interval not configurable through public parameters	USGMT_AUTO_SHRINK_INTERVAL (Def: 0)