-
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
Madhu
-
-
You can use EXPLAIN PLAN to optimaze your query.
Best wishes!
Dmitri
-
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,
Madhu
-
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
-
pando,
what unit is the time in, seconds or milli-seconds? Thanks.
-
it's in the docs...
SID
NUMBER
Session identifier
SERIAL#
NUMBER
Session serial number
OPNAME
VARCHAR2(64)
Brief description of the operation
TARGET
VARCHAR2(64)
The object on which the operation is carried out
TARGET_DESC
VARCHAR2(32)
Description of the target
SOFAR
NUMBER
The units of work done so far
TOTALWORK
NUMBER
The total units of work
UNITS
VARCHAR2(32)
The units of measurement
START_TIME
DATE
The starting time of operation
LAST_UPDATE_TIME
DATE
Time when statistics last updated
TIME_REMAINING
NUMBER
Estimate (in seconds) of time remaining for the operation to complete.
ELAPSED_SECONDS
NUMBER
The number of elapsed seconds from the start of operations
CONTEXT
NUMBER
Context
MESSAGE
VARCHAR2(512)
Statistics summary message
USERNAME
VARCHAR2(30)
User ID of the user performing the operation.
SQL_ADDRESS
RAW(4)
Used with the value of the SQL_HASH_VALUE column to identify the SQL statement associated with the operation.
SQL_HASH_VALUE
NUMER
Used with the value of the SQL_ADDRESS column to identify the SQL statement associated with the operation.
QCSID
NUMBER
Session identifier of the parallel coordinator.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|