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: Gerry Sinkiewicz <sinkiege_at_snet.net>
Date: Wed, 07 Jan 2004 00:40:25 GMT
Message-ID: <ZzIKb.22311$oK4.12040@newssvr33.news.prodigy.com>

"DJ" <nospamplease_at_goaway.com> wrote in message news:HxGKb.18457$526.125052_at_newsfep4-glfd.server.ntli.net...
>
> "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
>
>

When you create the datafile use autoextend on next 10M maxsize 3000M extent management local autoallocate; Received on Tue Jan 06 2004 - 18:40:25 CST

Original text of this message

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