Re: Database Size and Memory Usage

[Quoted] [Quoted] You have to export the data one tablespace at a time, recreate the tablespace, then import the data back into the tablespace to get rid of extra free space. Check your documentation for import and export syntax. When creating your new tablespaces, you can specify maxsizes on your datafiles while autoextending is on, you must periodically check to make sure that the data files aren't filled up.

You have to modify your init.ora file to change your memory configuration. This file is usually found in ORACLE_HOME\DATABASE or ORACLE_HOME\ADMIN\SID_NAME\PFILE directories. You can decrease the number of [Quoted] [Quoted] database_buffers, shared_pool_size and sort_memory_size parameters, but this [Quoted] might affect performance.

Todd Measles

[Quoted] "Jason Rigsbee" <jrigsbee_at_rigsbee.net> wrote in message news:OhTv#p29$GA.320_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 Wed Jul 26 2000 - 00:00:00 CEST