Creating and configuring the Workflow Manager (Classic) workspace in a geodatabase in Oracle

Available with Workflow Manager license.

The server administrator needs to create a new geodatabase in Oracle that can be used as the Workflow Manager (Classic) workspace.

For more information, see Create a geodatabase in Oracle.

Recommendations for geodatabases in Oracle

It is recommended that the following parameter values be used when creating a geodatabase in Oracle.

Oracle parameters

Parameter name	Value
Configure with Database Enterprise Manager	Enabled
Automatic Memory Management	Enabled
Database Components	Oracle Text
OPEN_CURSORS	10000
SESSION_CACHED_CURSORS	50–150
DEFERRED_SEGMENT_CREATION	False
RESOURCE_LIMIT	True
ALTER PROFILE "DEFAULT" LIMIT IDLE_TIME 60 Note: When working with very large datasets, you may need to increase the IDLE_TIME to "UNLIMITED". PASSWORD_LIFE_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED	Set Default profile for data owner users
RECYCLEBIN	Off