Re: How to minimize Oracle's memory footprint on a laptop running Windows 2000

Change the amount of memory in the initSID.ora file. You can drop the amount very significantly.

Good luck trying out Oracle 9i. It doesn't exist yet.

Daniel A. Morgan

Rob Ratcliff wrote:

> Hi,
>
> I've installed Oracle 8.1.7 on my laptop so that I can develop database
> centric Java programs autonomously. I've noticed
> that Oracle takes about 63 Meg of memory to start with. Since I only
> have 256 Meg of memory to handle the rest of my
> development tools, what is the best way to reduce Oracle's memory
> consumption. I don't care if the performance of the
> database is degraded a bit since only I will be making simple queries
> and such. I've attached my current init.ora file if anybody
> is interested.
>
> Also, what's the best way to reduce the size of the rbs01.dbf file? The
> default is 512 MB which is much bigger than I need right
> now.
>
> My next step is to try out Oracle 9i on my laptop. :-)
>
> Thanks,
>
> Rob
>
> ------------------------------------------------------------------------
> #
> # Copyright (c) 1991, 2000 by Oracle Corporation
> #
> ##############################################################################
> # Example INIT.ORA file
> #
> # This file is provided by Oracle Corporation to help you customize
> # your RDBMS installation for your site. Important system parameters
> # are discussed, and example settings given.
> #
> # Some parameter settings are generic to any size installation.
> # For parameters that require different values in different size
> # installations, three scenarios have been provided: SMALL, MEDIUM
> # and LARGE. Any parameter that needs to be tuned according to
> # installation size will have three settings, each one commented
> # according to installation size.
> #
> # Use the following table to approximate the SGA size needed for the
> # three scenarious provided in this file:
> #
> # -------Installation/Database Size------
> # SMALL MEDIUM LARGE
> # Block 2K 4500K 6800K 17000K
> # Size 4K 5500K 8800K 21000K
> #
> # To set up a database that multiple instances will be using, place
> # all instance-specific parameters in one file, and then have all
> # of these files point to a master file using the IFILE command.
> # This way, when you change a public
> # parameter, it will automatically change on all instances. This is
> # necessary, since all instances must run with the same value for many
> # parameters. For example, if you choose to use private rollback segments,
> # these must be specified in different files, but since all gc_*
> # parameters must be the same on all instances, they should be in one file.
> #
> # INSTRUCTIONS: Edit this file and the other INIT files it calls for
> # your site, either by using the values provided here or by providing
> # your own. Then place an IFILE= line into each instance-specific
> # INIT file that points at this file.
> #
> # NOTE: Parameter values suggested in this file are based on conservative
> # estimates for computer memory availability. You should adjust values upward
> # for modern machines.
> #
> ###############################################################################
>
> db_name = "oracle2"
>
> db_domain = mydomain.com
>
> instance_name = oracle2
>
> service_names = oracle2.mydomain.com
>
> db_files = 80
>
> control_files = ("c:\oracle\oradata\oracle2\control01.ctl", "c:\oracle\oradata\oracle2\control02.ctl", "c:\oracle\oradata\oracle2\control03.ctl")
>
> open_cursors = 300
> max_enabled_roles = 30
> db_file_multiblock_read_count = 8
>
> db_block_buffers = 100
>
> shared_pool_size = 3500000
>
> large_pool_size = 614400
> java_pool_size = 20971520
>
> log_checkpoint_interval = 10000
> log_checkpoint_timeout = 1800
>
> processes = 50
>
> parallel_max_servers = 5
>
> log_buffer = 32768
>
> #audit_trail = true # if you want auditing
> #timed_statistics = true # if you want timed statistics
> max_dump_file_size = 10240 # limit trace file size to 5M each
>
> # Uncommenting the line below will cause automatic archiving if archiving has
> # been enabled using ALTER DATABASE ARCHIVELOG.
> # log_archive_start = true
> # log_archive_dest_1 = "location=c:\oracle\oradata\oracle2\archive"
> # log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
>
> # If using private rollback segments, place lines of the following
> # form in each of your instance-specific init.ora files:
> #rollback_segments = ( RBS0, RBS1 )
>
> # Global Naming -- enforce that a dblink has same name as the db it connects to
> global_names = true
>
> # Uncomment the following line if you wish to enable the Oracle Trace product
> # to trace server activity. This enables scheduling of server collections
> # from the Oracle Enterprise Manager Console.
> # Also, if the oracle_trace_collection_name parameter is non-null,
> # every session will write to the named collection, as well as enabling you
> # to schedule future collections from the console.
> # oracle_trace_enable = true
>
> oracle_trace_collection_name = ""
> # define directories to store trace and alert files
> background_dump_dest = c:\oracle\admin\oracle2\bdump
> #Uncomment this parameter to enable resource management for your database.
> #The SYSTEM_PLAN is provided by default with the database.
> #Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
> user_dump_dest = c:\oracle\admin\oracle2\udump
>
> db_block_size = 8192
>
> remote_login_passwordfile = exclusive
>
> os_authent_prefix = ""
>
> distributed_transactions = 500
> mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
> # Uncomment the following line when your listener is configured for SSL
> # (listener.ora and sqlnet.ora)
> # mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
>
> compatible = 8.1.0
> sort_area_size = 65536
> sort_area_retained_size = 65536
Received on Sun Apr 22 2001 - 00:25:41 CDT