Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting the amount of memory Oracle uses
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
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
![]() |
![]() |