How do you filter in the Open Cursor grid? Some SQL Text/content not being filtered out as expected. (4225671)

Chat now with support

Zurück

Titel

How do you filter in the Open Cursor grid? Some SQL Text/content not being filtered out as expected.
Beschreibung

In the Session Browser | Open Cursors window is there a way to filter out SQL listed in the grid for the Oracle system objects, i.e. $ tables?
When a filter is applied, some content is not being flitered out as expected.
i.e.
Statement 1:
SELECT INSTANCE_NUMBER FROM SYS.V$INSTANCE
Statement 2:
SELECT o.sid,
o.sql_text,
o.address,
o.hash_value,
o.user_name,
s.schemaname,
o.sql_id
FROM v$open_cursor o, v$session s
WHERE o.saddr = s.saddr AND o.sid = s.sid AND (O.SID = 137)
When the filter is applied, statement 1 is hidden, but statement 2 is not and is still listed in the Open Cursor grid.

Anmeldung erforderlich

Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.

Empfohlener Inhalt