Re: 9i Pfile

You need to read the manuals. The SGA consists of more than just those parts you set in the init.ora file.

Daniel Morgan

Pamela Samuels wrote:

> 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
Received on Sat Jan 26 2002 - 04:32:39 CST