Q
Problem solve Get help with specific problems with your technologies, process and projects.

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