Re: Confusion about the query start time

From: Powell, Mark <mark.powell2_at_dxc.com>
Date: Mon, 7 Aug 2017 14:10:03 +0000
Message-ID: <DF4PR84MB0124F3EFDC552732F282EE4DCCB50_at_DF4PR84MB0124.NAMPRD84.PROD.OUTLOOK.COM>

Doesn't that just show that session 262 issued a DML statement followed by a query statement without yet committing the transaction?

Mark Powell
Database Administration
(313) 592-5148

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Cee Pee <carlospena999_at_gmail.com> Sent: Friday, August 4, 2017 11:38:17 PM To: oracle-l_at_freelists.org
Subject: Confusion about the query start time

Users complain about some long running process, I checked the database and I see this:

  1 select s.sid, s.sql_id, s.prev_sql_id, last_call_et, sql_exec_start, START_TIME, USED_UBLK   2* from v$transaction t, v$session s where t.ses_addr = s.saddr

SYS_at_PROD> /

       SID SQL_ID PREV_SQL_ID LAST_CALL_ET SQL_EXEC_START START_TIME USED_UBLK

---------- ------------- ------------- ------------ ----------------- -------------------- ----------
       152 g0ddassbxdnjm 14d7z6mh1sxuz         1923 04-AUG-17 10:17pm 08/04/17 22:16:17             1
       262 2g0db7a4v82j0 3yrm7p2dan49j        24279 04-AUG-17 10:30pm 08/04/17 21:54:16            28
       388 2nt4pv6nacb1t 96g93hntrzjtr         1922 04-AUG-17 10:31pm 08/04/17 22:31:37             1

What is going on with sid 262 and why is there so much discrepancy between last_call_Et, SqlExecStart, and tx.start time?

TIA, CP

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

Received on Mon Aug 07 2017 - 16:10:03 CEST