Re: Low Performance, using ORACLE 8

Basically tuning in the oracle environment is split into instance tuning (init.ora, sizing of tables) and statement tuning. All these aspects are greatly covered by Richard Niemiec's book Oracle Performance Tuning (Oracle Press) - highly recommended (see also his presentation for los angeles oracle usergroup, topic Oracle Performance Tuning and Database Administration, at http://www.laoug.org/presentation.htm). I hope you didn't start with that preconfigured database - most settings are beyond real requirements.

Regards

Klaus

"Axel Pötzinger" <a.poet_at_freenet.de> schrieb im Newsbeitrag news:8k6rql$epe$11$1_at_news.t-online.com...
> 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
>
>
>
Received on Sat Jul 08 2000 - 00:00:00 CDT