Re: Cannot Set Trace

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sun, 25 Nov 2001 07:58:25 +1100
Message-ID: <3c00097c$0$28128$afc38c87@news.optusnet.com.au>

It certainly does work in 8.1.7. As proof, I offer:

SVRMGR> select * from v$version;
BANNER

---

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production
5 rows selected.

SVRMGR> select sid, serial#, username from v$session; SID SERIAL# USERNAME

---------- ---------- ------------------------------
         1          1
         2          1
         3          1
         4          1
         5          1
         6          1
         7          1
         8         18 DBSNMP
         9        206 SYS
        11       1198 SCOTT

10 rows selected.

SVRMGR> execute sys.dbms_system.set_sql_trace_in_session(11,1198,TRUE) Statement processed.

...And that session then did start producing trace files, in the directory the user_dump_dest parameter was pointing to.

What makes you say it doesn't work?

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Mladen Gogala" <mgogala_at_earthlink.net> wrote in message
news:pan.2001.11.24.14.29.22.641.1224_at_earthlink.net...


> In article <26703915.0111240948.1ddb1da1_at_posting.google.com>, "s.kapitza"

> <skapitza_at_volcanomail.com> wrote:

>


> > hello,

> >

> > you could try also

> >

> > exec sys.dbms_system.set_sql_trace_in_session(<SID>,<SERIAL#>,true);

>


> Bad news. That doesn't work in 8.1.7. Thomas, is that a feature or an

> omission?

> --

> Mladen Gogala

Received on Sat Nov 24 2001 - 14:58:25 CST