topic Re: In Oracle, why does it take a long time to create feature dataset or feature class in Geodatabase Questions

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

VinodBorkar1 — Tue, 10 Jul 2018 07:36:43 GMT

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.

MichaelVolz — Tue, 10 Jul 2018 12:30:56 GMT

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

VinodBorkar1 — Tue, 10 Jul 2018 12:33:01 GMT

Oracle 12c.

MichaelVolz — Tue, 10 Jul 2018 12:42:24 GMT

You need to be more specific than 12c.

Something like 12.1.0.1 or 12.1.0.4 or 12.2.0.1.

VinodBorkar1 — Tue, 10 Jul 2018 12:49:14 GMT

Thanks for your reply,

Oracle database Version is 12c 12.2.0.1.,

George_Thompson — Tue, 10 Jul 2018 13:16:50 GMT

Did this behavior just begin?

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

VinodBorkar1 — Tue, 10 Jul 2018 13:27:57 GMT

this is only a fresh database with No data.

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

VinodBorkar1 — Wed, 11 Jul 2018 03:45:00 GMT

this is a fresh database with No data.

Only sde table is present.

George_Thompson — Wed, 11 Jul 2018 10:38:59 GMT

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.