Re: dbms_system.set_sql_trace_in_session(SID,SERIAL#,TRUE) not working

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 15 Dec 2000 20:34:23 +0100
Message-ID: <91drl6$3tj81$6@ID-62141.news.dfncis.de>

The script installing the package doesn't seem to create grants and/or public synonyms.
Rerunning dbmsutil.sql and prvtutil.plb should resolve the issue.

Hth,

Sybrand Bakker, Oracle DBA

"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message news:3a3a6aca.1288719039_at_news.earthlink.net...
> if I set sql_trace on system level, it works
> if i use ALTER SESSION SET SQL_TRACE=TRUE, it works
> if I 'execute dbms_system.set_sql_trace_in_session(SID,SERIAL#,FALSE)'
> it doesn't
>
>
> OWNER OBJECT_NAME
> OBJECT_TYPE STATUS
> ------------------------------
> --------------------------------------------------------------------------

---

> ------------------ -------
> SYS DBMS_SYSTEM
> PACKAGE VALID
> SYS DBMS_SYSTEM
> PACKAGE BODY VALID
>
> Any ideas?
>
> thanx.
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
Received on Fri Dec 15 2000 - 13:34:23 CST