Database Tuning (MOSC)

MOSC Banner

Query execution detail

edited Aug 7, 2011 7:49PM in Database Tuning (MOSC) 4 commentsAnswered
Hi,
My client is running a query in BO(business object) and having performance trouble. He needs following :

1. Time of firring the query to Oracle.
2. Time of actual start of parsing of query.
3. Time of CPU duration spent in query execution.
4. Waiting time involved in query.
5. Time of finishing Query.

I am using the following query but not able to answer all of his queries :

select 
        a.sql_id,
        a.elapsed_time,
        a.FIRST_LOAD_TIME,
        substr(a.module,1,10)   module,
        substr(a.sql_text,1,70) sql_text,
        a.cpu_time,
        a.user_io_wait_time
from    sys.v_$sqlarea  a,
          dba_users b

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center