Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sizing Locally Managed Tablespace

Re: Sizing Locally Managed Tablespace

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 06 Jan 2004 22:27:50 +0100
Message-ID: <btf8mm$2u5$1@news1.tilbu1.nb.home.nl>


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

Convert to LMT is also an option ;-)
And sizes: 2 by 4 by 4 will do nicely.
Read up on LMT, and stop worrying about sizes.

-- 

Regards,
Frank van Bortel
Received on Tue Jan 06 2004 - 15:27:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US