Can anybody let me know , how to find out the estimated time to execution a query , without running it actually. Is there any way ???
Thanks in advance
You can use EXPLAIN PLAN to optimaze your query.
Yeah, I think the excution will also depends on the number of rows it is going to fetch from the base tables. so we cant determine the execution time,
Thanks a lot KGB,
well there is no way to estimate execution time without running it but you can use a dirty trick in 8i... run the query for over 6 seconds then cut the query and look v$session_longops, there will be an estimate time. Pretty accurate, works pretty well for me
what unit is the time in, seconds or milli-seconds? Thanks.
it's in the docs...
Session serial number
Brief description of the operation
The object on which the operation is carried out
Description of the target
The units of work done so far
The total units of work
The units of measurement
The starting time of operation
Time when statistics last updated
Estimate (in seconds) of time remaining for the operation to complete.
The number of elapsed seconds from the start of operations
Statistics summary message
User ID of the user performing the operation.
Used with the value of the SQL_HASH_VALUE column to identify the SQL statement associated with the operation.
Used with the value of the SQL_ADDRESS column to identify the SQL statement associated with the operation.
Session identifier of the parallel coordinator.
Click Here to Expand Forum to Full Width