Srini Chavali wrote:Srini - Thanks for your help.
Pl post exact database and OS versions on physical and VM servers. Start with AWR reports on both databases - can you post the Top Timed Events sections for both ? At the end of each report, there is a listing of the init.ora parameter settings - are they exactly the same for both databases ? Are database statistics current on both databases ? Ignore the buffer hit rate for now - I think it is a red herring.
Pl use code tags to format your post to make it more readable - see https://wikis.oracle.com/display/Forums/Forums+FAQ
Top 5 Timed Events Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class ==================================================================================================================== db file sequential read 13,368,047 162,004 12 41.6 User I/O db file scattered read 18,056,745 133,673 7 34.3 User I/O db file parallel write 1,312,995 18,319 14 4.7 System I/O read by other session 4,470,854 16,902 4 4.3 User I/O CPU time 14,165 3.6