Re: Net problem

Steve wrote:

> Hello,
>
> I have a problem with connections timing out after about 45mins. I
> see quite a few others have had this problem in the past but so far I
> have not found a solution that works for us.
>
> I can initiate connections through sql*plus to our 3 production
> databases and
> after 45mins of inactivity two of the connections will time out. The
> kicker is the third database never loses its connection. I have gone
> through metastink and support but so far have not found an answer. If
> anyone has had this problem and found a way around it please let me
> know.
>
> Thanks

Start with the basics:

SELECT *
FROM dba_profiles
WHERE resource_name = 'IDLE_TIME';

That would be my first choice on how to knock you off the system. And darn it you should be knocked off the system. You have no business having a connection that is idle for 45 minutes ... either log off or get back to work. ;-)

If this is the answer ... tell you DBA I whole heartedly approve.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)