REPOST: 9i Pfile

I just installed Oracle 9i, and want to start to learn it. Right away, it appears Oracle made some changes to the init files. For instance, the default installed instance has a huge SGA, which I don't need to do "select * from scott.emp" type queries. Can someone tell me how to cut it back? I tried changing the init.ora files to the following, but the settings don't appear to be recognized:

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Partitioning option
JServer Release 9.0.1.0.0 - Production

SQL> show sga

Total System Global Area 336356520 bytes

Fixed Size                   279720 bytes
Variable Size             268435456 bytes
Database Buffers           67108864 bytes
Redo Buffers                 532480 bytes

# init.ora

db_block_size=8192
db_cache_size=10M
open_cursors=300
background_dump_dest=/usr/oracle/9.0/admin/TESTDB/bdump core_dump_dest=/usr/oracle/9.0/admin/TESTDB/cdump timed_statistics=TRUE
user_dump_dest=/usr/oracle/9.0/admin/TESTDB/udump db_domain=laquinta
remote_login_passwordfile=EXCLUSIVE
control_files=("/usr/oracle/9.0/oradata/TESTDB/control01.ctl", "/usr/oracle/9.0/oradata/TESTDB/control02.ctl", /usr/oracle/9.0/oradata/TESTDB/control03.ctl") dispatchers="(PROTOCOL=TCP)(SER=MODOSE)",
"(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)",
"(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
compatible=9.0.0
db_name=TESTDB
instance_name=TESTDB
java_pool_size=16m
large_pool_size=1048576
shared_pool_size=16m
processes=150
fast_start_mttr_target=300
resource_manager_plan=SYSTEM_PLAN

sort_area_size=524288
undo_management=AUTO
undo_tablespace=UNDOTBS

• WAS CANCELLED BY =======: From: "Pamela Samuels" <xyz_at_hotmail.com> Control: cancel <tEA48.4133$a07.1738515_at_typhoon.southeast.rr.com> Subject: cmsg cancel <tEA48.4133$a07.1738515_at_typhoon.southeast.rr.com> Date: Mon, 28 Jan 2002 02:03:24 GMT Message-ID: <cancel.tEA48.4133$a07.1738515_at_typhoon.southeast.rr.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!elk.ncren.net!canoe.uoregon.edu!logbridge.uoregon.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40720830

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sat Jan 26 2002 - 10:17:29 CST