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

On that I can not help you. Perhaps others can.

Daniel A. Morgan

Rob Ratcliff wrote:

> 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 - 12:36:05 CDT