Re: Newbie Q: Oracle and Novell

In article <3jkmcf$qa_at_anshar.shadow.net>, dgilbert_at_shadow.net_at_shadow.net says:
>
>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!
>

What are your sever specs.

1. Memory.
2. Number users
3. Server specs 486-33, 66, Pentium
4. 10, 100 Mbytes HUBS.

Hint Oracle is memory hogs. Received on Fri Mar 10 1995 - 08:53:39 CET