Oracle: Scopes of the CURSOR_SHARING parameter In Oracle databases (12.2 and above), is it possible to configure the CURSOR_SHARING parameter differently for different schemas, tables or views, or is that parameter always global?
You can create LOGON TRIGGER ON SCHEMA and use
execute immediate 'alter session set CURSOR_SHARING=...';

to set it on session level