Oracle APPS Query to get Instance cloned Date

 Query to get Instance cloned Date

select  to_char(CREATION_DATE,'DD/MM/RRRR HH24:MI') from fnd_nodes a ;

OR 

select to_char(resetlogs_time,'DD/MM/RRRR HH24:MI') from v$database ; 

Best Regards,

ORA-01000 maximum open cursors exceeded

When youo get this error: "ora-01000 maximum open cursors exceeded " error during the database operation.

Then check open_cursor parameter 

From Oracle Document:

OPEN_CURSORS

Property	Description
Parameter type	Integer
Default value	50
Modifiable	ALTER SYSTEM
Range of values	0 to 65535
Basic	Yes

OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to prevent a session from opening an excessive number of cursors.

It is important to set the value of OPEN_CURSORS high enough to prevent your application from running out of open cursors. The number will vary from one application to another. Assuming that a session does not open the number of cursors specified by OPEN_CURSORS, there is no added overhead to setting this value higher than actually needed.

SQL> show parameter open_cursors ; 

NAME         TYPE     VALUE
------ ---- -----    --------

open_cursors integer     200 

SQ>

* Change current value of open_cursor parameter, you can change the value according to your resource and database.