Hi,
I ran the following the following results after running the query on v$waitstat and v$system_event tables.

I know something is wrong but do not know the approach to fix this.

I tried a few books also but none of them explain clearly how to fix the buffer busy waits problems clearly enough.

Please Help.

Thanks
Anurag

select * from v$waitstat where class ='data block';

CLASS COUNT TIME
------------------ --------- ---------
data block 3962775 0

select substr(event,1,25)"Event",TOTAL_WAITS, TOTAL_TIMEOUTS,TIME_WAITED ,
2 AVERAGE_WAIT from v$system_event where event='buffer busy waits';

Event TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
------------------------- ----------- -------------- ----------- ------------
buffer busy waits 3962830 73 0 0