Query execution detail
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
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
0