Re: Low Performance, using ORACLE 8

>
> Question:
> Please, please, please give us some hints, what measures can be taken to
> increase performance remarkably.
>

Can you post your initorcl.ora and an example of a slow query with the and its execution plan (create a plan table with the script provided in the docs, just search the doc for plan_table, log in through sqlplus and then set autotrace on and then start your queries) , table scripts and info about the number of recs of tables, indexes and so on.

>
> 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