The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
Thanks for the question, sunil.
Asked: July 19, 2017 - 11:52 am UTC
Last updated: July 21, 2017 - 1:16 am UTC
Version: Oracle 11g r2
Viewed 1000+ times
We are planning to migrate Oracle 11g DB from HPUX environment to Vmware infrastructure. but while doing performance testing we are not getting expected performance while executing batch job.benchmark is 200k transaction per minute but on linux it is processing 75k per minutes Client is HPUX11iv3 16 core 256 GB RAM and DB server is RHEL 6.7 ( 16 core 64 GB RAM) SGA 3,058.3 TOP events Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class DB CPU 8773.6 53.9 db file sequential read 4,749,119 4226.3 1 25.9 User I/O SQL*Net break/reset to client 19,740,519 2824.5 0 17.3 Application kksfbc child completion 36,712 1794 49 11.0 Other CPU utilisation on DB is hardly 20%
Get all the information about database performance in the Database Performance guide.