From oracle-l-bounce@freelists.org Fri Oct 1 12:29:40 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i91HTev00644 for ; Fri, 1 Oct 2004 12:29:40 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i91HTeI00636 for ; Fri, 1 Oct 2004 12:29:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DE07C72C9EC; Fri, 1 Oct 2004 12:35:43 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28615-08; Fri, 1 Oct 2004 12:35:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 467A272DF29; Fri, 1 Oct 2004 12:35:43 -0500 (EST) From: ryan_gaffuri@comcast.net To: davewendelken@earthlink.net, oracle-l@freelists.org Cc: david wendelken Subject: Re: Database objects and internal connections? Date: Fri, 01 Oct 2004 17:34:07 +0000 Message-Id: <100120041734.26469.415D950F000260B4000067652200745672079D9A00000E09A1020E979D@comcast.net> X-Authenticated-Sender: cnlhbl9nYWZmdXJpQGNvbWNhc3QubmV0 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 10573 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan_gaffuri@comcast.net Precedence: normal Reply-To: ryan_gaffuri@comcast.net X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org is oracle breaking your connection with a policy or is it being done by the operating system? ora-3113 usually occurs when the OS times you out. its possible that the OS cut off your connect and your session completed. do an sql_trace to a file, to see what happens. you can do a sqlnet trace on the client to see what happens with your connection. when i time out due to an oracle profile i typically get: ERROR: ORA-02396: exceeded maximum idle time, please connect again rest is inline > > So, that leads me to believe that oracle creates an internal connection to > itself to deal with the objects. > > 1) Can anyone confirm that? dunno, but doubt it. you could just be losing your connection and then the database sessions stays attached. you can test this by tracing your session to a file and seeing what happens. you can determine if its oracle cutting you off by checking dba_users.profile to get your profile, then finding out your time limits. > 2) Can it's timeout setting be different from other "normal" connections? dont think this is what is going on. I think its the OS timing you out. > 3) Any security implications in setting it higher? just means you have more time to be connected. sounds like its your OS timing you out. so its up to your sys admins. > > > -- > http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l