Measuring query response time in Oracle

How can I measure query response time in Oracle 9i and Oracle 10g?

How can I measure query response time in Oracle 9i and Oracle 10g?
In SQL*Plus, this is very easy. Just issue the following:
SET TIMING ON
Then execute your SQL statement. SQL*Plus will show you the total run time after the query is done processing.

Dig Deeper on Oracle database performance problems and tuning

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close