From mark@cool-tools.co.uk Wed, 26 Sep 2001 08:06:32 -0700 From: "Mark Leith" Date: Wed, 26 Sep 2001 08:06:32 -0700 Subject: RE: Tracing a sql statement also to include bind variables Message-ID: MIME-Version: 1.0 Content-Type: text/plain You are right -> DBMS_SUPPORT is for 7.something > 8.0.5. 8i > uses DBMS_SYSTEM AFAIK. List, please correct me if I'm wrong.. Mark -----Original Message----- Trassens Sent: Wednesday, September 26, 2001 13:55 To: Multiple recipients of list ORACLE-L I think it comes with 8.0.4. I don't know exactly. However I enclose it one copy. Regards. --- Mark Leith wrote: > WOW!! What a typo!! > > That should of course be *because*.. LOL.. > > Mark > > -----Original Message----- > Sent: Wednesday, September 26, 2001 10:45 > To: Multiple recipients of list ORACLE-L > > > That is beacuase it is not DBMS_SUPPORT, it is > DBMS_SYSTEM: > > exec > sys.dbms_system.set_sql_trace_in_session(sid,serial#,TRUE|FALSE); > > HTH > > Mark > > -----Original Message----- > Subramanian > Sent: Wednesday, September 26, 2001 07:45 > To: Multiple recipients of list ORACLE-L > > > Dear List, > I couldn't find this > dbms_support.start_trace_in_session(,,TRUE,TRUE) > Platform WinNT Oracle 8.1.7 > Pl let me know > venkat > -- > > On Mon, 24 Sep 2001 03:05:19 > Christian Trassens wrote: > >Execute as sys or dba user the package > >dbms_system.set_ev(,,10046,12,''); > > > >Or with oradebug: > > > >oradebug setospid and then > > > >oradebug event 10046 trace name context forever > level > >12 > > > >Or from the user: > > > >alter session set events '10046 trace name context > >forever, level 12'; > > > >Or with the package dbms_support: > > > >dbms_support.start_trace_in_session(,,TRUE,TRUE) > > > >Regards. > >--- nlzanen1@EY.NL wrote: > >> > >> > >> Hi All, > >> > >> > >> I have to trace a sql that a user generates. I > also > >> need the bind > >> variables. > >> > >> Can somebody please enlighten me??? > >> > >> > >> TIA > >> > >> > >> > >> Jack > >> > >> > >===================================================================== > >> De informatie verzonden in dit e-mailbericht is > >> vertrouwelijk en is > >> uitsluitend bestemd voor de geadresseerde. > >> Openbaarmaking, > >> vermenigvuldiging, verspreiding en/of > verstrekking > >> van deze informatie aan > >> derden is, behoudens voorafgaande schriftelijke > >> toestemming van Ernst & > >> Young, niet toegestaan. Ernst & Young staat niet > in > >> voor de juiste en > >> volledige overbrenging van de inhoud van een > >> verzonden e-mailbericht, noch > >> voor tijdige ontvangst daarvan. Ernst & Young kan > >> niet garanderen dat een > >> verzonden e-mailbericht vrij is van virussen, > noch > >> dat e-mailberichten > >> worden overgebracht zonder inbreuk of tussenkomst > >> van onbevoegde derden. > >> > >> Indien bovenstaand e-mailbericht niet aan u is > >> gericht, verzoeken wij u > >> vriendelijk doch dringend het e-mailbericht te > >> retourneren aan de verzender > >> en het origineel en eventuele kopiekn te > verwijderen > >> en te vernietigen. > >> > >> Ernst & Young hanteert bij de uitoefening van > haar > >> werkzaamheden algemene > >> voorwaarden, waarin een beperking van > >> aansprakelijkheid is opgenomen. De > >> algemene voorwaarden worden u op verzoek > kosteloos > >> toegezonden. > >> > >===================================================================== > >> The information contained in this communication > is > >> confidential and is > >> intended solely for the use of the individual or > >> entity to whom it is > >> addressed. You should not copy, disclose or > >> distribute this communication > >> without the authority of Ernst & Young. Ernst & > >> Young is neither liable for > >> the proper and complete transmission of the > >> information contained in this > >> communication nor for any delay in its receipt. > >> Ernst & Young does not > >> guarantee that the integrity of this > communication > >> has been maintained nor > >> that the communication is free of viruses, > >> interceptions or interference. > >> > >> If you are not the intended recipient of this > >> communication please return > >> the communication to the sender and delete and > >> destroy all copies. > >> > >> In carrying out its engagements, Ernst & Young > >> applies general terms and > >> conditions, which contain a clause that limits > its > >> liability. A copy of > >> these terms and conditions is available on > request > >> free of charge. > >> > >===================================================================== > >> > >> > >> > >> > >> > >> -- > >> Please see the official ORACLE-L FAQ: > >> http://www.orafaq.com > >> -- > >> Author: > >> INET: nlzanen1@EY.NL > >> > >> Fat City Network Services -- (858) 538-5051 > FAX: > >> (858) 538-5051 > >> San Diego, California -- Public Internet > >> access / Mailing Lists > >> > >-------------------------------------------------------------------- > >> To REMOVE yourself from this mailing list, send > an > >> E-Mail message > >> to: ListGuru@fatcity.com (note EXACT spelling of > >> 'ListGuru') and in > >> the message BODY, include a line containing: > UNSUB > >> ORACLE-L > >> (or the name of mailing list you want to be > removed > >> from). You may > >> also send the HELP command for other information > >> (like subscribing). > > > > > >===== > >Eng. Christian Trassens > >Senior DBA > >Systems Engineer > >ctrassens@yahoo.com > >ctrassens@hotmail.com > >Phone : 541149816062 > > > >__________________________________________________ > >Do You Yahoo!? > >Get email alerts & NEW webcam video instant > messaging with Yahoo! > Messenger. http://im.yahoo.com > >-- > >Please see the official ORACLE-L FAQ: > http://www.orafaq.com > >-- > >Author: Christian Trassens > > INET: ctrassens@yahoo.com > > > >Fat City Network Services -- (858) 538-5051 > FAX: (858) 538-5051 > >San Diego, California -- Public Internet > access / Mailing Lists > >-------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an > E-Mail message > >to: ListGuru@fatcity.com (note EXACT spelling of > 'ListGuru') and in > >the message BODY, include a line containing: UNSUB > ORACLE-L > >(or the name of mailing list you want to be removed > from). You may > >also send the HELP command for other information > (like subscribing). > > > > > Make a difference, help support the relief efforts > in the U.S. > http://clubs.lycos.com/live/events/september11.asp > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: C.S.Venkata Subramanian > INET: csvenkata@lycos.com > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mark Leith > INET: mark@cool-tools.co.uk > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mark Leith > INET: mark@cool-tools.co.uk > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== Eng. Christian Trassens Senior DBA Systems Engineer ctrassens@yahoo.com ctrassens@hotmail.com Phone : 541149816062 __________________________________________________ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: mark@cool-tools.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).