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: Limiting the amount of memory Oracle uses

Re: Limiting the amount of memory Oracle uses

From: Harald Maier <maierh_at_myself.com>
Date: Wed, 27 Aug 2003 17:41:18 +0200
Message-ID: <m3znhvf6qp.fsf@ate.maierh>


cake_at_lenel.com (John Marchioli) writes:

> Hi folks. Forgive my ignorance here, I am not that familiar with
> Oracle configuration and setup.
>
> I have about 6 database instances that each have about 300 tables.
> These instances are all using Oracle 9i and are running on Windows
> 2000 server. The purpose for these instances are STRICTLY for
> testing and each instance holds about 5 to 10M of real data.
>
> These instances consume way more than 512M all together. Is there
> anyway I can limit each instance to say 50Meg of physical memory
> since performance is not an issue - these are strictly for testing
> triggers and schema changes.

Uncomment the initialization parameters that are flag with '#' then Oracle will use default values for the sga. I have not tested this on a W2K box but below my results on a Linux box. As you can see on my system the database then uses 93 MB. Also you can shutdown the idle instances. If you need it restart it again.

*.db_block_size=8192

# *.db_cache_size=50331648
# *.java_pool_size=83886080
# *.large_pool_size=16777216
# *.sga_max_size=314572800
# *.shared_pool_size=16777216
# *.sort_area_size=65536

*.workarea_size_policy='AUTO'
*.pga_aggregate_target=16M

NAME VALUE

-------------------- ----------
Fixed Size		 451416
Variable Size	       46137344
Database Buffers       50331648
Redo Buffers		 667648
		     ----------
sum		       97588056


free memory


          0

Harald Received on Wed Aug 27 2003 - 10:41:18 CDT

Original text of this message

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