In Oracle, why does it take a long time to create feature dataset or feature class

117
8
07-10-2018 12:36 AM
Highlighted
New Contributor

In Oracle, why does it take a long time (around 30 Minutes)to create feature dataset or feature class.

Even to connect sde Geodatabase its take around 30 minutes ,

from same machine where Sys user take only few second to connect.

Check from sqlplus promote is connecting properly.

Software,

>ArcGIS Desktop and Server 10.6

>Oracle database 12C.

>Machine Window Server 2012.

Work has done,

>firewall off from Client and Server machine.

>Install  client for Oracle 12c 32 bit database on ArcGIS desktop Client machine.

Tags (1)
0 Kudos
8 Replies
Highlighted
Esteemed Contributor

What is the specific version of Oracle that you are working with?

0 Kudos
Highlighted
New Contributor

Oracle 12c.

0 Kudos
Highlighted
Esteemed Contributor

You need to be more specific than 12c.

Something like 12.1.0.1 or 12.1.0.4 or 12.2.0.1.

0 Kudos
Highlighted
New Contributor

Thanks for your reply,

Oracle database Version is 12c 12.2.0.1.,

0 Kudos
Highlighted
Esri Frequent Contributor

Did this behavior just begin?

How many tables are in the DB? Are there many user-schema GDB's?

--- George T.
0 Kudos
Highlighted
New Contributor

this is only a fresh database with No data.

Get Outlook for Android<https://aka.ms/ghei36>

0 Kudos
Highlighted
New Contributor

this is a fresh database with No data.

Only sde table is present.

0 Kudos
Highlighted
Esri Frequent Contributor

That sounds weird for an empty geodatabase.

You may want to get a technical support case opened so an analyst can take a look at this in more detail.

--- George T.
0 Kudos