Re: Oracle Tuning under A/UX
Date: Wed, 22 Mar 1995 22:03:38 -0500
Message-ID: <dscott-2203952203380001_at_dscott.is.net>
In article <bodeD5MInv.Hp9_at_netcom.com>, bode_at_netcom.com (bode) wrote:
> Hello,
>
> I just inhereted a large database running Oracle7 over A/UX on an Apple
> WorkgroupServer 95. The database is roughly 1.7 gigs large, and holds
> advertising data. I am trying to get as much performance as possible out
> of the database and the WGS95. The WGS95 has 80 megs of ram, and I am
> trying to change the buffers to make use of all the memory. Currently
> oracle spawns about 60 megs worth of oracle processes including the
> appletalk network interface. However, that leaves roughly 15 megs free,
> and the machine is not swapping any pages.
>
> Any ideas, pointers, anything that would help to improve the _very_
> sluggish performance. Right now I do not believe the database is in a raw
> partition, but is stored in a unix partition. Is this slowing things
> down? Is it safe and or easy to move it to a raw partition? Striping the
> drives might help?
>
> Performance is bad enough it's almost not usable, and any help would be
> much appreciated, or any pointers to any relevant info.
>
I agree with one of the other posters that recommended an export/import
cycle, but disagree with the RAID suggestion of another poster. You will
be MUCH better off with striping than with RAID5. I am running 7.0.15
under A/UX on one of my servers (also have Macs with Oracle6, RS6000 w/
7.1.3, and Suns with 7.1.4), and the performance is fine - though it is a
smaller set of data than yours (dozen or so 60+ MB tables w/ 30K+ rows
each). Take a look at the Oracle tuning book by OReilley press (orange
cover with a bee on it) for some general suggestions on tuning - the book
is fabulous.
If you want to continue the conversation off-group, just drop me a line at: dscott_at_prubank.com
Good luck - let me know about your progress!
David Scott
...how can I keep from singing?
email: dscott_at_is.net
Received on Thu Mar 23 1995 - 04:03:38 CET