RE: 10046 - Unable to trace JDBC thin client?

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Tue, 17 Aug 2004 10:01:41 -0700 (PDT)
Message-ID: <20040817170141.29927.qmail@web50610.mail.yahoo.com>

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_at_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_at_aexp.com]
> > Sent: Tuesday, August 17, 2004 10:25 AM
> > To: oracle-l_at_freelists.org
> > 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_at_freelists.org 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
-----------------------------------------------------------------

Received on Tue Aug 17 2004 - 11:57:22 CDT