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