Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: REPOST: 9i Pfile
Hi Pamela,
That is because you could be probably using the new SP file.
logon to Oracle like (assuming you have not changed the default password for
sys... which you should asap)
$sqlplus "sys/change_on_install as sysdba"
SQLPLUS> show parameter spfile
if it shows spfile with a value, then the information is being read from the
SPfile which is a new parameter file which Oracle manages.
So what you have to do is
$sqlplus "sys/change_on_install as sysdba"
SQLPLUS>shutdown
SQLPLUS>startup mount
SQLPLUS>create spfile from pfile='<path of your init.ora where you changed
the parameter>
SQLPLUS>alter database mount;
SQLPLUS>alter database open;
Now you will see the new SGA settings
Hope this helps.
Regards,
Anil
"Pamela Samuels" <xyz_at_hotmail.com> wrote in message
news:5$--$%%%_$_-$$_$%$@news.noc.cabal.int...
> 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.maxw
ell.syr.edu!elk.ncren.net!canoe.uoregon.edu!logbridge.uoregon.edu!news.steal
th.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 Wed Jan 30 2002 - 15:36:05 CST