topic Re: ArcSDE DBTune Parameter in Geodatabase Questions

ArcSDE DBTune Parameter

appsapps — Wed, 03 Sep 2014 10:34:52 GMT

Please clarify on DBTune configuration

Configure SDE DBTune parameter with various Tablespaces for B-Table, AD, Index etc…
After import into SDE try to create a feature class
and try to verified that all tables and index are at right Tablespaces?
Everything at right place except Spatial Index
Oracle Enterprise Manager Console shows that - the Spatial Index for the above feature
class has been created in Default
Tablespace
But when I view the Index object script using TOAD it shows that the Tablespace is DEV_IDX_TBLSPC ( exactly same as DBTune Configuration)

Please refer the attached screenshot of (Oracle Console and TOAD)

What’s going wrong why the Index is not created in tablespace specified in DBTune Param?

Re: ArcSDE DBTune Parameter

VinceAngelo — Thu, 04 Sep 2014 00:34:15 GMT

You'll need to provide the contents of DBTUNE keywords, as loaded, for both the DEFAULTS keyword and whatever keyword you've specified --

sdedbtune -o list -k DEFAULTS ...

sdedbtune -o list -k WHATEVER ...

We'll also need the default tablespace for the user in question.

- V

Re: ArcSDE DBTune Parameter

appsapps — Thu, 04 Sep 2014 06:54:36 GMT

Hi V A ,

Thansk for your resposne

1) The keyword specified is DEFAULT (nothing else)

2) Attached dbtunedef.txt is the contents of DEFAULT @ DBTUNE params listed into text file

3) Default Tablepsace for this Schema GDB is configured as DEV_SDE

Please note that:

Our Configuration uses Multiple Schema GDB Model and configured such a way that

a) Master GDB manages configured with its own tablesapces ( In-fact all datasets resides in respective Schema GDB)

b) Every Schema GDB-SDE created in dedicated tablespaces , And also all data objects such as B-Table/Index/AD/etc created in dedicated tablespaces
(attached gdb.png is the config model used)

Hope this clears...

Re: ArcSDE DBTune Parameter

VinceAngelo — Thu, 04 Sep 2014 14:28:54 GMT

Did you register this DBTUNE with the user-schema geodatabase? What does the master

DBTUNE table have for the S_STORAGE and S_INDEX_ALL keys?

Have you applied the SP1 and QIP patches to your 10.1 install?

- V

Re: ArcSDE DBTune Parameter

appsapps — Fri, 05 Sep 2014 06:49:18 GMT

Yes the DBTUNES are registered/imported into respective GDB
Attached is the MASTER GDB TBTUNE listed - Attached <masterdbtune.txt> fyr

Master DBTUNE

S_INDEX_ALL "PCTFREE 0 INITRANS 4 TABLESPACE SDE_DATA_TBLSPC NOLOGGING "

S_STORAGE "PCTFREE 0 INITRANS 4 TABLESPACE SDE_DATA_TBLSPC "

Yes SP1 applied - attached is the log FYI

I don't see any QIP for ArcSDE 10.1 in below link;
http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/2103#install/

please help me if any other place i can find it ?

Re: ArcSDE DBTune Parameter

AsrujitSengupta — Fri, 05 Sep 2014 15:34:09 GMT

ArcGIS 10.1 SP1 for (Desktop, Engine, Server) Quality Improvement Patch | Samples and Utilities

Re: ArcSDE DBTune Parameter

appsapps — Wed, 01 Oct 2014 09:25:57 GMT

Very sorry for late response, just back to work from vacation...

The link you gave does not have QIP for ArcGIS Server? It got QIP for Desktop only;

However tried to install and end up with problem, For some reason it changes the IIS Settings and gave hard time to restore the site back.

But still the root problem not fixed yet;

Re: ArcSDE DBTune Parameter

VinceAngelo — Wed, 01 Oct 2014 11:15:53 GMT

I see both Desktop and Server patches, and instructions for Oracle and PostgreSQL geodatabase upgrades.

- V