Interpreting tkprof output [message #69554] |
Thu, 31 January 2002 05:43 |
T.Leer
Messages: 1 Registered: January 2002
|
Junior Member |
|
|
Hi,
I have a question about interpreting a tkprof output.
There is an column named elapsed. What does this time in seconds say. I mean is it the time when a user connects with SQLNet and asks for the query or is it the time that the database needs to execute the query.
Thanks in advance,
Ton
|
|
|
|
Re: Interpreting tkprof output [message #69590 is a reply to message #69554] |
Tue, 05 February 2002 08:31 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Elapsed is mentioned to distinguish it from CPU time. Something may take 1 second of CPU to perform, but it may take 5 seconds elapsed time from start to finish because it's waiting for I/O or CPU is being used for other processes.
|
|
|