FITTING ENTIRE DATABASE

From: Jared Hecker <jared.hecker_at_factory.com>
Date: 11 May 93 21:54:00 GMT
Message-ID: <3185.1599.uupcb_at_factory.com>

HY>Has anyone tried an Oracle setup with, say, 128MB of RAM?  This to me
HY>is like having a huge cache.  Specifically, someone intends to setup
HY>something like this with a RS/6000.

HY>Concerns are: how will Oracle take advantage of the available memory?

HY>How to keep other processes out of Oracle's way? (This will be a HY>dedicated server.) What about even more memory?

Henry, Oracle will eat up that memory and love every minute of it. Essentially your friend should use it to make sure there is adequate cache for data dictionary items (this is KEY), and can donatemost of the rest to database buffers.

Considering how ^*(+_! slow the RS/6000 disk subsystem is, I applaud your friend's thinking. It will pay off big time inperformance.

hth -

jh

---
 . MR/2 1.39x NR . OS/2'ing it ...but feeling the hot rancid breath of NT
                                                       

Received on Tue May 11 1993 - 23:54:00 CEST