Re: Storage Parameters defined on tablespaces

It is better to have an optimal default storage parameters set at the Tablespace level to capture any unmentioned parameters at the Table level..

But as a DBA, you should always estimate the Sizes of Tables,Indexes,Rollback Segments and specify at the Object level rather than defaulting to the Tablespace parameters..

For every Database that goes into Production, Have a meeting with the Project leaders,Developers and SysAdmins to discuss various Sizing and Growth Issues and Tune it accordingly to avoid any future Head aches ...

-Thiru

sh wrote:

> A quick question in regards to tablesapce storage parameters.
> Is it not "best practice" to define storage parameters at the tablespace
> level, particularly when a developer does not do so at the table level?
> We have a new database going into production soon, and I am identifying
> the storage parameters based upon table sizes seen on the development
> machine.
>
> I know that some smaller tables could take up the same storage parameter
> of a larger table because of this, but it seems better than leaving the
> storage parms at
> the default.
>
> thanks.
Received on Tue Aug 03 1999 - 09:34:36 CDT