Re: Database directory Size and Memory Usage

From: Steitz Adolf <adolf.steitz_at_also.de>
Date: 2000/07/27
Message-ID: <3980140d$0$21547@businessnews.de.uu.net>#1/1

Hi Jason,

have a look at your inital and next extents size of your tables. Reduce the size-parameter, make an export, drop and recreate the tablespace, and make an import.

Doing this, we reduced a data - tablespace from 8 to 3,6 GB and the index - tablespace from 5,6 to 2,5 GB.

To limit the amount of disk space, put a limit on the maximum size of the datafile(s) for the tablespace.

Adolf

Jason Rigsbee <jrigsbee_at_rigsbee.net> schrieb in im Newsbeitrag: O5sK$o29$GA.64_at_cpmsnbbsa07...
> I have a database that has grown toooooo big for what it is and what it
> does. There is not much to this database (not many tables, views,
triggers,
> data, etc.) and it is used only for development purposes. It has grown to
> over 8GB in size. How can I shrink (compress) a database and then limit
the
> amount of disk space it can gobble up?
>
> Finally I also need to know how I can limit each database to a selected
> static memory space but preferably a dynamic range of memory-lets say
> between 0 MB and 150 MB of physical RAM when running?
>
> Thank you.
>
> jlr
>
>
Received on Thu Jul 27 2000 - 00:00:00 CDT