Re: select via DB-LINK
Date: Fri, 11 Jan 2008 04:20:09 -0800 (PST)
On 11 Jan, 11:01, tb <t.be..._at_web.de> wrote:
> its simple we have a small perl programm which use a select statement
> via a database link to a remote database (small table only a few
> rows), this works fine and all happy.
> But sometimes this statement hangs, i get no response, so i have to
> kill the session and processes manually. I looking to avoid this
> Can i change my tnsnames.or configuration, can i change the profile
> for this oracle user. A simple check with tnsping is not enough. Any
> idea is welcome.
> best regards
Enable tracing on the session to see what it's waiting for.
HTH -g Received on Fri Jan 11 2008 - 06:20:09 CST