Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 63E0419602EA for ; Tue, 3 Mar 2015 13:05:13 +0100 (CET) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Tue, 3 Mar 2015 13:05:13 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 863F7265FC; Tue, 3 Mar 2015 07:05:12 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=fail (verification failed; insecure key) header.i=@gmail.com; dkim-adsp=none (insecure policy) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org 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 24xS5LJBLeBH; Tue, 3 Mar 2015 07:05:12 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 28C8826691; Tue, 3 Mar 2015 07:04:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 03 Mar 2015 07:03:34 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4CD2726661 for ; Tue, 3 Mar 2015 07:03:34 -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 OyfWKulp4s5z for ; Tue, 3 Mar 2015 07:03:34 -0500 (EST) Received: from mail-vc0-f169.google.com (mail-vc0-f169.google.com [209.85.220.169]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2279324E9D for ; Tue, 3 Mar 2015 07:03:33 -0500 (EST) Received: by mail-vc0-f169.google.com with SMTP id im6so5357253vcb.0 for ; Tue, 03 Mar 2015 04:03:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=GstjtMt3WOTA88O01qWUKFKoA/pCsJ/y09yVyVRtJ/E=; b=UpDhrTZ5KxHXV6UsIewIdz0bsTzsLpvLDcEC2no/Gzedb0yS2DWBwl1gYs5M4OFriI OczcKlt2Ml7SUCal1/2E/YSaQ9XndDLXHzLZ42kXFUhOqFjQs2DSzz+a3RCXKtWRMrAm 0drKEl1HA3552yXJ7R2O3wBUwCgeKt2N4oIZh8l2cwS67Q2rEwhJmoFslPeYTNDl/6NM 7JqH4uU2O+z+3gUnYQ/AnoP3ylPPeZnGIx/ItOxUR8x76H0WA6nV4DLQam+9VeBUvRMQ 8m8L5nndsonUKfb2/FLkhH8B6N+c1CrSBS9j2qLFzlbQPmR6ehTmQpKYvCBkygaCR4Fx 8Sbw== X-Received: by 10.52.249.1 with SMTP id yq1mr29536853vdc.21.1425384213488; Tue, 03 Mar 2015 04:03:33 -0800 (PST) Received: from [192.168.1.5] (pool-72-73-39-185.clppva.east.verizon.net. [72.73.39.185]) by mx.google.com with ESMTPSA id xp7sm73536vdb.5.2015.03.03.04.03.32 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 03 Mar 2015 04:03:32 -0800 (PST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (1.0) Subject: Re: Debugging a failing trigger From: August Spier In-Reply-To: <298950985.147489.1425381098033.JavaMail.open-xchange@app02.ox.hosteurope.de> Date: Tue, 3 Mar 2015 07:03:29 -0500 Cc: "peter.schauss@ngc.com" , oracle-l Content-Transfer-Encoding: quoted-printable Message-Id: References: <13e24be989ba4e568deb4c87fb10694f@XCGVAG22.northgrum.com> <298950985.147489.1425381098033.JavaMail.open-xchange@app02.ox.hosteurope.de> To: "contact@soocs.de" X-archive-position: 58918 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: gus.spier@gmail.com Precedence: normal Reply-To: gus.spier@gmail.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 Is there documentation or a good article that actually explains "set event" a= nd it's syntax ? I've been looking in the SQL reference , but usually only i= n crisis mode, when I'm too flustered to actually read anything? Thanks, Gus=20 Gus Spier Gus.Spier@gmail.com 540 454 3074 > On Mar 3, 2015, at 06:11, Stefan Koehler wrote: >=20 > Hi Peter, > i can not test it quickly as i have no failing trigger, but the correct ev= ent syntax in this case would be something like this. >=20 > alter session set events '4088 trace name errorstack level 3'; > or > alter system set event=3D'4088 trace name errorstack level 3' scope=3Dspfi= le; >=20 > Best Regards > Stefan Koehler >=20 > Freelance Oracle performance consultant and researcher > Homepage: http://www.soocs.de > Twitter: @OracleSK >=20 >> "Schauss, Peter (ESS)" hat am 2. M=C3=A4rz 2015 u= m 22:50 geschrieben: >>=20 >>=20 >> This is Oracle 11.2.0.4 on Red Hat Linux 6.6. >>=20 >> We have a trigger which is failing and the application, Costpoint 7.1, is= returning ora-4088 and ora-6512 plus line numbers in the trigger code. How >> can I force Oracle to dump a trace file to show me the rest of the error s= tack? >>=20 >> I tried "alter system set event=3Dora-4088 scope =3D spfile" followed by a= restart, but the error does not produce a trace. >>=20 >> What am I missing? >>=20 >> Thanks, >> Peter Schauss >> -- >> http://www.freelists.org/webpage/oracle-l > -- > http://www.freelists.org/webpage/oracle-l >=20 >=20 -- http://www.freelists.org/webpage/oracle-l