resource_limit=true
RESOURCE_LIMIT” parameter is used to enable/disable “KERNEL” resource type profiles. Password parameters are part of profiles but they are controlled by this parameter. This parameter is a SYSTEM level parameter so it can be changed using “ALTER SYSTEM” and can be changed on the fly. Possible values are true/false and the default value is false.
Example: To set resource_limit
sys@TESTDB> alter system set resource_limit = true scope=both;
System altered.
Example: Creates a profile and sets one_session limit to 1 and assigned the profile to scott
scott@TESTDB> create profile one_session limit sessions_per_user 1;
Profile created.
Posted from: https://oraclespin.com/2011/05/01/information-on-resource_limit-parameter/
audit_trail=db
Posted from:https://docs.oracle.com/en/database/oracle/oracle-database/21/refrn/AUDIT_TRAIL.html#GUID-BD86F593-B606-4367-9FB6-8DAB2E47E7FA
audit_sys_operations=true
https://docs.oracle.com/en/database/oracle/oracle-database/21/refrn/AUDIT_SYS_OPERATIONS.html#GUID-58176267-238C-40B5-B1F2-BB8BB9518950
open_cursors= number
optimizer_mode=choose
Posted from: https://tipsfororacle.blogspot.com/search?q=optimizer
optimizer_index_cost_adj = number
optimizer_index_caching=number
OPTIMIZER_FEATURES_ENABLE
session_cached_cursors=200
Število prostora v predpomnilniku
compatible=19.x.x.x
max_dump_file_size=’10m’
Posted from: https://sqljana.wordpress.com/2017/01/24/oracle-undo-a-basic-explanation/