Re: too many cursors open

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 14 Mar 2007 10:02:48 -0700
Message-ID: <1173891766.831925@bubbleator.drizzle.com>

dean wrote:
> Oracle 10g, Windows.
>
> We are getting a periodic error in an application that says we are
> opening too many cursors, and I am trying to debug this. Is there a
> SQL call to get a count of this number of cursors, so that one can see
> exactly which part of the app is doing the mischief? Or is there
> another approach? We don't see the error in our test machines, only at
> a client site.
>
> Any help appreciated.
>
> Dean

SQL> select object_name from dba_objects

   2 where object_name like 'GV%CURSOR%';

OBJECT_NAME

---

GV_$SQL_SHARED_CURSOR
GV$SQL_SHARED_CURSOR
GV_$OPEN_CURSOR
GV$OPEN_CURSOR
GV_$SESSION_CURSOR_CACHE
GV$SESSION_CURSOR_CACHE
GV_$SYSTEM_CURSOR_CACHE
GV$SYSTEM_CURSOR_CACHE
GV_$SQL_CURSOR
GV$SQL_CURSOR

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Mar 14 2007 - 12:02:48 CDT