How are “execution time” and “timestamp” computed in the SQL Monitor?
Timestamp is assigned to a statement at the moment it is about to be sent to SQL Monitor for output, which occurs after the execution has completed. Speaking of the “execution time”. Normally statement processing consists of the parsing time (can occur once), the execution time (amount of time it took the statement to execute), and the fetching time (amount of time it took the user application to fetch records returned – usually cannot be accurately determined, who knows how one application performs a fetch, it may fetch one record, and another record two hours later). The “execution time” value is a second of the above three, a number of milliseconds that it took for OCIStmtExecute() to return, without taking into account fetching time – for the reason I mentioned above. As to Explain Plan, SQL Monitor has a built-in execution plan display for quite some time. Go to its “Options” screen, the second tab, where you can turn it on. Carefully read the information on that tab to be aware o
