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

立即与支持人员聊天

标题

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

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.

要求登录

您需要登录并且已签署最新的维护合同，才可查看 高级知识文章。

建议的内容