Hello,
can i monitoring with toad the open cursors per session ?
Regards
Karsten
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.