how to make db biggger

From: <tony_barratt_at_my-deja.com>
Date: Mon, 28 Aug 2000 13:26:15 GMT
Message-ID: <8odp94$3oa$1@nnrp1.deja.com>

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 28 2000 - 08:26:15 CDT