Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: open cursors...
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
![]() |
![]() |