Re: sql start time

Hello Vinay,

Out of curiosity, how did you conclude the SQLs are poorly written?

În sâm., 10 apr. 2021 la 20:47, Vinay Kumar Narisetty < narisetty.vinay_at_gmail.com> a scris:

> We have OLTP and OLAP applications running on the same production
> database. I see a lot of SQL queries poorly written are coming from BI
> system.I enabled statspack and sent the top 10 tuning sql's to BI team.They
> came back and requested me to provide starttime and endtime of sql
> queries.I enabled trace level 7 on statspack report. Is there a way I can
> get starttime and endtime within the statspack report ?
>
> Thanks,
> Vinay
>
> On Sat, Apr 10, 2021 at 10:14 AM Luis Claudio Dias dos Santos <
> lsantos_at_pobox.com> wrote:
>
>> 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