Re: Low Performance, using ORACLE 8

On Mon, 10 Jul 2000 14:10:15 GMT, "Bob Fazio" <rfazio_at_home.com.nospam> wrote:

>I agree with all other post's up to this point. Tuning is a process that
>takes some time, and can't be done just by telling us your configuration.
>What are you using this novell server for other than Oracle. You may be shy
>on memory. Even with 256M.
>

Yeah, but in this case it should be enough! I'm inclined to some problem with thenetwork itself or the old ODBC performance problems that crop up from time to time.

>>
>> Question:
>> Please, please, please give us some hints, what measures can be taken to
>> increase performance remarkably.
>>
>> Our configuration:
>> Novell 5 (Server with 256 MB)
>> ORACLE Server 8.0.4
>> 3 Clients (Win95/98, PIII: 350 MHz/64MB)
>> Visual C++ Version 6
>> Microsoft ODBC-Driver Version 2.573.3711
>>

I'd start by isolating the problem;

While the thing is slow, is the CPU or I/O being hit hard on the server? If it is, then you have an ORACLE and/or Novell problem. If I/O, look at disk distribution. If CPU, then might be a problem with your SQL: works fine in Access but doesn't work well with ORACLE. Tune the SQL itself, not the database.

If it isn't, then it's good old MS odbc driver up to its anti-ORACLE tricks again. Contact ORACLE and see if you can get a version of ODBC that works better.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Mon Jul 10 2000 - 00:00:00 CDT