Re: how to make db biggger

In article <8odp94$3oa$1_at_nnrp1.deja.com>,   tony_barratt_at_my-deja.com wrote:
> Hi List,
> I've taken delivery of a Oracle 7.3.2 database.
> A peek in the init.ora file everything is set to small eg
> <snip>
> db_block_buffers = 60 # SMALL
> # db_block_buffers = 550 # MEDIUM
> # db_block_buffers = 3200 # LARGE
> <snip>
>
> But as I've got 2GB RAM and 2X400 MHz Ultra Sparc processors sat
> underneath the database and lots of data coming soon, I thought I've
> nip through the file and set everything to large:
> like so:
> <snip>
> # db_block_buffers = 60 # SMALL
> # db_block_buffers = 550 # MEDIUM
> db_block_buffers = 3200 # LARGE
> <snip>
>
> Then stop the database:
> Oracle7 Server Release 7.3.2.3.0 - Production Release
> PL/SQL Release 2.3.2.3.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> shutdown immediate
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> Then startup again, y voila!
> nothing has changed:
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 8194920 bytes
> Fixed Size 39732 bytes
> Variable Size 6996020 bytes
> Database Buffers 1126400 bytes
> Redo Buffers 32768 bytes
> Database mounted.
> Database opened.
>
> But the above figures are just what I got before.
> In particular I was expecting to see a 15MB SGA, cos of this:
> #shared_pool_size = 3500000 # SMALL
> # shared_pool_size = 5000000 # MEDIUM
> shared_pool_size = 15000000 # LARGE
>
> I must be missing something, but what?
>
> TIA
>
> Tony
>

One, did you change the correct init.ora file?

If you are using OEM then the init.ora file used comes off the PC so every change made needs to be propogated to every desktop that has OEM installed on it and access to start/stop the database.

If you are not using OEM then the init.ora file should be located under $ORACLE_HOME/dbs as initSID.ora.

Lastly, if you are running a startup script instead of OEM or manually starting the database make sure it is not referencing a pfile= parameter and using an init.ora stored in some non-standard location.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.