Ask the Expert

Determining a query's response time

How do we determine a query's performance (response time)? Can you please tell me the steps?

    Requires Free Membership to View

The easiest way to determine how long a query takes to run is to execute the query in SQL*Plus with timing turned on. Before running the query, issue the following:
SET TIMING ON
Now execute the query. You will be presented with the results as well as the runtime of the query.

This was first published in March 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.