Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Low Performance, using ORACLE 8
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.
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ "Axel Pötzinger" <a.poet_at_freenet.de> wrote in message news:8k6rql$epe$11$1_at_news.t-online.com...Received on Mon Jul 10 2000 - 00:00:00 CDT
> Hi,
>
> using ACCESS as database server in the past, we now tried ORACLE, because
> performance was not satisfactory at all (low performance when several
users
> where logged on).
>
> We use mfc odbc-classes and database recordsets, getting connection to the
> database by a microsoft odbc-driver.
>
> First tests resulted in an even slitely lower performance with one client
> logged on, and a performance only a little higher with some clients logged
> on.
>
> 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
>
> Axel
>
>
>