Re: Oracle Profile Question

amerar_at_iwc.net wrote:
> The symptom is, the session seems to hang forever. It never comes
> back. And, because this is done in a batch job, it looks like the job
> is hung. When the job is cancelled, the session remains an orphan.
>
> We are looking into a way to solve this. You mention testing that the
> link is active. How can you do that without issuing an SQL command?
> If there is a way, then let me know, because I am not familiar with
> one.......
>
> In terms of exception handling, the session hangs, so no exceptions are
> raised. So, that seems like it will not work.......
>
> Arthur

The problem is that it is a symptom ... not a cause. Looking at profiles is an effort pointed in the wrong direction and somewhere between a waste of time and a hornet's nest.

It appears that you have no diagnostics indicating what the underlying problem actually is. I'd suggest that you stop trying to come up with stop-gap solutions and perform the diagnostic tests required to know what is, in fact, really happening.

Start with tracking your SQL*Net connections.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)