RE: Session Timeouts...

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/

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


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

Other related posts: