ArcSDE DBTune Parameter

890
7
09-03-2014 03:34 AM
Highlighted
New Contributor II

Please clarify on DBTune configuration

  1. Configure SDE DBTune  parameter with various Tablespaces for  B-Table, AD, Index etc…
  2. After import into SDE try to create a feature class
    and try to verified that all tables and index are at right Tablespaces?
  3. Everything at right place except Spatial Index
  4. Oracle Enterprise Manager Console  shows that - the Spatial Index for the above feature
    class has been created in Default
    Tablespace
  5. 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?

Tags (2)
Reply
0 Kudos
7 Replies
Highlighted
Esri Esteemed Contributor

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

Reply
0 Kudos
Highlighted
New Contributor II

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

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

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

Reply
0 Kudos
Highlighted
New Contributor II
  • 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 ?

Reply
0 Kudos
Highlighted
Regular Contributor III
Reply
0 Kudos
Highlighted
New Contributor II

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;

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

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

- V

Reply
0 Kudos