Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ADF Database Open Cursors

406750Jul 20 2006 — edited Jul 21 2006

We are using ADF BC4J with Oracle UIX on Jdeveloper 10.1.2. After deploying the application on Oracle IAS 10Rel2 using database connection pooling (similar to the toystore demo) and have 20 users using it, I've noticed that the open cursor count on the database is increasing (up to 1000 open cursors and more). I also noticed that the cursor SQL_TEXT is referencing so dynamic table usage (table_XXXXX).

Is there something I can do to minimize the open cursors and why is ADF using the dynamic tables?

Thanks in advanced,
Stephen

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2006

Added on Jul 20 2006

#application-development-in-java, #jdeveloper-and-adf

4 comments

664 views