Cannot see detail info (Sql Text) in Session window

[Paul F]

I seem to have intermittent problems with seeing SQL Text in the session window if I click on a session. Sometimes I can see it, sometimes I can't. Any ideas? Regards, Paul.

 

[Marco Kalter]

What exactly goes wrong? Any error messages?

 

[Paul F]

It seems to be a problem handling RAC - i had to make a custom query to go against gv$session in order to see sessions on both nodes. The sql text is not appearing for the node i am not logged in to. The workaround for now is I log into each node separately and view sessions that way. I can see the sql text, but it's a bit tedious to have 2 windows open. (esp if we expand to more nodes in the future)

 

[Marco Kalter]

You can modify the Session Window queries (both the Session Filter queries and the Session Detail queries) to use the gv$ views.

 

[rbrooker]

make sure you include the instance id in the queries, that got me for a while.