- Trending Categories
- Data Structure
- Operating System
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to display open cursors in Oracle?
You want to display open cursors in Oracle.
We can query the data dictionary to determine the number of cursors that are open per session. "V$SESSION" provides a more accurate number of the cursors currently open than "V$OPEN_CURSOR".
select a.value ,c.username ,c.machine ,c.sid ,c.serial# from v$sesstat a ,v$statname b ,v$session c where a.statistic# = b.statistic# and c.sid = a.sid and b.name = 'opened cursors current' and a.value != 0 and c.username IS NOT NULL order by 1,2;
The OPEN_CURSORS initialization parameter determines the maximum number of cursors a session can have open.
- Cursors in Oracle DBMS
- How to display a SQL execution progress along with execution plan in Oracle?
- How to PIVOT results in Oracle?
- How to UNPIVOT results in Oracle?
- How to traverse Hierarchical data in Oracle?
- How to cache query results in Oracle?
- How to use DATETIME functions in Oracle?
- How to find and replace text in Oracle?
- How to perform string aggregation/concatenation in Oracle?
- How to change the JOIN order in Oracle?
- How to change the JOIN Method in Oracle ?
- How to monitor temporary tablespace usage in Oracle?
- How to insert and retrieve dates in Oracle ?
- How to capture Oracle errors in PL/SQL?
- How to perform case-insensitive search in Oracle?