No question at this time
DBA Top 10
1 B. Vroman 15600
2 M. Cadot 14000
3 A. Kavsek 9900
4 T. Boles 6800
5 J. Schnackenberg 5800
6 M. Hidayathullah ... 4400
7 P. Wisse 2100
8 T. P 700
9 B. Derous 500
9 R. Wauben 500
9 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48192
Total active users1653
Act. users last 24h12
Act. users last hour0
Registered user hits last week361
Registered user hits last month1003
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, 359 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, 356 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, 354 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