Re: Newbie Q: Oracle and Novell

From: Kees Verruijt <kees_at_redwood.nl>
Date: Sat, 11 Mar 1995 17:49:07 GMT
Message-ID: <D5AEtv.278_at_inter.NL.net>


> I have a simple question:
>
> What should the performance of a Oracle 7 server (Compaq Proliant) using
> the novell version be?
>
> We are trying to pick up the pieces of a really messed up Oracle/PowerBuilder
> system and are having loads of trouble figuring out a baseline for Oracle after
> coming from a FoxPro type background.
>
> Simple queries can take > 6 seconds to retrieve 300 records off a small table. Updating
> a 12,000 record database (changing one field from one number to another) is taking
> upwards of 5 minutes (huh?!?!). Is this even in the ballpark?? Sure doesn't sound
> like it is to us!
>
> I've checked the SGA buffer and came up with these statistics:
> Executions Misses Percent
> Library Cache 985,313 4310 0.43%
> Data Dict. 6,291,325 38,383 0.61%
> Buffer Cache is running at > 95% cache hits as well.
>
> All of these are considered "norm" according to Oracle manuals.
>
> Anyone have any ideas where to start. The "tuning" section in the Oracle manuals
> has already been gone over, and I've been through the init.ora file as well and I
> can't see what I need to change, but the performance (or complete lack thereof)
> is beginning to make us seriously start thinking about something else!
>
> Thanks for any help!
>

A few months ago I was called to a customer site where they encountered really *extremely* bad Oracle performance. Their novell server was at 98% busy, even during disk-intensive queries.

It turned out they had the SQL*Net monitor enabled. This is done somewhere on the console, can't remember where. Turning it off immediately improved performance by 10-100 times depending on the type of activity.

Hope this helps,

Kees Verruijt Received on Sat Mar 11 1995 - 18:49:07 CET

Original text of this message