Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: set_sql_trace_in_session

RE: set_sql_trace_in_session

From: Orr, Steve <sorr_at_rightnow.com>
Date: Mon, 19 Nov 2001 15:37:07 -0800
Message-ID: <F001.003C8EE4.20011119152522@fatcity.com>

On a
similar note, I'm looking for a way to toggle trace system-wide. Changing the init.ora sql_trace parameter is not an option since it requires recycling the database.
<SPAN

class=429222123-19112001> 
Any
way to turn sql trace on for a few hours and then turn it back off?
<SPAN

class=429222123-19112001> 
<SPAN

class=429222123-19112001> 
Steve
Orr
<SPAN

class=429222123-19112001> 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Hallas John   [mailto:John.Hallas_at_btcellnet.net]Sent: Monday, November 19, 2001   8:36 AMTo: Multiple recipients of list ORACLE-LSubject:   RE: set_sql_trace_in_session
  It is in the 8.1.6 documentation I have just looked at   (Oracle8i Supplied PL/SQL Packages Reference <FONT   size=2>Release 2 (8.1.6) A76936-01
  However I have a page on my website which shows how to put   various bits of tracing on try <A
  href="http://www.hcresources.co.uk"
  target=_blank>http://www.hcresources.co.uk for the home page or <A   href="http://www.hcresources.f2s.com/trace.htm"   target=_blank>http://www.hcresources.f2s.com/trace.htm <FONT   size=2>to go direct.
  John
  -----Original Message----- From: Paul   Baumgartel [<A
  href="mailto:treegarden_at_yahoo.com">mailto:treegarden_at_yahoo.com]   Sent: 19 November 2001 15:05 To:
  Multiple recipients of list ORACLE-L Subject:   set_sql_trace_in_session
  DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION isn't documented in the   8.1.6/7 doc sets.  The package (and the   procedure) exists, though even the package spec source   code is wrapped.  What gives?  Is this package <FONT   size=2>about to be desupported?  Is there an alternative way of setting   trace on in another session?



  Do You Yahoo!? Find the one for you
  at Yahoo! Personals <A
  href="http://personals.yahoo.com"
  target=_blank>http://personals.yahoo.com --   Please see the official ORACLE-L FAQ: <A   href="http://www.orafaq.com" target=_blank>http://www.orafaq.com Received on Mon Nov 19 2001 - 17:37:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US