Help!!! Oracle Optimization Question

From: Dan <pcdanno_at_interaccess.com>
Date: 2000/04/08
Message-ID: <38ee7e8b.645241@nntp.interaccess.com>#1/1

Currently we have a customized Oracle application written in Developer 2000. On any given day, we may have 30 users during peak hours. When I do a query against v$open_cursor I discover that I may have up to 1000 open cursors.

Is this normal? I am concerned because many of the open cursors are from different users running the identical SQL. Correct me if I am mistaken, but doesn't Oracle first check the library cache for an identical SQL statement before parsing it. If that is true, shouldn't I only have one open cursor (and not four) if four users are running the same identical sql statement.

Any thoughts would be appreciated. Received on Sat Apr 08 2000 - 00:00:00 CDT