sesions window

[rbrooker]

Hi,

im on a rac system and am having trouble seeing all sessions in the session browser. i have modified the query to reference gv$ views, rather than v$ views, but to get the sql and cursors etc, i need to specify instance. :sid works, but there is no :instance. am i missing something?

 

[Marco Kalter]

You need to use :inst_id.

For the detail queries you can use any bind variable with the name of a field of the session filter query, and prefix it with a colon. For example:

select * from gv$open_cursor
 where inst_id = :inst_id
   and sid = :sid

 

[rbrooker]

thanks.