Re: how can I proove Oracle doesn't measure every SQL-execution
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- Date: Tue, 21 Apr 2009 10:37:31 +0200
Hi Alan,
I also thought about ASH, especially with 'colored SQL' in 11g (to get
better historical info on dedicated SQLs)
BUT ASH does not tell me when the statement was finished (I have to
check wether or not there is a matching entry in the next sampling
periode)
AND I was also asked for the execution time of statements with
expected execution time of 100ms and less - there ASH can not help me
with a sampling period of 1s
thank you for your suggestions, anyway,
Martin
Am 21.04.2009 um 10:30 schrieb Guillermo Alan Bort:
if using ASH this *might* be possible... I'm a bit burnt out now,
but I will look into it tomorrow (hopefully)
Alan Bort
Oracle Certified Professional
--
//www.freelists.org/webpage/oracle-l
Other related posts:
