Re: Sizing Locally Managed Tablespace

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1073426831.465706_at_yasure...
> Ronnie wrote:
>
> > Hi,
> >
> > We have a database on which I am planning to create a Locally Managed
> > Tablespace. The Tables/objects in this table space will be dropped
> > nightly and fresh data imported using the import utility from our
> > internal databases.
> >
> > The reason we are doing this is because we want 2 databases one
> > internal and one external. Internal database being the one where our
> > employees enter the data and external databaseis the one which our
> > clients access.
> >
> > This particular application in question needs to be available to our
> > clients hence this export import.
> >
> > Now my question?
> >
> > This is a small application. Around 3 Gigs of data in 3 datafiles. It
> > consists of tables of various sizes a lot being small lookup tables
> > and some 1 which has over a million rows.
> >
> > How should I size my LMT on my external database to get the best
> > performance and optimal storage.
> >
> > Thanks
> > Ron
>
> Why this preoccupation with size? The optimimum size is large enough to
> hold the table and index blocks.
>
> Are you perhaps asking a question you didn't intend such as something
> about placement or stripping and mirroring?
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>

perhaps he means uniform extent size Received on Tue Jan 06 2004 - 16:21:23 CST