Oracle memory requirements

Thread View: comp.sys.sequent

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Scott Holt Fri, 25 May 1990 21:17

#238

Author: Scott Holt
Date: Fri, 25 May 1990 21:17

22 lines
1457 bytes

Does anyone out there have any general pointers on tuning
an Oracle system with the overall goal of reducing its size?
We are installing Oracle release 6.0.27 on a Sequent Symmetry S81.
The machine is pretty well configured - 10 CPUs, 96 meg real memory
and about 400 meg total for swap. We currently run five release
5.1.22 instances with few problems.

Despite this configuration we are a little worried about the load
that our planned Oracle use is going to put on the machine. It 
appears that each of the four Oracle "kernel" processes allocates 
about 17 meg (no, I did not forget a decimal point) of virtual memory.
Thats 68 meg for a single database instance, though I'm sure a few
meg is actually shared. 

Our current plans call for four instances and this causes a bit of
concern. I'm sure this would all be ok if the machine were dedicated to
Oracle, but it is not - it doubles as a time sharing system serving about
100 concurrent users. If there is any good way to reduce the size of the
Oracle kernel, I would appreciate hearing about it.

- Scott

Re: Oracle memory requirements

#246

Author: Kelly Hogan
Date: Sat, 02 Jun 1990 06:29

15 lines
1150 bytes

In article <9799@hydra.gatech.EDU>, scott@prism.gatech.EDU (Scott Holt) writes:
> Despite this configuration we are a little worried about the load
> that our planned Oracle use is going to put on the machine. It
> appears that each of the four Oracle "kernel" processes allocates
> about 17 meg (no, I did not forget a decimal point) of virtual memory.
> Thats 68 meg for a single database instance, though I'm sure a few
> meg is actually shared.

Give your local Sequent SA a call and ask for the tech tip regarding
the optimizing of the resident set size.  This helps substantially.
-- 
Kelly S. Hogan 					  ..!uunet!sequent!kellyh
Sequent Computer Systems, Inc.          "Once is Never Enough, Recycle It"
301 S.W. Alder Suite 1155
Portland, OR 97204         Days (503) 796-0747

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads