ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS 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
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Creating and configuring the Production Mapping workspace in a geodatabase in Oracle

Available with Production Mapping license.

  • Creating an enterprise geodatabase

A geodatabase can be created in Oracle and configured to operate as an ArcGIS Production Mapping workspace that can be used in an enterprise environment.

Creating an enterprise geodatabase

The server administrator needs to create a new geodatabase in Oracle that can be used as the Production Mapping 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.

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

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

Oracle parameters

Related topics

  • Oracle initialization parameters
  • Update open_cursors setting in geodatabases in Oracle

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal