Hi

My application was running ok in past. Recently it started getting slow. I monitored the followings in my DB

1) SGA status: Fine
2) Memory: Fine 99% hit rate
3) Checkpoint occurance
4) Rollback contention
5) Session waits etc


My top 5 wait events are

1) db_file_sequential_read 4057992
2) buffer_busy_waits 475055
3) SQL* net more data to client 305261
4) latch free 124169
5) db_file_parallel_write 111110


And most importantly I saw in v$session few sessions are becoming inactive. I am running a process 32 sessions wide but 5 -6 sessions are getting INACTIVE.

I checked v$session_waits and see that they are waiting for 1) db_file_sequential_read and 2) Sql* net more from client


A SMALL CHANGE FOUND: recently client added 8 more CPUs in the box, earlier it was 50.

but they did not update db_block_lru_latch form 100 to 116
and cpu_count 50 to 58

DOES THAT MAKE ANY DIFF IN PERFORMANCE as mentioned above (waits)


Regards