When a SQL statement is executed in Oracle, the temporary context area is created. For one requirement we have created 'n' number of db links. Increase the number of open cursors for the database. where name like 'open-cursors' the value for open_cursors parameter refers to maximum number of open cursors allowed. Long on the list of bloggers has been cursor_sharing, the parameter used to tell Oracle how to treat query text. Typically you want all cursors in a session to be cached to avoid unnecessary parsing. sql> show parameter sessions; sql> show parameter processes . Instead of slowly looping through your data row. ORA-01000: maximum open cursors exceeded - DBAORA Creating tablespaces. Oracle Oracle 11g . First, declare an updatable cursor that updates credits of the customers whose credits are greater than zero. Why does single session need more than 300 concurrent open cursors? Recommendations for geodatabases in Oracle. sqlplus and sqldeveloper does that. In this example, ORACLE_BASE is the root of the Oracle directory tree. Solution to overcome the issue. How To Create Cursor Parameter With Default Value In Oracle Database The below query can be used to determine number of open cursors for the current session. Oracle initialization parameters—Help | ArcGIS Desktop Increase the SHARED POOL SIZE .... - dbasupport.com This area contains all the relevant information relating to the statement and its execution. The time it was asleep is the wait time for "latch free.". session_cached_cursors sizing - dba-oracle.com The session_cached_cursors parameter is used to reduce the amount of parsing with SQL statements that use host variables and with PL/SQL cursors. With a cursor FOR loop, the body of the loop is executed for each row returned by the query. How to increase SGA_MAX_SIZE in Oracle - TechTarget With a numeric FOR loop, the body of the loop executes once for every integer value between the low and high values specified in the range. Parameter type Big integer. So many queries fired to use the dblink and at that time we found below error: "ORA-02020: too many database links in use ". The OPEN_CURSORS parameter sets the maximum number of cursors that each session can have open, per session. SELECT sid,user_name, COUNT . How to find out maximum open cursors and no of cursors open in Oracle