ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Creating and configuring the Workflow Manager workspace in a geodatabase in Oracle

Available with Workflow Manager license.

  • Recommendations for geodatabases in Oracle

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

For more information, see Set up 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.

Parameter nameValue

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

PASSWORD_LIFE_TIME UNLIMITED

PASSWORD_GRACE_TIME UNLIMITED

Set Default profile for data owner users

RECYCLEBIN

Off

Oracle parameters
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal