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 <mark_at_cool-tools.co.uk> 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(<sid>,<serial#>,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(<sid>,<serial#>,10046,12,'');
> >
> >Or with oradebug:
> >
> >oradebug setospid <OSPID of the session> 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(<sid>,<serial#>,TRUE,TRUE)
> >
> >Regards.
> >--- nlzanen1_at_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_at_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_at_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_at_yahoo.com
> >ctrassens_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_yahoo.com
ctrassens_at_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_at_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_at_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).
Received on Wed Sep 26 2001 - 10:06:32 CDT
