Re: Help!!! Oracle Optimization Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/08
Message-ID: <955172796.146.1.pluto.d4ee154e@news.demon.nl>#1/1

Check the various address for the cursors. You will see they are identical. This is the way v$open_cursor presents results.

Hth,
Sybrand Bakker, Oracle DBA

"Dan" <pcdanno_at_interaccess.com> wrote in message news:38ee7e8b.645241_at_nntp.interaccess.com...
> 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