This video will be focused on next menu - Open Cursors
We will choose a database for monitoring
Refresh rate and Count number
In case that we want to see a detail, for example of this database,
we need to click on it,
and here we can see different queries running for this particular session.
You can use double-click if you want to display detail for this query.
In top section of this screen you can find limit for Open Cursors.
In case that there will be running difficult processes these graphs will move higher
You can check Top Top, sum of Open Cursors, in this case 25
on instance 1 and SID of this session is 668.
We can display detail.
Now we can see detail of running queries.
In left section we can choose which type we want to monitor
We can choose current.
They are already displaying, there are 30
Click, and here are details of all running queries.
Here are displayed User Name, Query ID, SQL Text.
Also when it was last active and Cursor type
That's all for Open Cursors.