Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00030 with DBMS_MONITOR.SESSION_TRACE_ENABLE

ahb72May 12 2010 — edited May 13 2010

Hi all,

The DBMS_MONITOR.SESSION_TRACE_ENABLE returned ORA-00030 although the session is already there.

Oracle 11g R1
Windows Server 2003 SP2

SQL> show user
USER is "SYS"
SQL>
SQL>  select sid, serial# from v$session where username='SA' ;

       SID    SERIAL#
---------- ----------
       390       4918

SQL> exec DBMS_MONITOR.SESSION_TRACE_ENABLE(session_id=>390, serial_num=>4918, waits => TRUE, binds => FALSE);
*
ERROR at line 1:
ORA-00030: User session ID does not exist.
ORA-06512: at "SYS.DBMS_MONITOR", line 123
ORA-06512: at line 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2010

Added on May 12 2010

#general-database-discussions

11 comments

2,810 views