-
elapsed time in sqlplus client
Hi
SQL> select * from dual;
D
-
X
real: 16
SQL>
what i need is the elapsed time.I also tried setting set timing on no use any ideas ?
regards
Hrishy
-
"set timing on" works ... you probably have a mismatch between your client and server versions.
-
Hi Dave
Yep you are absolutely right :-)
regards
Hrishy
-
Originally Posted by hrishy
SQL> select * from dual;
D
-
X
real: 16
SQL>
Wow, I remember when SQL*Plus used to give that type of timing info. Just. Version 8.0 or so, maybe?
Presumably you also encounter problems with timestamp columns and SQL commands beginning with MERGE or WITH as well.
Last edited by WilliamR; 03-24-2006 at 07:40 PM.
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
|