Home -> Mailing Lists -> Oracle-L -> serial#, last_call_et for long running queries

serial#, last_call_et for long running queries

From: amonte <ax.mount_at_gmail.com>
Date: Tue, 16 Sep 2014 19:51:00 +0200
Message-ID: <CABV7K9uj9zkHHj==zcTvBLU5tt5BRGiK-kFt9289WhJfUY9Dyg_at_mail.gmail.com> 





Hello



In order to identify long running queries I have been using last_call_et,
if a session with a large last_call_et then it has not changed query.



Is it more useful add serial#? Since serial# does not change in a long
running query neither?



Thank you



Alex


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


Received on Tue Sep 16 2014 - 19:51:00 CEST












Original text of this message