RE: 10046 - Unable to trace JDBC thin client?

Tracy:
I know set_ev is not "blessed" by oracle.
But it works for me, so I use it.

This is an 8.1.7.4 database on Solaris 6

Barb


OS User       Ora User   Logon Time          Sid  
Ser# Client Pgm
------------ ---------- ----------------- ----- ------
------------
hermrmn      HERMRMN    08/17/04 03:58:00    17      9
JDBC Thin Client

SQL> exec dbms_system.set_ev(17,9,10046,12,'');
PL/SQL procedure successfully completed.

HERM_RMN> more
/rmnherm/ora/ora01/app/oracle/admin/HERM_RMN/udump/herm_rmn_ora_2
4543.trc
/rmnherm/ora/ora01/app/oracle/admin/HERM_RMN/udump/herm_rmn_ora_24543.trc
Oracle8i Enterprise Edition Release 8.1.7.2.0 -
Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
ORACLE_HOME =
/rmnherm/ora/ora01/app/oracle/product/8.1.7
System name:    SunOS
Node name:      edit-rmn
Release:        5.8
Version:        Generic_108528-14
Machine:        sun4u
Instance name: HERM_RMN
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 24543, image: oracle@edit-rmn (TNS
V1-V3)

*** 2004-08-17 10:52:46.968
*** SESSION ID:(17.9) 2004-08-17 10:52:46.816
WAIT #3: nam='SQL*Net message to client' ela= 0
p1=675562835 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 1
p1=675562835 p2=1 p3=0




> > From: Tracy Rahmlow
> [mailto:tracy.rahmlow@xxxxxxxx]
> > Sent: Tuesday, August 17, 2004 10:25 AM
> > To: oracle-l@xxxxxxxxxxxxx
> > Subject: 10046 - Unable to trace JDBC thin client?
> >
> >
> > Oracle EE 8.1.7.4 on AIX 4.3.3 utilizing IBM
> Websphere -
> > I can currently trace a SQL*Plus session and I
> receive the
> > trace file.
> > Here is what I am executing:
> >
> >  - exec
> sys.dbms_support.start_trace_in_session(13, 2358,
> > true, false)
> >   -  some sql statement
> >   -  exec
> sys.dbms_support.stop_trace_in_session(13, 2358)

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: