RE: Tracing a user session with multiple database connections
Title: RE: Tracing a user session with multiple database connections It may need some changes for the Alter Session syntax but the trigger should help you isolate the activity by these session. HTH Tony Aponte CREATE OR REPLACE TRIGGER sys.trap_conversion_connect_trig AFTER LOGON ON conversion.SCHEMA BEGIN BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT FOREVER,LEVEL 12'''; EXCEPTION WHEN OTHERS THEN SYS.DBMS_SYSTEM.KSDWRT(2,SQLERRM); END; END; -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Sent: Monday, August 18, 2003 11:29 PM To: Multiple recipients of list ORACLE-L Subject: Tracing a user session with multiple database connections We have a third party application which makes multiple connections to the database. The application keeps one connection open for the duration of the session and then opens and closes one or more connections in succession. Some of the connections only last for a few seconds, so running the set_sql_trace_in_session stored procedure by hand is not an option. All of the connections have the same sid. Is there any way to trace all of the connections for a given sid without setting sql_trace for the entire instance? This is Oracle 8.1.7 on AIX 4.3.3. thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Tracing a user session with multiple database connections
Schauss, Peter wrote: Is there any way to trace all of the connections for a given sid without setting sql_trace for the entire instance? You could try creating a trigger to do it. "create trigger foo after login on database ..." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Tracing or not tracing, this is the question now.
Okay Mladen, I'll bite. How about checking the user_dump_dest? David A. Barbour AISD Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student information. Unauthorized use or disclosure is prohibited under the federal Family Education Rights & Privacy Act (20 U.S.C. §1232g; 34 CFR Part 99). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please contact the sender by reply email or by contacting 414-0095 immediately and destroy all copies of the original message, including attachments. "Gogala, Mladen" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc: Sent by: Subject: Tracing or not tracing, this is the question now. [EMAIL PROTECTED] 01/15/2003 03:40 PM Please respond to ORACLE-L I'm looking for a way of checking which sessions on the database have trace turned on. I can set event in another session, but I'd like to know whether the event (10046 in this case) is set in some sessions. Mladen Gogala Oracle DBA Oxford Health Plans www.oxhp.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: RE: Tracing or not tracing, this is the question now.
dbms_system.read_ev is mentioned in the Oracle Internals seminar entitled Dumps, Crashes and Corruptions... created by dbmsutil.sql Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 16, 2003 4:34 AM To: Multiple recipients of list ORACLE-L I am not sure that this answers Mladen's question. A brute force solution, not necessarily very efficient and questionable, security-wise, would be to make user_dump_dest accessible through utl_file, check v$session and see for each session whether there is a matching .trc file - and in fact open it to be sure that it's not an old file which once was associated with an identical pid. One might probably build some dummy view with the object option over this ... Too bad I lack time ... >- Original Message - >From: "Reardon, Bruce (CALBBAY)" ><[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 15 Jan 2003 14:48:48 > >Mladen, > >Form 2 previous list postings: > > >" >-Original Message- >Sent: Wednesday, 30 January 2002 5:51 AM >To: Multiple recipients of list ORACLE-L > > >Here you go... > >1) Find the OSPID for the suspected user (other >than pmon, smon and their >famiy) > >select s.username, p.spid >from v$session s, v$process p >where s.paddr = p.addr; > >2) Use oradebug to connect to that spid (here I >have 26073, and the session >was tracing event 10046) > >SVRMGR> oradebug setospid 26073 >Oracle pid: 11, Unix process pid: 26073, image: >oracle@myservername (TNS >V1-V3) > >3) Dump the events for the connected spid... > >SVRMGR> oradebug dump events 1 >Statement processed. > >4) Look in the trace file in the udump directory.. > > >*** 2002-01-29 09:58:55.847 >Dump event group for level SESSION >TC Addr Evt#(b10) Action TR AddrArm >Life >400E1B68 10046 1 400e1ba8 0 0 >TR Name TR level TR address >TR arm TR life >TR type >CONTEXT 8 > -1 2 >0 >^^^ This session is tracing >event 10046 context at level >8 > >5) Dump it again (from 3)... > >6) Look in the trace file again > >*** 2002-01-29 10:01:57.316 >WAIT #1: nam='SQL*Net message from client' ela= >34381 p1=1650815232 p2=1 >p3=0 >= >PARSING IN CURSOR #1 len=56 dep=0 uid=80 oct=42 >lid=80 tim=2447763925 >hv=3475487367 ad='a0de14e0' >alter session set events '10046 trace name context >off' >END OF STMT >PARSE >EXEC > >-- Oops! The the smart A$$ turned off the trace, >But got caught!!! > >Following is what you see in the trace file when >the session is not >tracing. > >Dump event group for level SESSION >TC Addr Evt#(b10) Action TR AddrArm >Life > >~ > >I thank Ross for his nifty hints and his time last >night, when I was having >a 'brain fart' while testing this... > >I learned something new from him... :) > >Cheers! > >- Kirti >" > >OR > >It would seem this approach will only work for the >current session >" >-Original Message- >[mailto:[EMAIL PROTECTED]] >Sent: Friday, 6 July 2001 10:11 AM >To: Multiple recipients of list ORACLE-L > > > >Hi Walt - > >Kinda getting into this myself recently. I found a >reference to an >undocumented dbms package on Metalink today called: >dbms_system.read_ev > >I'm playing around with their test scripts to see >what I can do with this >in conjunction with v$session and tracing and >auditing. Check out notes >1020308.6 and 28446.1 > >Hope this helps. > >David A. Barbour >Oracle DBA, OCP >AISD >512-414-1002 >" > >-Original Message- >Sent: Thursday, 16 January 2003 8:41 AM > >I'm looking for a way of checking which sessions on >the database have trace turned on. >I can set event in another session, but I'd like to >know whether the event (10046 in this case) >is set in some sessions. >Mladen Gogala >Oracle DBA >Oxford Health Plans >www.oxhp.com >-- >Please see the official ORACLE-L FAQ: >http://www.orafaq.net >-- >Author: Reardon, Bruce (CALBBAY) > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 >http://www.fatcity.com >San Diego, California-- Mailing list and >web hosting services >To REMOVE yourself from this mailing list, send an >E-Mail message >to: [EMAIL PROTECTED] (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). >#1:c=0,e=2,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=2 >447763926 >#1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=2 >447763927 >--
RE: RE: Tracing or not tracing, this is the question now.
I am not sure that this answers Mladen's question. A brute force solution, not necessarily very efficient and questionable, security-wise, would be to make user_dump_dest accessible through utl_file, check v$session and see for each session whether there is a matching .trc file - and in fact open it to be sure that it's not an old file which once was associated with an identical pid. One might probably build some dummy view with the object option over this ... Too bad I lack time ... >- Original Message - >From: "Reardon, Bruce (CALBBAY)" ><[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 15 Jan 2003 14:48:48 > >Mladen, > >Form 2 previous list postings: > > >" >-Original Message- >Sent: Wednesday, 30 January 2002 5:51 AM >To: Multiple recipients of list ORACLE-L > > >Here you go... > >1) Find the OSPID for the suspected user (other >than pmon, smon and their >famiy) > >select s.username, p.spid >from v$session s, v$process p >where s.paddr = p.addr; > >2) Use oradebug to connect to that spid (here I >have 26073, and the session >was tracing event 10046) > >SVRMGR> oradebug setospid 26073 >Oracle pid: 11, Unix process pid: 26073, image: >oracle@myservername (TNS >V1-V3) > >3) Dump the events for the connected spid... > >SVRMGR> oradebug dump events 1 >Statement processed. > >4) Look in the trace file in the udump directory.. > > >*** 2002-01-29 09:58:55.847 >Dump event group for level SESSION >TC Addr Evt#(b10) Action TR AddrArm >Life >400E1B68 10046 1 400e1ba8 0 0 >TR Name TR level TR address >TR arm TR life >TR type >CONTEXT 8 > -1 2 >0 >^^^ This session is tracing >event 10046 context at level >8 > >5) Dump it again (from 3)... > >6) Look in the trace file again > >*** 2002-01-29 10:01:57.316 >WAIT #1: nam='SQL*Net message from client' ela= >34381 p1=1650815232 p2=1 >p3=0 >= >PARSING IN CURSOR #1 len=56 dep=0 uid=80 oct=42 >lid=80 tim=2447763925 >hv=3475487367 ad='a0de14e0' >alter session set events '10046 trace name context >off' >END OF STMT >PARSE >EXEC > >-- Oops! The the smart A$$ turned off the trace, >But got caught!!! > >Following is what you see in the trace file when >the session is not >tracing. > >Dump event group for level SESSION >TC Addr Evt#(b10) Action TR AddrArm >Life > >~ > >I thank Ross for his nifty hints and his time last >night, when I was having >a 'brain fart' while testing this... > >I learned something new from him... :) > >Cheers! > >- Kirti >" > >OR > >It would seem this approach will only work for the >current session >" >-Original Message- >[mailto:[EMAIL PROTECTED]] >Sent: Friday, 6 July 2001 10:11 AM >To: Multiple recipients of list ORACLE-L > > > >Hi Walt - > >Kinda getting into this myself recently. I found a >reference to an >undocumented dbms package on Metalink today called: >dbms_system.read_ev > >I'm playing around with their test scripts to see >what I can do with this >in conjunction with v$session and tracing and >auditing. Check out notes >1020308.6 and 28446.1 > >Hope this helps. > >David A. Barbour >Oracle DBA, OCP >AISD >512-414-1002 >" > >-Original Message- >Sent: Thursday, 16 January 2003 8:41 AM > >I'm looking for a way of checking which sessions on >the database have trace turned on. >I can set event in another session, but I'd like to >know whether the event (10046 in this case) >is set in some sessions. >Mladen Gogala >Oracle DBA >Oxford Health Plans >www.oxhp.com >-- >Please see the official ORACLE-L FAQ: >http://www.orafaq.net >-- >Author: Reardon, Bruce (CALBBAY) > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 >http://www.fatcity.com >San Diego, California-- Mailing list and >web hosting services >To REMOVE yourself from this mailing list, send an >E-Mail message >to: [EMAIL PROTECTED] (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). >#1:c=0,e=2,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=2 >447763926 >#1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=2 >447763927 >--- >-- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a li
RE: Tracing or not tracing, this is the question now.
Mladen, Form 2 previous list postings: " -Original Message- Sent: Wednesday, 30 January 2002 5:51 AM To: Multiple recipients of list ORACLE-L Here you go... 1) Find the OSPID for the suspected user (other than pmon, smon and their famiy) select s.username, p.spid from v$session s, v$process p where s.paddr = p.addr; 2) Use oradebug to connect to that spid (here I have 26073, and the session was tracing event 10046) SVRMGR> oradebug setospid 26073 Oracle pid: 11, Unix process pid: 26073, image: oracle@myservername (TNS V1-V3) 3) Dump the events for the connected spid... SVRMGR> oradebug dump events 1 Statement processed. 4) Look in the trace file in the udump directory.. *** 2002-01-29 09:58:55.847 Dump event group for level SESSION TC Addr Evt#(b10) Action TR AddrArmLife 400E1B68 10046 1 400e1ba8 0 0 TR Name TR level TR address TR arm TR life TR type CONTEXT 8 -1 2 0 ^^^ This session is tracing event 10046 context at level 8 5) Dump it again (from 3)... 6) Look in the trace file again *** 2002-01-29 10:01:57.316 WAIT #1: nam='SQL*Net message from client' ela= 34381 p1=1650815232 p2=1 p3=0 = PARSING IN CURSOR #1 len=56 dep=0 uid=80 oct=42 lid=80 tim=2447763925 hv=3475487367 ad='a0de14e0' alter session set events '10046 trace name context off' END OF STMT PARSE #1:c=0,e=2,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=2447763926 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=2447763927 -- Oops! The the smart A$$ turned off the trace, But got caught!!! Following is what you see in the trace file when the session is not tracing. Dump event group for level SESSION TC Addr Evt#(b10) Action TR AddrArmLife ~ I thank Ross for his nifty hints and his time last night, when I was having a 'brain fart' while testing this... I learned something new from him... :) Cheers! - Kirti " OR It would seem this approach will only work for the current session " -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 July 2001 10:11 AM To: Multiple recipients of list ORACLE-L Hi Walt - Kinda getting into this myself recently. I found a reference to an undocumented dbms package on Metalink today called: dbms_system.read_ev I'm playing around with their test scripts to see what I can do with this in conjunction with v$session and tracing and auditing. Check out notes 1020308.6 and 28446.1 Hope this helps. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 " -Original Message- Sent: Thursday, 16 January 2003 8:41 AM I'm looking for a way of checking which sessions on the database have trace turned on. I can set event in another session, but I'd like to know whether the event (10046 in this case) is set in some sessions. Mladen Gogala Oracle DBA Oxford Health Plans www.oxhp.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: tracing error stack - finding the cause of a ORA-00917 error
You might want to look at dbms_system.set_ev Parameters: sid serial event number level event name -- leave null in your case . Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 20 December 2002 19:28 >I am working on figuring out an error in an application caused by >dynamically generated sql. I've set init parameters in the past to >generate a trace file for a specific error and its been very helpful in >finding the source of this sort of error. > >Is there a way to run this sort of trace on a session or the system >without setting it in the init file and restarting? > > > >-- >Glenn Stauffer <[EMAIL PROTECTED]> > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Tracing sequences (was re: freelist tesing)
if you return the seq nextval by a function you can track it. So, let your developers avoid 'select seq.nextval into ... from dual;' syntax. Then use autonomous transactions to log the next value that is being returned to another table, which you can monitor. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: Tracing a session - weird problem
I can't bounce the database right now. Exactly what do you mean disconnect and connect? I did exit the session and sells directly into the database and tried to do the trace again and it did not create a trace file. Kathy -Original Message- Sent: Thursday, November 15, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Hi Kathy, Did you delete the trace on OS level. I have seen cases where the connected processes will not generate traces after u delete the file. If this is not production then you could bounce db or beter disconn and conn again Deepak --- Kathy Duret <[EMAIL PROTECTED]> wrote: > 8.1.6 on HP-UNIX > sqlplus sys/x > > alter session set timed_statistics=true; > > exec > dbms_system.set_sql_trace_in_session(50,23265,true); > exec > dbms_system.set_sql_trace_in_session(50,23265,false); > > I ran these statements got a trace file but NO time > stamps. Since the process was > still running I tried to run it again, but this time > no trace file... I know I have the > correct location for the udump. The file system is > NOT full. What could be going on. > I have never seen this. > > Thanks > > Kathy > > Confidential > This e-mail and any files transmitted with it are > the property > of Belkin Components and/or its affiliates, are > confidential, > and are intended solely for the use of the > individual or > entity to whom this e-mail is addressed. If you are > not one > of the named recipients or otherwise have reason to > believe > that you have received this e-mail in error, please > notify the > sender and delete this message immediately from your > computer. > Any other use, retention, dissemination, forwarding, > printing > or copying of this e-mail is strictly prohibited. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kathy Duret > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Tracing a session - weird problem
Hi Kathy, Did you delete the trace on OS level. I have seen cases where the connected processes will not generate traces after u delete the file. If this is not production then you could bounce db or beter disconn and conn again Deepak --- Kathy Duret <[EMAIL PROTECTED]> wrote: > 8.1.6 on HP-UNIX > sqlplus sys/x > > alter session set timed_statistics=true; > > exec > dbms_system.set_sql_trace_in_session(50,23265,true); > exec > dbms_system.set_sql_trace_in_session(50,23265,false); > > I ran these statements got a trace file but NO time > stamps. Since the process was > still running I tried to run it again, but this time > no trace file... I know I have the > correct location for the udump. The file system is > NOT full. What could be going on. > I have never seen this. > > Thanks > > Kathy > > Confidential > This e-mail and any files transmitted with it are > the property > of Belkin Components and/or its affiliates, are > confidential, > and are intended solely for the use of the > individual or > entity to whom this e-mail is addressed. If you are > not one > of the named recipients or otherwise have reason to > believe > that you have received this e-mail in error, please > notify the > sender and delete this message immediately from your > computer. > Any other use, retention, dissemination, forwarding, > printing > or copying of this e-mail is strictly prohibited. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kathy Duret > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Tracing a sql statement also to include bind variables
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 <[EMAIL PROTECTED]> 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. > >--- [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > >> > >> 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: [EMAIL PROTECTED] (note EXACT spelling of > >> 'ListGuru') and in > >> the message BODY, include a line containing: > UNSUB > >> ORACLE-L > >> (or the name of mailing list you
RE: Tracing a sql statement also to include bind variables
I think it comes with 8.0.4. I don't know exactly. However I enclose it one copy. Regards. --- Mark Leith <[EMAIL PROTECTED]> 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. > >--- [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > >> > >> 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: [EMAIL PROTECTED] (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 > >[EMAIL PROTECTED] > >[EMAIL PROTECTED] >
RE: Tracing a sql statement also to include bind variables
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. >--- [EMAIL PROTECTED] 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: [EMAIL PROTECTED] >> >> 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: [EMAIL PROTECTED] (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 >[EMAIL PROTECTED] >[EMAIL PROTECTED] >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: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists >
RE: Tracing a sql statement also to include bind variables
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. >--- [EMAIL PROTECTED] 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: [EMAIL PROTECTED] >> >> 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: [EMAIL PROTECTED] (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 >[EMAIL PROTECTED] >[EMAIL PROTECTED] >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNS
Re: Tracing a sql statement also to include bind variables
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. >--- [EMAIL PROTECTED] 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 kopieën 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: [EMAIL PROTECTED] >> >> 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: [EMAIL PROTECTED] (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 >[EMAIL PROTECTED] >[EMAIL PROTECTED] >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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
Re: Tracing a sql statement also to include bind variables/SOLVED
Hi Christian, Thx. I studied the manuals this morning but the list was better once again Jack Christian Trassens <[EMAIL PROTECTED]>@fatcity.com on 24-09-2001 13:05:18 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) 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. --- [EMAIL PROTECTED] 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 kopieën 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = De informatie verzonden in dit e
Re: Tracing a sql statement also to include bind variables
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. --- [EMAIL PROTECTED] 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 kopieën 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Tracing
Hello list, Following link explains all issues on sql/event10046 traces: http://www.unal-bilisim.com/products/itrprof/itrprof_user_manual.html#sql_trace 16/7/01 07:10:35, "JOE TESTA" <[EMAIL PROTECTED]> wrote: > > > >and dont do it and try to do an upgrade(which sql_trace=true) , a simple 1 >hour upgrade ran like 16 hours, had me stumped for a while, thankfully the >upgrade scripts can be run multiple time with no impact :) > >joe > > >>>> [EMAIL PROTECTED] 07/16/01 12:00PM >>> > > >Don't do this blindly. Turning sql_trace = TRUE on for the entire >database will decrease performance. And it goes without saying do NOT do >this in production! Session level tracing is more appropriate. > > >Lisa Koivu >Data Bored Administrator >Ft. Lauderdale, FL, USA > > >-Original Message- >From: Ramasamy, Baskar [SMTP:[EMAIL PROTECTED]] > Sent: Monday, July 16, 2001 11:46 AM >To:Multiple recipients of list ORACLE-L >Subject: RE: Tracing > > > > >Best option would be turn on the sql_trace and timed_statistice >parameter > >in init.ora and re-start the database. > >But makes ure you have enought space to write trc files in OS > > >Baskar > > >-Original Message- >Sent: 16 July 2001 16:12 >To: Multiple recipients of list ORACLE-L > > > > > >On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: >> > Hello >> > I would like to start tracing for different session than my one. >How it > >is >> > possible in 8.1.7 EE? I want to start tracing for different >sessions >with > >> > different levels (not necessary diff. levels). I found that it >should be >> > possible with dbms_support package, but i didnt find this package >and I > >> > also didnt find creation script in my rdbms/admin directory (it >should >be >> > dbmssupp.sql). > >> > Please help me where I can find it or how to do it. >> > Ivo Libal > > >dbms_system.set_ev(sid, serial, event, level, NULL); > >-- > >Vladimir Begun | Without freedom of choice there is no >http://vbegun.net/ | creativity. >http://vbegun.net/wap/ | -- Kirk, "The return of the >[EMAIL PROTECTED]| Archons", stardate 3157.4 > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Vladimir Begun > > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: Ramasamy, Baskar > INET: [EMAIL PROTECTED] > > >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: [EMAIL PROTECTED] (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: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Tracing
and dont do it and try to do an upgrade(which sql_trace=true) , a simple 1 hour upgrade ran like 16 hours, had me stumped for a while, thankfully the upgrade scripts can be run multiple time with no impact :) joe >>> [EMAIL PROTECTED] 07/16/01 12:00PM >>> Don't do this blindly. Turning sql_trace = TRUE on for the entire database will decrease performance. And it goes without saying do NOT do this in production! Session level tracing is more appropriate. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Ramasamy, Baskar [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: Tracing Best option would be turn on the sql_trace and timed_statistice parameter in init.ora and re-start the database. But makes ure you have enought space to write trc files in OS Baskar -Original Message- Sent: 16 July 2001 16:12 To: Multiple recipients of list ORACLE-L On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: > > Hello > > I would like to start tracing for different session than my one. How it is > > possible in 8.1.7 EE? I want to start tracing for different sessions with > > different levels (not necessary diff. levels). I found that it should be > > possible with dbms_support package, but i didnt find this package and I > > also didnt find creation script in my rdbms/admin directory (it should be > > dbmssupp.sql). > > Please help me where I can find it or how to do it. > > Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, "The return of the [EMAIL PROTECTED] | Archons", stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ramasamy, Baskar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Tracing
Title: RE: Tracing Don't do this blindly. Turning sql_trace = TRUE on for the entire database will decrease performance. And it goes without saying do NOT do this in production! Session level tracing is more appropriate. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Ramasamy, Baskar [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: Tracing Best option would be turn on the sql_trace and timed_statistice parameter in init.ora and re-start the database. But makes ure you have enought space to write trc files in OS Baskar -Original Message- Sent: 16 July 2001 16:12 To: Multiple recipients of list ORACLE-L On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: > > Hello > > I would like to start tracing for different session than my one. How it is > > possible in 8.1.7 EE? I want to start tracing for different sessions with > > different levels (not necessary diff. levels). I found that it should be > > possible with dbms_support package, but i didnt find this package and I > > also didnt find creation script in my rdbms/admin directory (it should be > > dbmssupp.sql). > > Please help me where I can find it or how to do it. > > Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, "The return of the [EMAIL PROTECTED] | Archons", stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ramasamy, Baskar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Tracing
Best option would be turn on the sql_trace and timed_statistice parameter in init.ora and re-start the database. But makes ure you have enought space to write trc files in OS Baskar -Original Message- Sent: 16 July 2001 16:12 To: Multiple recipients of list ORACLE-L On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: > > Hello > > I would like to start tracing for different session than my one. How it is > > possible in 8.1.7 EE? I want to start tracing for different sessions with > > different levels (not necessary diff. levels). I found that it should be > > possible with dbms_support package, but i didnt find this package and I > > also didnt find creation script in my rdbms/admin directory (it should be > > dbmssupp.sql). > > Please help me where I can find it or how to do it. > > Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, "The return of the [EMAIL PROTECTED]| Archons", stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ramasamy, Baskar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Tracing
Ivo, See Metalink Note 1058210.6 for more details on ORADEBUG. HTH Srini Chavali Oracle DBA Cummins Inc "Libal, Ivo" <[EMAIL PROTECTED]>@fatcity.com on 07/16/2001 09:45:36 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: > Hello > I would like to start tracing for different session than my one. How it is > possible in 8.1.7 EE? I want to start tracing for different sessions with > different levels (not necessary diff. levels). I found that it should be > possible with dbms_support package, but i didnt find this package and I > also didnt find creation script in my rdbms/admin directory (it should be > dbmssupp.sql). > Please help me where I can find it or how to do it. > Ivo Libal > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Tracing
Here you have: --- "Libal, Ivo" <[EMAIL PROTECTED]> wrote: > > > Hello > > I would like to start tracing for different > session than my one. How it is > > possible in 8.1.7 EE? I want to start tracing for > different sessions with > > different levels (not necessary diff. levels). I > found that it should be > > possible with dbms_support package, but i didnt > find this package and I > > also didnt find creation script in my rdbms/admin > directory (it should be > > dbmssupp.sql). > > Please help me where I can find it or how to do > it. > > Ivo Libal > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Libal, Ivo > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ dbms_support.zip
Re: Tracing
On Jul 16, 2001 at 07:12:00AM, Vladimir Begun wrote: > On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: > > > Hello > > > I would like to start tracing for different session than my one. How it is > > > possible in 8.1.7 EE? I want to start tracing for different sessions with > > > different levels (not necessary diff. levels). I found that it should be > > > possible with dbms_support package, but i didnt find this package and I > > > also didnt find creation script in my rdbms/admin directory (it should be > > > dbmssupp.sql). > > > Please help me where I can find it or how to do it. > > > Ivo Libal > > dbms_system.set_ev(sid, serial, event, level, NULL); Forgot to mention: 10046 as a value for event. -- Vladimir Begun | Be consistent. http://vbegun.net/ | -- Larry Wall in the perl man http://vbegun.net/wap/ | page [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Tracing
Or with oradebug: oradebug setospid oradebug event 10046 trace name context forever, level <4,8,12> --- Vladimir Begun <[EMAIL PROTECTED]> wrote: > On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: > > > Hello > > > I would like to start tracing for different > session than my one. How it is > > > possible in 8.1.7 EE? I want to start tracing > for different sessions with > > > different levels (not necessary diff. levels). I > found that it should be > > > possible with dbms_support package, but i didnt > find this package and I > > > also didnt find creation script in my > rdbms/admin directory (it should be > > > dbmssupp.sql). > > > Please help me where I can find it or how to do > it. > > > Ivo Libal > > dbms_system.set_ev(sid, serial, event, level, NULL); > > -- > Vladimir Begun | Without freedom of > choice there is no > http://vbegun.net/ | creativity. > http://vbegun.net/wap/ |-- Kirk, "The > return of the > [EMAIL PROTECTED]|Archons", stardate > 3157.4 > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Vladimir Begun > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Tracing
On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: > > Hello > > I would like to start tracing for different session than my one. How it is > > possible in 8.1.7 EE? I want to start tracing for different sessions with > > different levels (not necessary diff. levels). I found that it should be > > possible with dbms_support package, but i didnt find this package and I > > also didnt find creation script in my rdbms/admin directory (it should be > > dbmssupp.sql). > > Please help me where I can find it or how to do it. > > Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, "The return of the [EMAIL PROTECTED]| Archons", stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Tracing Events - Anybody have a list of the Events?
Yeah, thanx all. It seems us poor NT users can't see the events list. We only rate an MSB file, not an MSG file. > -Original Message- > From: Scott Shafer [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 3:19 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > Try oraus.msg (if it exists). Sorry I don't have an NT > install (woohoo! > ;-) to check on... > > Scott Shafer > San Antonio, TX > > > [EMAIL PROTECTED] wrote: > > > > Checking my oraus.msb file on NT, I don't see any list > > of events. Am I missing it or is it not there? I'm on > > 8.1.7 (didn't see it on 8.1.0 either). > > > > Thanks, > > > > yosi > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, July 05, 2001 2:07 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > > > > > > > > > Very cool, Thank You. > > > > > > David A. Barbour > > > Oracle DBA, OCP > > > AISD > > > 512-414-1002 > > > > > > > > > > > > Look near the end (~70% through) of the > > > $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at > least) for events. > > > This is about all I could find. Anyone else? > > > > > > Scott Shafer > > > San Antonio, TX > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Shafer > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Tracing Events - Anybody have a list of the Events?
Try oraus.msg (if it exists). Sorry I don't have an NT install (woohoo! ;-) to check on... Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: > > Checking my oraus.msb file on NT, I don't see any list > of events. Am I missing it or is it not there? I'm on > 8.1.7 (didn't see it on 8.1.0 either). > > Thanks, > > yosi > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, July 05, 2001 2:07 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > > > > > Very cool, Thank You. > > > > David A. Barbour > > Oracle DBA, OCP > > AISD > > 512-414-1002 > > > > > > > > Look near the end (~70% through) of the > > $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. > > This is about all I could find. Anyone else? > > > > Scott Shafer > > San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Tracing Events - Anybody have a list of the Events?
Only in UNIX -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 2:07 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > Very cool, Thank You. > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > Scott Shafer > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > o.com> cc: > > Sent by: Subject: Re: > Tracing Events - Anybody have a list of the Events? > root@fatcity. > > com > > > > > > 07/05/2001 > > 11:51 AM > > Please > > respond to > > ORACLE-L > > > > > > > > > > Look near the end (~70% through) of the > $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. > This is about all I could find. Anyone else? > > Scott Shafer > San Antonio, TX > > > [EMAIL PROTECTED] wrote: > > > > Morning Folks - > > > > Hope those of you in the US had a safe and happy 4th - for > those of you > who > > didn't celebrate this particular holiday, hope your day was > also safe and > > happy ( every day should be safe and happy!). > > > > I'm trying to set up some tracing for various > events/levels. Not using > > OEM. In the past (and currently), I've just used: > > event="10046 trace name context forever,level 4" > > > > This of course provides the requisite information, but > really can tell > you > > much more than you want (or need) to know. The trace > levels given on > > Metalink are: > > > > >1 - Enable > standard SQL_TRACE > > > functionality (Default) > > >4 - As > Level 1 PLUS trace bind > > >values > > >8 - As > Level 1 PLUS trace > >waits > > > > >However > they state in multiple > > >messages > that: > > > > > > > > >"Events > should be set only > > >under the > direction of Oracle > > >Support > and/or Development. > >Some > events produce additional > >
RE: Tracing Events - Anybody have a list of the Events?
msG -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 2:07 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > Very cool, Thank You. > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > Scott Shafer > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > o.com> cc: > > Sent by: Subject: Re: > Tracing Events - Anybody have a list of the Events? > root@fatcity. > > com > > > > > > 07/05/2001 > > 11:51 AM > > Please > > respond to > > ORACLE-L > > > > > > > > > > Look near the end (~70% through) of the > $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. > This is about all I could find. Anyone else? > > Scott Shafer > San Antonio, TX > > > [EMAIL PROTECTED] wrote: > > > > Morning Folks - > > > > Hope those of you in the US had a safe and happy 4th - for > those of you > who > > didn't celebrate this particular holiday, hope your day was > also safe and > > happy ( every day should be safe and happy!). > > > > I'm trying to set up some tracing for various > events/levels. Not using > > OEM. In the past (and currently), I've just used: > > event="10046 trace name context forever,level 4" > > > > This of course provides the requisite information, but > really can tell > you > > much more than you want (or need) to know. The trace > levels given on > > Metalink are: > > > > >1 - Enable > standard SQL_TRACE > > > functionality (Default) > > >4 - As > Level 1 PLUS trace bind > > >values > > >8 - As > Level 1 PLUS trace > >waits > > > > >However > they state in multiple > > >messages > that: > > > > > > > > >"Events > should be set only > > >under the > direction of Oracle > > >Support > and/or Development. > >Some > events produce additional > >
RE: Tracing Events - Anybody have a list of the Events?
Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 2:07 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > Very cool, Thank You. > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > Scott Shafer > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > o.com> cc: > > Sent by: Subject: Re: > Tracing Events - Anybody have a list of the Events? > root@fatcity. > > com > > > > > > 07/05/2001 > > 11:51 AM > > Please > > respond to > > ORACLE-L > > > > > > > > > > Look near the end (~70% through) of the > $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. > This is about all I could find. Anyone else? > > Scott Shafer > San Antonio, TX > > > [EMAIL PROTECTED] wrote: > > > > Morning Folks - > > > > Hope those of you in the US had a safe and happy 4th - for > those of you > who > > didn't celebrate this particular holiday, hope your day was > also safe and > > happy ( every day should be safe and happy!). > > > > I'm trying to set up some tracing for various > events/levels. Not using > > OEM. In the past (and currently), I've just used: > > event="10046 trace name context forever,level 4" > > > > This of course provides the requisite information, but > really can tell > you > > much more than you want (or need) to know. The trace > levels given on > > Metalink are: > > > > >1 - Enable > standard SQL_TRACE > > > functionality (Default) > > >4 - As > Level 1 PLUS trace bind > > >values > > >8 - As > Level 1 PLUS trace > >waits > > > > >However > they state in multiple > > >messages > that: > > > > > > > > >"Events > should be set only > > >under the > direction of Oracle > > >Support > and/or Development. > >Some > events produce additional > > >diagnostic > information, others > >
Re: Tracing Events - Anybody have a list of the Events?
Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Scott Shafer o.com> cc: Sent by: Subject: Re: Tracing Events - Anybody have a list of the Events? root@fatcity. com 07/05/2001 11:51 AM Please respond to ORACLE-L Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: > > Morning Folks - > > Hope those of you in the US had a safe and happy 4th - for those of you who > didn't celebrate this particular holiday, hope your day was also safe and > happy ( every day should be safe and happy!). > > I'm trying to set up some tracing for various events/levels. Not using > OEM. In the past (and currently), I've just used: > event="10046 trace name context forever,level 4" > > This of course provides the requisite information, but really can tell you > much more than you want (or need) to know. The trace levels given on > Metalink are: > >1 - Enable standard SQL_TRACE > functionality (Default) >4 - As Level 1 PLUS trace bind >values >8 - As Level 1 PLUS trace >waits > >However they state in multiple >messages that: > > > >"Events should be set only >under the direction of Oracle >Support and/or Development. >Some events produce additional >diagnostic information, others >are intrusive into database > operations, while others can >effect data in the database. >Syntax varies between events >as does the meaning of the >level. Oracle > Support/Development will >identify the proper syntax and >level (if applicable) you >should use." > >In my handy copy of Steve >Adam's Oracle 8i internals, he >gives three different trace &g
RE: Tracing Events - Anybody have a list of the Events?
All the events are there in $ORACLE_HOME/rdbms/mesg/oraus.msg The ones you're interested in are the ones above 1. Regards, Waleed -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 12:11 PM To: Multiple recipients of list ORACLE-L Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used: event="10046 trace name context forever,level 4" This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are: 1 - Enable standard SQL_TRACE functionality (Default) 4 - As Level 1 PLUS trace bind values 8 - As Level 1 PLUS trace waits However they state in multiple messages that: "Events should be set only under the direction of Oracle Support and/or Development. Some events produce additional diagnostic information, others are intrusive into database operations, while others can effect data in the database. Syntax varies between events as does the meaning of the level. Oracle Support/Development will identify the proper syntax and level (if applicable) you should use." In my handy copy of Steve Adam's Oracle 8i internals, he gives three different trace events (one of which is a level 13 - what the heck is that?), but they're all memory related. Does anyone have a list of the events/levels they would care to share? Regards, David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Khedr, Waleed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT
Re: Tracing Events - Anybody have a list of the Events?
Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: > > Morning Folks - > > Hope those of you in the US had a safe and happy 4th - for those of you who > didn't celebrate this particular holiday, hope your day was also safe and > happy ( every day should be safe and happy!). > > I'm trying to set up some tracing for various events/levels. Not using > OEM. In the past (and currently), I've just used: > event="10046 trace name context forever,level 4" > > This of course provides the requisite information, but really can tell you > much more than you want (or need) to know. The trace levels given on > Metalink are: > >1 - Enable standard >SQL_TRACE >functionality >(Default) >4 - As Level 1 PLUS >trace bind >values >8 - As Level 1 PLUS >trace >waits > >However they state in >multiple >messages that: > > > >"Events should be set >only >under the direction >of Oracle >Support and/or >Development. >Some events produce >additional >diagnostic >information, others >are intrusive into >database >operations, while >others can >effect data in the >database. >Syntax varies between >events >as does the meaning >of the >level. Oracle >Support/Development >will >identify the proper >syntax and >level (if applicable) >you >should use." > >In my handy copy of >Steve >Adam's Oracle 8i >internals, he >gives three different >trace >events (one of which >is a >level 13 - what the >heck is >that?), but they're >all memory >related. > >Does anyone have a >list of the >events/levels they >would care >to share? > >Regards, > > > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Tracing PL/SQL-Calls
See note: 52481.1 -- Vladimir Begun | if (rsfp = mypopen("/bin/mail root","w")) { http://vbegun.net/ | /* heh, heh */ http://vbegun.net/wap/ | -- Larry Wall in perl.c from [EMAIL PROTECTED]| the perl source code -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Tracing PL/SQL-Calls
Did you have TOAD ? If so then you can enable debug mode and trace the package until the detail of calling of procedure /function as nested as possible. In the same time you can activate the watch {to show you the values of the variable} -Original Message- Sent: Monday, June 25, 2001 5:36 PM To: Multiple recipients of list ORACLE-L Hi, we have some trouble with an application, which calls rapidly several PL/SQL-packages. The trouble seems to be inside the packages, but I need the exact order of PL/SQL-calls and the values put into the parameters. Then I can debug the packages by hand. How can I trace the calling session and monitor the PL/SQL-calls only? Thanx for the advice Marc Blum SOPTIM GmbH Grüner Weg 22-24 D-52070 Aachen Telefon:+49 241 / 9 18 79-33 Fax:+49 241 / 15 40 38 mailto:[EMAIL PROTECTED] http://www.soptim.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).