| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> SQLPLUS-like set time on for SQRs
I am trying to determine how long individual SQL
within a SQR takes. The closest I've found is using
tkprof to get the Elapsed time, but the problem is for
most of SQLs the elapsed time value is 0. In SQL*Plus
after SET TIME ON, we are able to get the time before
and after each SQL. Is there any way this could be
done for a SESSION (be it SQR, PL/SQL or Pro*C) -
something similar to turning Trace ON ?
Something magical l;ike:
Alter session set SQL_TIME = TRUE;
 |
 |