Home » RDBMS Server » Server Utilities » Interpreting tkprof output
Interpreting tkprof output [message #69554] Thu, 31 January 2002 05:43 Go to next message
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 #69563 is a reply to message #69554] Thu, 31 January 2002 08:54 Go to previous messageGo to next message
billh
Messages: 35
Registered: August 1999
Member
It is the elapsed time of the query.
Re: Interpreting tkprof output [message #69590 is a reply to message #69554] Tue, 05 February 2002 08:31 Go to previous message
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.
Previous Topic: Re: Import txt file to Oracle SQL* Plus
Next Topic: REPLACE in SQL Loader
Goto Forum:
  


Current Time: Wed Apr 24 02:09:33 CDT 2024