USERS_EXECUTING in V$SQLAREA

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: 6 Jul 2001 07:35:31 -0700
Message-ID: <f98999c8.0107060635.103c0c4b@posting.google.com>

I want to monitor the progress of a 3rd party tool that is running SQL against a database. It doesn't do any logging until the process finishes.

Is looking in V$SQLAREA for "USERS_EXECUTING = 1" a reasonable way of determining what is actually happening in the DB at any given time?

The only other way that I've come up with is ORDER BY FIRST_LOAD_TIME DESC, but that can be misleading due to reuse of cursors.

Thank you for any advice. Received on Fri Jul 06 2001 - 09:35:31 CDT