RE: Trace Analyzer and bind variables

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Wed, 10 Oct 2007 17:19:03 -0400
Message-ID: <21469B88E0EA11498818517F21033531DEF54B@EPRI17P32001A.csfb.cs-group.com>

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_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sweetser, Joe Sent: Wednesday, October 10, 2007 4:33 PM To: oracle-l_at_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 Received on Wed Oct 10 2007 - 16:19:03 CDT