RE: sql_trace deprecated on 10gr2 what to use instead?

  • From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
  • To: <egorst@xxxxxxxxx>, <juancarlosreyesp@xxxxxxxxx>
  • Date: Fri, 11 Nov 2005 16:45:13 +0100

Egor,

you probably mean dbms_session.set_sql_trace --
but onfortunately, that procedure doesn't allow you
to include/exclude bind and wait info in your trace files...

kind regards,

Lex.
 
---------------------------------------------------------------------
Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html
---------------------------------------------------------------------

> DBMS_SESSION , few optoins
> DBMS_SUPPORT, not documented
> DBMS_MONITOR, the winner!!
 
The only problem is that execute of DBMS_MONITOR is not granted by default to
PUBLIC (contrary to DBMS_SESSION).
So, for ordinary developer dbms_session.session_trace_enable is the winner.

As for SQL_TRACE, I think that it's deprecated because you need to have 'alter
session' privilege (which might be a bit dangerous) for using it. So it might be
better to just revoke 'alter session', grant execute on dbms_session to public
and  document sql_trace as deprecated. :)
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD

Other related posts: