Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: how to make db biggger

Re: how to make db biggger

From: <tony_barratt_at_my-deja.com>
Date: Mon, 28 Aug 2000 17:07:30 GMT
Message-ID: <8oe682$jb4$1@nnrp1.deja.com>

The init file that is actually used was /opt/oracle/dbs/initora.ora not, as I'd thought, init.ora.
Thanks for your help....
In article <8odqq1$5ap$1_at_nnrp1.deja.com>,   Mark D Powell <markp7832_at_my-deja.com> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 28 2000 - 12:07:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US