Re: ORA-12592: TNS:bad packet on MV refresh
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Tue, 29 Oct 2013 23:11:26 +0100
Message-ID: <5270328E.2090801_at_gmail.com>
On 29/10/2013 23:01, Phillip Jones wrote:
> Whenever I've seen things like this in the past they've been firewall
> timeouts.
Date: Tue, 29 Oct 2013 23:11:26 +0100
Message-ID: <5270328E.2090801_at_gmail.com>
On 29/10/2013 23:01, Phillip Jones wrote:
> Whenever I've seen things like this in the past they've been firewall
> timeouts.
Hi Phil,
I've been told that the firewall idle timeout is set to 1hour.
The MV refresh is failing after 4 - 5 min and it's failing always.
When I run the query manually, it finishes after 10 minutes or so.
Thanks
Dimitre
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 29 2013 - 23:11:26 CET