Monitoring Open Cursors


can i monitoring with toad the open cursors per session ?



Yes. From the main menu: Database -> Monitor -> Session Browser.

You can select whatever session or sessions you want to monitor, then there is an ‘Open Cursors’ tab on the right which lists them.

No, i want to have the count of open cursors…

It’s an extra click, but you can right-click in that grid to get record count.

Ok, that is ok, but can the count of open cursors are shown in the sessionbrowsergrid ?
that would be much simpler and clearer

If that information were in v$session, I would say yes, but it isn’t. We try to keep that main sessions grid to showing only information from v$session, and then related data in the tabs below.