Re: Help!!! Oracle Optimization Question

Dan wrote:
>
> 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.

The SQL is shared, the cursors are not. Forms is notorious for large amounts of cursors, but tweaking your 'open_cursors' parameter solves any potential problems in most cases.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse