Re: How to dump UGA ??
If you want to see if tracing is on: alter session set events 'immediate trace name events level 1'; (level 2 for process level events, level 4 for system). You can obviously use the oradebug equivalent, or the dbms_support package to fire this at another session. However - if you can read the session's trace file to find out the result of this command, then you will be able to see from the content of the trace file that it is (or isn't) tracing anyway. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August 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: 04 February 2003 20:10 Thanks Jonathan, I was trying to find where (and how) does it show that sql trace (or event 10046) is enabled in the session. Any pointers?? TIA 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! -Original Message- Sent: Tuesday, February 04, 2003 2:14 PM To: Multiple recipients of list ORACLE-L If you use oradebug you can do: oradebug dump heapdump 4 or oradebug dump heapdump 4100 These options dump the UGA heap. The first is structure only, the second includes content and could get quite large. -- 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: How to dump UGA ??
Title: RE: How to dump UGA ?? Jonathan, Thank you very much ... 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! -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to dump UGA ?? If you want to see if tracing is on: alter session set events 'immediate trace name events level 1'; (level 2 for process level events, level 4 for system). You can obviously use the oradebug equivalent, or the dbms_support package to fire this at another session. However - if you can read the session's trace file to find out the result of this command, then you will be able to see from the content of the trace file that it is (or isn't) tracing anyway. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk *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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: How to dump UGA ??
Jonathan: How about calling the DBMS_SYSTEM.READ_EV procedure? I think this is simpler than going to the UGA dumps.. THe restriction with DBMS_SYSTEM is, you can not get the event settings of the other sessions. But Dumps can. Best Regards, K Gopalakrishnan -Original Message- Lewis Sent: Wednesday, February 05, 2003 10:10 AM To: Multiple recipients of list ORACLE-L If you want to see if tracing is on: alter session set events 'immediate trace name events level 1'; (level 2 for process level events, level 4 for system). You can obviously use the oradebug equivalent, or the dbms_support package to fire this at another session. However - if you can read the session's trace file to find out the result of this command, then you will be able to see from the content of the trace file that it is (or isn't) tracing anyway. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August 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: 04 February 2003 20:10 Thanks Jonathan, I was trying to find where (and how) does it show that sql trace (or event 10046) is enabled in the session. Any pointers?? TIA 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! -Original Message- Sent: Tuesday, February 04, 2003 2:14 PM To: Multiple recipients of list ORACLE-L If you use oradebug you can do: oradebug dump heapdump 4 or oradebug dump heapdump 4100 These options dump the UGA heap. The first is structure only, the second includes content and could get quite large. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan 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: How to dump UGA ??
Title: RE: How to dump UGA ?? KG, That's what I am looking for ... which sessions have trace enabled ...? Developers *forget* to disable tracing in their code when they move it to production ... so I have to investigate ... 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! -Original Message- From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to dump UGA ?? Jonathan: How about calling the DBMS_SYSTEM.READ_EV procedure? I think this is simpler than going to the UGA dumps.. THe restriction with DBMS_SYSTEM is, you can not get the event settings of the other sessions. But Dumps can. Best Regards, K Gopalakrishnan *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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: How to dump UGA ??
Too easy ;) Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August 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: 05 February 2003 20:09 Jonathan: How about calling the DBMS_SYSTEM.READ_EV procedure? I think this is simpler than going to the UGA dumps.. -- 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: How to dump UGA ??
If you use oradebug you can do: oradebug dump heapdump 4 or oradebug dump heapdump 4100 These options dump the UGA heap. The first is structure only, the second includes content and could get quite large. 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 ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August 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: 04 February 2003 18:53 Does anyone know the command to dump UGA? TIA 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! -- 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: How to dump UGA ??
Title: RE: How to dump UGA ?? Thanks Jonathan, I was trying to find where (and how) does it show that sql trace (or event 10046) is enabled in the session. Any pointers?? TIA 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! -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to dump UGA ?? If you use oradebug you can do: oradebug dump heapdump 4 or oradebug dump heapdump 4100 These options dump the UGA heap. The first is structure only, the second includes content and could get quite large. 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2