Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 24595 invoked from network); 10 Oct 2007 17:06:33 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 10 Oct 2007 17:06:29 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E08F07949D7;
 Wed, 10 Oct 2007 18:06:26 -0400 (EDT)
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 18823-10; Wed, 10 Oct 2007 18:06:26 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 006267949CE;
 Wed, 10 Oct 2007 18:06:25 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 10 Oct 2007 17:20:28 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1E9157956D2
 for <oracle-l@freelists.org>; Wed, 10 Oct 2007 17:20:28 -0400 (EDT)
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 11984-03 for <oracle-l@freelists.org>;
 Wed, 10 Oct 2007 17:20:27 -0400 (EDT)
Received: from nys17a-3004.corpny.csfb.com (mail-gw19.credit-suisse.com [198.240.130.184])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 517E679557B
 for <oracle-l@freelists.org>; Wed, 10 Oct 2007 17:20:17 -0400 (EDT)
Received: by nys17a-3004.corpny.csfb.com; Wed, 10 Oct 2007 17:19:21 -0400 (EDT) 
X-Server-Uuid: 0B8A1BB7-B238-48F9-9D9D-7A0E644CA9BB
Content-class: urn:content-classes:message
MIME-Version: 1.0
X-MimeOLE: Produced By Microsoft Exchange V6.5
Subject: RE: Trace Analyzer and bind variables
Date: Wed, 10 Oct 2007 17:19:03 -0400
Message-ID: <21469B88E0EA11498818517F21033531DEF54B@EPRI17P32001A.csfb.cs-group.com>
In-Reply-To: <E323160E08E560459CD05A883546C3CE0A8ABFC5@earthquake.ICAT.COM>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Trace Analyzer and bind variables
References: <E323160E08E560459CD05A883546C3CE0A8ABFC5@earthquake.ICAT.COM>
From: "Baumgartel, Paul" <paul.baumgartel@credit-suisse.com>
To: JSweetser@icat.com, oracle-l@freelists.org
X-OriginalArrivalTime: 10 Oct 2007 21:19:03.0942 (UTC)
 FILETIME=[2F21BA60:01C80B83]
X-WSS-ID: 6B139E423A0782248-01-05
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis
X-archive-position: 2259
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: paul.baumgartel@credit-suisse.com
Precedence: normal
Reply-to: paul.baumgartel@credit-suisse.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain

Trace level must be 12 to show binds. 

You can also use dbms_support (install via
$ORACLE_HOME/rdbms/admin/dbmssupp.sql):

Dbms_support.start_trace_in_session(<sid>,<serial>, waits=>true,
binds=>true)

Or dbms_monitor.session_trace_enable (same parameters) in 10g. 


Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@credit-suisse.com
www.credit-suisse.com


-----Original Message-----
From: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org] On Behalf Of Sweetser, Joe
Sent: Wednesday, October 10, 2007 4:33 PM
To: oracle-l@freelists.org
Subject: Trace Analyzer and bind variables

Hi all -

I can't seem to find the value of the bind variables in my trace
analyzer output and I read here
(http://www.oracleutilities.com/Packages/trca.html) that they should be
displayed.  I created the following logon trigger for the user I am
concerned with:

AFTER LOGON ON DATABASE
begin
 if user like 'SSSQ%' then
  execute immediate 'alter session set timed_statistics=true';
  execute immediate 'alter session set max_dump_file_size=unlimited';
  execute immediate 'alter session set events ''10046 trace name context
forever, level 8''';
 end if;
end;

Am I missing something obvious?  The trace level?

Any/all ideas/suggestions much appreciated.

thanks,
-joe
 
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient,
you should not use, copy, disclose, distribute or take any action based
on this message. If you have received this message in error, please
advise the sender immediately by reply email and delete this message.
Although ICAT Managers, LLC scans e-mail and attachments for viruses, it
does not guarantee that either are virus-free and accepts no liability
for any damage sustained as a result of viruses.  Thank you.

--
http://www.freelists.org/webpage/oracle-l



==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

--
http://www.freelists.org/webpage/oracle-l