Oracle7.3/NT vs. SQL Server6.5 perf?

Can anyone comment on the relative performance of Oracle7.3/NT versus SQL Server 6.5? We're running a single user ODBC application (via Simba drivers) to import data into the DB (we can't use SQL*Loader for our requirements). After monitoring/tuning key statistics and parameters for the Oracle instance, the performance lags behind SQL Server by an order of magnitude (5x slower). We've also factored out the ODBC drivers out of the equation by sending specific SQL statements through SQL*Plus and I/SQL, respectively. Hardware config for Oracle is a ALR Quad with 512MB RAM. SQL Server is a lower end box.

We're running Workgroup Server instead of Enterprise Server. From what we've discovered, Workgroup doesn't support the parallel query option. Any other performance related differences b/w Workgroup and Enterprise. NT vs. Unix?

Thanks in advance! Received on Sat Aug 16 1997 - 00:00:00 CDT