Oracle Journal for Database Administration and Apps DBA
Knowledge Repository for Oracle Database administrators and applications DBA.
Monday, March 7, 2011
How to know timing of SQL statements
How to know how long does the sql statement take to return the result.
Solution:
set timing on.
sql> run the sql statement
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment