Re: Query to show db locks?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Mon, 06 Dec 2004 22:43:59 +0100
Message-ID: <9hk9r0t8iat3kb9u0kdftusmadi79pvkup@4ax.com>

On 6 Dec 2004 12:59:32 -0800, "Stefan" <stefan_at_dragolov.com> wrote:

>Does anyone have a better query or know of the query that is used in
>OEM to generate this information?

OEM queries are submitted using ordinary sql, so they will appear in v$open_cursor for the OEM session and v$sqlarea, etc, etc. Moreover they all have /* OEM following the SELECT keyword. The query shouldn't be too difficult to find. The other query is definitely correct.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Dec 06 2004 - 15:43:59 CST