1.194 MAIN_WORKLOAD_TYPE

MAIN_WORKLOAD_TYPE specifies the main workload type for a database or PDB.

Property	Description
Parameter type	String
Syntax	MAIN_WORKLOAD_TYPE = { OLTP | ANALYTICS }
Default value	OLTP
Modifiable	ALTER SYSTEM
Modifiable in a PDB	Yes
Basic	No
Oracle RAC	Different instances can use different values.

This parameter is supported only for Oracle Exadata. See Oracle Exadata System Software User's Guide for more information about setting this parameter