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 <ORACLE-L_at_fatcity.com> 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: jonathan_at_jlcomp.demon.co.uk

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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).