Hi Alan,
Could you please re-run your tests and post the output from v$session_event
and the 'CPU used by this session' value from v$sesstat. That will show us
where the difference in time is.
Regards,
Steve Adams
In article <924516724.28567.0.nnrp-11.c2d97406_at_news.demon.co.uk>,
"Alan Barclay" <escribe_at_my-dejanews.com> wrote:
> Hi tuning gurus,
>
> I recently wrote a 'performance testing' application (PC based) which does
> several thousand (small) inserts across five tables in an Oracle 8.0.5 DB.
> The application uses the MFC ODBC classes (yuck!).
>
> When I run the program against two 'similar' machines (with default OS and
> DB installations) - I get very very different 'speed' results.
> Can anyone explain this? (Surely, Linux isn't this much better than
> Slowlaris!)
> I've checked the DB inits/configs and they look the same - but maybe Oracle
> make some other defaults different between the two installations??
>
> Linux RH 2.0.36 - * 285 * inserts per second
> on PII 350MHz / 128Mb RAM / DB on UW SCSI HD
>
> Solaris 7 - * 81 * inserts per second
> on UltraSPARC 333MHz / 128Mb RAM / DB on UW SCSI HD
>
> Thanks for any ideas.
> Alan.
>
>
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 19 1999 - 06:13:42 CDT