No question at this time
DBA Top 10
1 M. Cadot 19800
2 A. Kavsek 13000
3 M. Hidayathullah ... 11400
4 B. Vroman 8500
5 P. Wisse 5900
6 T. Boles 5400
7 J. Schnackenberg 4500
8 P. Knibbs 2200
8 K. Pagadala 2200
10 G. Lambregts 2100
10 K. Van Nieuwenhov... 2100
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 users47979
Total active users1861
Act. users last 24h12
Act. users last hour1
Registered user hits last week625
Registered user hits last month1533
Go up

Get Query timing
Next thread: oracle notes
Prev thread: Refresh Statistik

Message Score Author Date
Hi All, Is there a way i can get timing of each...... Thameera Nawaratna Jan 12, 2017, 04:39
To get it for every time it is executed I don't ...... Michel Cadot Jan 12, 2017, 08:08

Follow up by mail Click here


Subject: Get Query timing
Author: Thameera Nawaratna, Thailand
Date: Jan 12, 2017, 04:39, 166 days ago
Oracle info: Oracle 11gR2
Message: Hi All,

Is there a way i can get timing of each query that combines by union?I want to get the run time of each query every time it the program runs? (I'm using Oracle forms)

for an example:

select a,b
from x
where z<>z

union

select b,c
from y
where w=w

union

select d,e
from v
where u=u

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Get Query timing
Author: Michel Cadot, France
Date: Jan 12, 2017, 08:08, 166 days ago
Message:
To get it for every time it is executed I don't see any other way than activating SQL trace at each time.

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