Re: how can I proove Oracle doesn't measure every SQL-execution

From: Martin Berger <>
Date: Tue, 21 Apr 2009 10:37:31 +0200
Message-Id: <>

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,

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

Received on Tue Apr 21 2009 - 03:37:31 CDT

Original text of this message