maximo open cursor

From sqlplus / as sysdba

SQL> show parameter open_cursors

Or from any dba


SQL> select name, value from v$parameter where name like '%cursor%';

note on privileges...

SELECT_CATALOG_ROLE
or
select any dictionary
or
direct grant to v$parameter is sufficient.

you don't need DBA privileges to query the above info.
also note,  "show parameter" simlply issues a select against v$parameter for you and formats the results
so, if you don't have one or more of the above privileges, it won't work either.

Hi rutgermons,

It is noted by sdstuber that you don't need DBA privs to see that view, however, it is unlikely that you can see that view if you are not a DBA, so you may have to ask your DBA for that info.

I don't condone connecting / as sysdba for every little option, but meant only to provide 2 options in the answer, and I have a bit of a habit of using / as sysdba since often asker's will take suggestions of system/manager literally when "manager" is not their password.