serial#, last_call_et for long running queries

  • From: amonte <ax.mount@xxxxxxxxx>
  • To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 16 Sep 2014 19:51:00 +0200

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2014