Re: Any Timeout for Compilation of Invalid Objects

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Wed, 5 Sep 2012 10:32:56 -0500
Message-ID: <CAP79kiT3VkbgO94uU4mCfC6sewSRakpEdmPVkyOPsPrOPHcdng_at_mail.gmail.com>

I'll throw these out there...I'm probably wrong ;) sqlnet.outbound_connect_timeout

Time in seconds after which a connection attempt will be timed out. After timeout, the client will try to connect to the next host on the ADDRESS_LIST. This facilitates quick fail-over in case a system/node is down. This parameter should typically be set to +- 3 seconds. If not set, the client connection will block for the default TCP connect timeout duration.
[edit<http://www.orafaq.com/wiki/index.php?title=Sqlnet.ora&action=edit&section=12> ]tcp.connect_timeout

In 11.1 and above this parameter sets the timeout for establishing a TCP connection.

On Wed, Sep 5, 2012 at 10:07 AM, rjamya <rjamya_at_gmail.com> wrote:

> More specifically objects that depend on db_links, and if those
> db_links are bad, it seems to take forever for compilation process. Is
> there a trick/setting/event/parameter to say, if link is not
> accessible timeout in N seconds ? DB is 11.2.x enterprise edition.
>
> TIA
> Raj
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 05 2012 - 10:32:56 CDT