Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 14474 invoked from network); 14 Dec 2007 01:58:58 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 14 Dec 2007 01:58:52 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1D0CA7D8EA4; Fri, 14 Dec 2007 02:58:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03235-07; Fri, 14 Dec 2007 02:58:44 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7BDA37D8E91; Fri, 14 Dec 2007 02:58:44 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 14 Dec 2007 02:11:48 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E416E7D8967 for ; Fri, 14 Dec 2007 02:11:47 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25970-02 for ; Fri, 14 Dec 2007 02:11:47 -0500 (EST) Received: from pro38.abac.com (pro38.abac.com [66.226.64.39]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 790037D87C9 for ; Fri, 14 Dec 2007 02:11:47 -0500 (EST) Received: from BHAIRAVIPC01 (c-24-8-13-142.hsd1.co.comcast.net [24.8.13.142]) (authenticated bits=0) by pro38.abac.com (8.14.1/8.14.1) with ESMTP id lBE7Bfes084652 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Thu, 13 Dec 2007 23:11:43 -0800 (PST) (envelope-from krish.hariharan@quasardb.com) From: To: Cc: "'oracle-l'" , "'Jared Still'" References: <666b99c70712111810o4da9943yef8beae1100b4fa9@mail.gmail.com> <666b99c70712131925k3f549363j8e0f1ad0ea1a36b8@mail.gmail.com> Subject: RE: how to trace OCIStmtExecute failed ORA-00028: your session has been killed Date: Fri, 14 Dec 2007 00:11:40 -0700 Message-ID: <000301c83e20$94216030$6401a8c0@BHAIRAVIPC01> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0004_01C83DE5.E7C28830" In-Reply-To: <666b99c70712131925k3f549363j8e0f1ad0ea1a36b8@mail.gmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-Spam-Score: 0.751 (HTML_MESSAGE,NO_REAL_NAME) X-archive-position: 3938 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: krish.hariharan@quasardb.com Precedence: normal Reply-to: krish.hariharan@quasardb.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_NextPart_000_0004_01C83DE5.E7C28830 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Didn't solve the mystery but eliminated a couple of paths since I was curious about the error. If you have resource limit set and profile with idle time, or your server process was killed, you get a different error than the ORA-28. It then appears that only a kill session tends to yield this error. I am curious, however, about the timing of the message and the error stack. These errors are not reported until the client tries to act again. Would that still maintain information about the circumstances that caused the disconnect? -Krish Not sure if you had already checked the sql area and su log SQL> select sql_text from v$sqlarea where sql_text like 'alter system%' ; SQL_TEXT ---------------------------------------------------------------------------- ---- alter system kill session '28,29909' alter system set resource_limit = true IDLE Time --------------- SQL> select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual ; select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual * ERROR at line 1: ORA-02396: exceeded maximum idle time, please connect again Kill Session ------------------ SQL> select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual ; select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual * ERROR at line 1: ORA-00028: your session has been killed Server process killed -------------------------------- SQL> select sysdate from dual ; select sysdate from dual * ERROR at line 1: ORA-03113: end-of-file on communication channel ------=_NextPart_000_0004_01C83DE5.E7C28830 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Didn’t solve the mystery but eliminated a couple of paths since I was curious about the error.  = If you have resource limit set and profile with idle time, or your server = process was killed, you get a different error than the ORA-28. It then appears that = only a kill session tends to yield this error.

 

I am curious, however, about the = timing of the message and the error stack. These errors are not reported until the = client tries to act again. Would that still maintain information about the circumstances that caused the disconnect?

 

-Krish

 

Not sure if you had already checked = the sql area and su log

 

SQL> select sql_text from = v$sqlarea where sql_text like 'alter system%' ;

 

SQL_TEXT

------------------------------------= --------------------------------------------

=

alter system kill session = '28,29909'

alter system set resource_limit =3D = true

 

 

IDLE = Time

---------------

SQL> select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual ;

select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual

*

ERROR at line = 1:

ORA-02396: exceeded maximum idle = time, please connect again

 

Kill = Session

------------------=

SQL> select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual ;

select to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS') cdate from dual

*

ERROR at line = 1:

ORA-00028: your session has been = killed

 

Server process = killed

--------------------------------

SQL> select sysdate from dual = ;

select sysdate from = dual

*

ERROR at line = 1:

ORA-03113: end-of-file on = communication channel

------=_NextPart_000_0004_01C83DE5.E7C28830-- -- http://www.freelists.org/webpage/oracle-l