Re: sql start time

Hi Vinay,

without AWR I don't see a way to get this data - especially for the past. For the future, you can enable sql trace for these specific SQL_IDs: alter system set events 'sql_trace[sql: cjrha4bzuupzf] level=1';

Level 1 should be sufficient to see when the statement started/stopped.

hth,
 Martin

Am Sa., 10. Apr. 2021 um 15:21 Uhr schrieb Vinay Kumar Narisetty < narisetty.vinay_at_gmail.com>:

> Hi All,
>
> Is there way to get starttime and endtime of sql query ran in database
> using hashvalue or sqlid ?
>
> Thank,
> Vinay
>

-- 
Martin Berger                Oracle ♠
martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
^∆x      http://berxblog.blogspot.com

--
http://www.freelists.org/webpage/oracle-l