Oracle: automatic indexing

Enabling automatic indexing

begin
   dbms_auto_index.configure('AUTO_INDEX_MODE', 'IMPLEMENT');
end;
/

In 21c, the init parameter optimizer_session_type can be set to ADHOC in a session to suspend automatic indexing for queries that are executed from this session.