Sessions Window - SQL Text tab, Statistics tab, Locks tab.

[Rahul P]

Hi,

Re: SESSIONS window (tabs in the bottom of this window).

Short of giving a DBA role to a user in one of our instance, I need the user to be able to see what is in these tabs. It gives the user an error:

table or view does not exists.

I fixed it for him for the 'cursors' tab by giving the user select on 'v_$open_cursors' dictionary view, but, the other tabs don't work.

Please specify the grants I have to give to that user to be able to 'see' those tabs.

In this implementation, the user CANNOT get a DBA role.

 

[Marco Kalter]

If you press the "Define Session Queries" button on the Session Window toolbar, you can see (and change) the exact query for each session filter and detail query.

 

[Rahul P]

Thank you Marco. That worked Perfect.