No question at this time
DBA Top 10
1 M. Cadot 22600
2 A. Kavsek 15200
3 M. Hidayathullah ... 11000
4 B. Vroman 8100
5 P. Wisse 6000
6 T. Boles 5200
7 J. Schnackenberg 3300
8 G. Lambregts 2200
8 P. Knibbs 2200
8 K. Pagadala 2200
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48017
Total active users1850
Act. users last 24h5
Act. users last hour0
Registered user hits last week339
Registered user hits last month1183
Go up

Elapsed time of queries daywise.
Next thread: Oracle license for Standard Edition 2 on 2 physical quad-core CPUs with Hyper-V
Prev thread: insufficient privileges

Message Score Author Date
I have created sql query to pull total time taken ...... M KUMAR May 30, 2017, 16:55
Or is there any other way to pull elapsed_time of ...... M KUMAR Jun 02, 2017, 22:58
Dear Kumar, Please check below mos notes on AWR...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Mirza Hidayathullah Baig Jun 05, 2017, 06:50

Follow up by mail Click here


Subject: Elapsed time of queries daywise.
Author: M KUMAR, India
Date: May 30, 2017, 16:55, 81 days ago
Os info: Linux 6
Oracle info: 11.2.0.3
Message: I have created sql query to pull total time taken by the queries day wise for specific users and module but its giving me multiple same values(sql_id, sql_exec_start). I am looking for distinct sql_id and time taken by them in the last 10 days.

SELECT a.sql_id, b.sql_exec_start, a.module, a.parsing_schema_name,
a.executions_total, a.elapsed_time_total
FROM dba_hist_sqlstat a, dba_hist_active_sess_history b
WHERE a.sql_id = b.sql_id
AND a.parsing_schema_name IN ('TED', 'MAC', 'JOHN')
AND a.module LIKE '%ACCESS%'
AND TRUNC (b.sql_exec_start) >= SYSDATE - 11
ORDER BY sql_exec_start ASC
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Elapsed time of queries daywise.
Author: M KUMAR, India
Date: Jun 02, 2017, 22:58, 78 days ago
Message: Or is there any other way to pull elapsed_time of a user's queries day wise for the last 7 days.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Elapsed time of queries daywise.
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Jun 05, 2017, 06:50, 75 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Dear Kumar,

Please check below mos notes on AWR and DBA_HIST_SQLSTAT you may get some clue or way from this note

Performance Diagnosis with Automatic Workload Repository (AWR) (Doc ID 1674086.1)

Top SQL Statement Missing from DBA_HIST_SQLSTAT View (Doc ID 1424839.1)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here