From oracle-l-bounce@freelists.org Tue Jan 25 21:37:17 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0Q3bHun020112 for ; Tue, 25 Jan 2005 21:37:17 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0Q3bHem020108 for ; Tue, 25 Jan 2005 21:37:17 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D4BD6303D; Tue, 25 Jan 2005 21:36:30 -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 25965-01; Tue, 25 Jan 2005 21:36:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E4B466321F; Tue, 25 Jan 2005 21:36:29 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=kvsTRcdbgibOu7hJBUrx78sd1aQ5v3gQYPoPCB9WJEZkQbJ72yguHRxy3zduVgM93yX+ShbJ0N9mjlsF/9wEY8v5enheYK911vIUqrJ7cLuQzmspkB2Fo2XJi5a0wr1JDhhK/XgUs3Qzdsod8jfigeJaFYd9UiwLIX56KvL5D+8= Message-ID: <83a585ac050125183418edce2d@mail.gmail.com> Date: Tue, 25 Jan 2005 21:34:49 -0500 From: =?ISO-8859-1?Q?Alfonso_Le=F3n?= To: oracle-l@freelists.org Subject: Trace Files and Stored Procedures Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-archive-position: 15246 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: aleon68@gmail.com Precedence: normal Reply-To: aleon68@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=1.1 required=5.0 tests=AWL,FROM_ENDS_IN_NUMS autolearn=no version=2.60 X-Spam-Level: * I have 2 schemas A contains tables and B contains Stored Procedures when I try to trace the stored procedures It doesn't register the execution plans and the number or records of each step, although it came with the parse, exec and fetch stats. I'm running 9.2.0.5. Any Suggestions? Also do you know if there is a restriction on using SQL_TRACE sometimes it doesn't generate the trace files. Thanks in advance for your suggestios -- Alfonso Leon -- http://www.freelists.org/webpage/oracle-l