Re: sql start time

From: Karthikeyan Panchanathan <keyantech_at_gmail.com>
Date: Sat, 10 Apr 2021 13:38:46 +0000
Message-ID: <SA0PR02MB748408EE4CE8E7C9ECE2D167FF729_at_SA0PR02MB7484.namprd02.prod.outlook.com>

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

Received on Sat Apr 10 2021 - 15:38:46 CEST