The INUSER database user is the user that owns all of the Perceptive Content database objects. This is the same user that Perceptive Content uses to connect to the INOW database.
The Perceptive Content database utilizes the NLS_COMP=LINGUISTIC and NLS_SORT=BINARY_CI parameters to implement case-insensitive searching,sorting and uniqueness within the database. This requires function-based indexes using the NLSSORT function to facilitate efficient index usage. TheSunflowerORA.sql script will create all the necessary indexes.
The Perceptive Content Application Server will execute the following alter session commands for all database connections established by each of the service/agent connections pools.
ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'RRRR-MM-DD HH24:MI:SS.FF';
ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS.FF';
ALTER SESSION SET NLS_DATE_FORMAT = 'RRRR-MM-DD';
ALTER SESSION SET NLS_COMP=LINGUISTIC;
ALTER SESSION SET NLS_SORT=BINARY_CI;
ALTER SESSION SET OPTIMIZER_MODE = ALL_ROWS;
ALTER SESSION SET QUERY_REWRITE_INTEGRITY = TRUSTED;
ALTER SESSION SET QUERY_REWRITE_ENABLED = TRUE;
ALTER SESSION SET CURSOR_SHARING = EXACT;
ALTER SESSION SET OPTIMIZER_INDEX_COST_ADJ = 1;