Re: sql start time

For a real long running query ASH (if available to you) can be used.

Check *ashtop.sql* script from Tanel. In most of the cases I just use ashtop.sql to any type of ASH analysis.

Em sáb., 10 de abr. de 2021 10:38, Karthikeyan Panchanathan < keyantech_at_gmail.com> escreveu:

> Check V$SQL which gives SQL first load time and last used time
>
> Also V$SQLAREA for other information
>
>
>
> Get Outlook for iOS <https://aka.ms/o0ukef>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Vinay Kumar Narisetty <narisetty.vinay_at_gmail.com>
> *Sent:* Saturday, April 10, 2021 9:20:47 AM
> *To:* oracle-l <oracle-l_at_freelists.org>
> *Subject:* sql start time
>
> Hi All,
>
> Is there way to get starttime and endtime of sql query ran in database
> using hashvalue or sqlid ?
>
> Thank,
> Vinay
>

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