title: Find the no open cursor without DBA Access
body: <p>I am getting  </p>
  
  <blockquote>
    <p>java.sql.SQLException: ORA-01000: maximum open cursors exceeded" </p>
  </blockquote>
  
  <p>error. I want to know the no of open cursors in my Db. I don't have DBA access. I have written the following procedure to delete the thousands/lac of record from DB:  </p>
  
  <pre><code>"create or replace //creating procedure
  PROCEDURE SUBSREMOVAL AS 
  BEGIN
    DBMS_OUTPUT.PUT_LINE('----DELETING ROW FROM table1 TABLE START------' );
    DELETE from  table1 c where c.X in (select t.Y from table2 t);//delete query
      DBMS_OUTPUT.PUT_LINE('----DELETING ROW FROM table1 TABLE END------' );
    COMMIT;
  END SUBSREMOVAL"  //ending procedure
  </code></pre>