Re: Procedure hang, session still there

devjnr_at_gmail.com wrote:
> I'm a pl/sql developer with no access to administrative consoles to
> Oracle Database.
>
> I wrote procedure in a package that is used in production environment
> from about 3 months. Through our developed logging system (all pl/sql
> in procedure) I recently noticed that one procedure hang and remain in
> "running" state.
>
> I can't trace activity on Database, so I guess if there are any ways to
> diagnostic problem and/or to try to reproduce a procedure that hang and
> to debug it.
>
> Any help much appreciated.
>
> Regards.

No Oracle version?

My recommendation ... go talk to the production DBA and recommend that this person do their job. As a developer you have no business being on production. <g>

-- 
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