What you didn't tell us is what OS is running on the server and what the processors are. Sometimes, multiprocesssor servers can actually run slower than single use processors becuase the software is not optimized for multi-processor (multiple, simultaneous thread) support. So, the server spends a lot of time trying to optimize the execution of the software (Oracle) that the single processor system does not. You may wish to contact Oracle and find out the specs of their support for that architecture.
>Hi,
>
>I have a client/server app which proccess a large amount of data and store all this data on a Oracle 7 Database. Both the app and the Oracle Server are running on the same machine, a Compaq Proliant 6500 with 4 processors, 780 Mb of RAM and RAID 5. The Oracle version is 7.3.4.3.0 and the ODBC driver version is 2.5.3.1.0.
>
>The application is using a SQLPREPARE statement before the SQLEXEC loop and the query is being totally optimized by the Oracle parser.
>
>The same application is running twice faster on a Pentium 133 / 64 Mb machine.
>
>Does anyone have an idea of what is happening?
>
>Regards
>
>Fabio Fritoli
>IT Manager
>WA Marketing & Sales Solutions
>ffritoli@wa.com.br
>Voice 55 11 5563-7899
>Fax 55 11 5563-8199
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05