Re: Sizing Tablespaces, Extents, etc.

Hi Stephen,

First of all I recommend an excellent book "Oracle Performance Tuning" from O'Reilley & Associates Inc, second edition, which covers Oracle7 tuning and is a reference.

My advice for "a quick try", if you have no clue about how much data you will feed into your system :
1) create the oracle tables with default storage parameters, load data. 2) export the table(s) with COMPRESS=Y option, drop and re-import the data. Doing so, you will have all your data in one extent, which is a good start. Later, OracleServer for windows95/NT should allow to manage your database graphically quite easily. Performance manager (same product/platform) would even help to tune it.

Jeff (jgrimons_at_pt.lu)

Stephen M. Earl <searl_at_primenet.com> wrote in article <01bc1d46$e8bfc750$528ef6c0_at_searl-hc>...
> Can anyone recommend a good tool for setting up tablespaces, extents etc.
 

> We are currently converting several Access bases applications to Oracle
 7.x
> and our DBA needs to know several sizing parameters. Even after the DBA
> classes he's not much help in this area, so I'd rather go with an
 automated
> / software based solution.
>
> Thanks in advance,
>
> Stephen M. Earl...
>
>
Received on Sat Feb 22 1997 - 00:00:00 CET