Wait Event – Disk file operations I/O

This event is used to wait for disk file operations (for example, open, close, seek, and resize). It is also used for miscellaneous I/O operations such as block dumps and password file accesses. Wait Time: The wait time is the actual time it takes to do the I/O   Parameter Description FileOperation Type of file operation…

Understanding TKProf output

In the previous post (Oracle TKProf Usage), we saw how to generate a SQL Trace and then how to format it using TKProf. In that post we create a trace for following SQL statement:- select * from all_objects; In this post we would interpret TKProf output of that SQL query. Following is the TKProf Output…