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? sde_attach1.png Felix10546_1-1654153297658.png

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

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; Banner.png

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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcSDE DBTune Parameter

appsapps

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?

sde_attach1.png

Felix10546_1-1654153297658.png

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

VinceAngelo

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

appsapps

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...

gdb.png

dbtunedef.txt.zip

VinceAngelo

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

appsapps

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 ?

sdepatch.png

dbtunemaster.txt.zip

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.