RE: Database tracing
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <dubey.sandeep@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Jan 2006 14:10:02 -0500
Don't forget to set the level:
alter session set events '10046 trace name context forever, level x';
Where x=1, standard SQL_TRACE=TRUE, no waits or binds
x=4, trace + binds
x=8, trace + waits
x=12, trace + binds + waits
Your syntax for disabling trace looks fine to me.
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand
binary, and those who don't."
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sandeep Dubey
Sent: Wednesday, January 11, 2006 1:37 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Database tracing
Hi,
Database 10.2, OS Linux
I used to get the whole database tracing using Alter system set events
'10046 trace name context forever', but now it doesn't seem to work.
I am doing :
SQL>Alter system set events '10046 trace name context forever';
some sql queries
SQL>Alter system set events '10046 trace name context off';
I don't set any trace file in the user_dump_dest directory.
Timed_statistics is TRUE.
Am I missing something?
Thanks
Sandeep
--
//www.freelists.org/webpage/oracle-l
BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD
Other related posts:
