About the INUSER Database Schema (User) - Perceptive Content Database Install Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Install Guide

Platform
Perceptive Content
Product
Perceptive Content Database Install Guide
Release
Foundation 24.1
License
Note: For Perceptive Content 7.3.x, the expected database schema version is 7.2.3.

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;