Re: open cursors...

From: Suzy Vordos <lvordos_at_uswest.com>
Date: Thu, 01 Jun 2000 09:50:50 -0600
Message-Id: <10515.107405@fatcity.com>

In case anyone is interested, here's what I did. Added event="1000 trace name errorstack level 3" to init.ora, bounced the instance, then a trace file was generated for each occurance. The trace file showed the user, system, executing program, and the table object being accessed, etc. Turns out it's being caused by a Cold Fusion app!

Suzy

Suzy Vordos wrote:
>
> Is there a way to identify which users(s) have an open cursor? We are
> frequently seeing "max open cursors exceeded", open_cursors is set to
> 400. Sure, we can increase open_cursors, but I think the source is bad
> application code, just not sure which user is executing it. The only
> user_name I've found in v$open_cursor is SYS.
Received on Thu Jun 01 2000 - 10:50:50 CDT