topic Re: pctfree and tablespace in ArcGIS Enterprise Questions

pctfree and tablespace

jayasudha — Fri, 10 Oct 2014 12:08:02 GMT

Hello expert

What are the parameters to set pctfree and tablespace in dbtune table so that i can use this when feature class and index are created.

Thanks

Re: pctfree and tablespace

VinceAngelo — Fri, 10 Oct 2014 14:52:35 GMT

The answers depend on the nature of the data and how your database is configured. You'd need to at least make a statement about the nature of the table to be created (how many rows it will contain, how it will be edited, how often it will be edited, and how much will change or be added on a monthly basis) and the available tablespaces.

- V

PS: Please update your question to contain at least one tag, for the database involved; Editing the question to include that would be useful as well.

Re: pctfree and tablespace

jayasudha — Sun, 12 Oct 2014 06:18:50 GMT

Vince

Working with Oracle 11g, feature classes stored in Oracle spatial SDO_GEOMETRY, registered with ESRI geodatabase.

There are 20 feature classes in the schema, some feature classes contain rows several thousands and may reach million in future, some feature classes are limited to thousands.

All the rows deleted and new data is inserted in schema-1 by using geoprocessing tools once in a month.

New loaded data is updated based on requirement once in a month in schema-2 after copy from schema-1.

I want to store feature classes in one tablespace (TBS1) and indexes in another tablespace (TBS2).

I want to know the following.

(1) How to set PCTFREE, INITRANS, MAXTRANS by using SDEDBTUNE for both feature classes and indexes ?

(2) What values would be suitable or recommended ?

Thanks

Re: pctfree and tablespace

VinceAngelo — Mon, 13 Oct 2014 00:57:53 GMT

I have NEVER changed those default Oracle DBTUNE parameters without harming performance. I'd only change them if Oracle instructed you to do so.

- V

Re: pctfree and tablespace

jayasudha — Mon, 13 Oct 2014 10:16:43 GMT

Thanks Vince for your suggestion.

Please inform me how to change these parameters by using SDEDBTUNE if required in future.

For DEFAULT keyword, what parameters should be used to set the values.

Re: pctfree and tablespace

VinceAngelo — Mon, 13 Oct 2014 14:43:26 GMT

The best I can do is point you to the documentation. The default configuration parameters for any RDBMS can be found in the installation dbtune.sde file inside $SDEHOME/etc of the application server install.

- V