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

Thanks. I meant to say Oracle 9iAS.

"Daniel A. Morgan" wrote:

> 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 - 07:25:17 CDT