RE: Session Timeouts...
- From: "Luca Canali" <Luca.Canali@xxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Sep 2006 21:36:45 +0200
Have you tried sql tracing your oracle session and/or networking
sniffing (ethereal or tcpdump)the tcp connection? This way you should
quickly be able to understand what causes the problem.
- Luca
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shreeni
Sent: Tuesday, September 19, 2006 8:17 PM
To: 'oracle-l'
Cc: 'Ganesh Raja'
Subject: RE: Session Timeouts...
Yup....I did. The native Oracle SQL*Plus and SQLDeveloper (Oracle's)
dont exhibit this behavior.
Thanks and have a good day.
Shreeni
(630) 401-2887 (Mobile)
(630) 837-1730 (Home)
-----Original Message-----
From: Ganesh Raja [mailto:ganesh.raja@xxxxxxxxx]
Sent: Tuesday, September 19, 2006 1:14 PM
To: shreeni@xxxxxxxxxxxxx
Cc: oracle-l
Subject: Re: Session Timeouts...
Did you check if you are behind a firewall and that is pushing a idle
timeout
- Ganesh
On 9/19/06, Shreeni <shreeni@xxxxxxxxxxxxx> wrote:
> My TOAD connection time-outs almost every 10 mins of idle time. I
> checked my SQLNET.ora and I dont see a timeout mentioned there. Infact
> it is a scimpy file with just two lines -
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
>
> We are on 10.2.0.1 RAC and TOAD is 8.6.0.38. Is there any option with
> TOAD I need to set ? I went thru every option in the Options dialog
> and cant see an option for timeout. I checked the initxxx.ora file if
> there were any params set there but nothing jumps up to suggest that.
> The default user profile says "Unlimited" and there are no
> user-defined User Profiles or Resource Profiles in the database.
>
> Any way to overcome this ?
>
> Thanks and have a good day
>
> Shreeni
>
> Thanks and have a good day.
>
> Shreeni
> (630) 401-2887 (Mobile)
> (630) 837-1730 (Home)
>
>
>
>
--
-----------------------------------------------------------
http://iyertalks.blogspot.com/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
