open cursors
We experienced an ORA-01000 on our 19.12 database, I'm checking what is using these cursors, but I found some weird things:
The database reports open_cursors to be 2000
When I look into OEM (who reported my ORA-01000 initially), and I look into Metric "Database Limits \ Current Open Cursors Count", the values shown there are constantly above 2000.
Currently, for the same database having reported the ORA error, it is back to around 6000
My question here is: if the database limits to 2000, why is it passing that value nevertheless ?
The question here is NOT what is causing the cursor usage, that is another thing.
The database reports open_cursors to be 2000
When I look into OEM (who reported my ORA-01000 initially), and I look into Metric "Database Limits \ Current Open Cursors Count", the values shown there are constantly above 2000.
Currently, for the same database having reported the ORA error, it is back to around 6000
My question here is: if the database limits to 2000, why is it passing that value nevertheless ?
The question here is NOT what is causing the cursor usage, that is another thing.
0