RE: Trace Analyzer and bind variables
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: "Sweetser, Joe" <JSweetser@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Oct 2007 14:37:58 -0600
Arrgh! No sooner do I send this than I search the archives and discover
that I need a level 12 trace.
Sorry for the wasted bandwidth (twice!)
-joe
-----Original Message-----
From: Sweetser, Joe
Sent: Wednesday, October 10, 2007 2:33 PM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
