RE: 10046 - Unable to trace JDBC thin client?
- From: Barbara Baker <barbarabbaker@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 17 Aug 2004 10:01:41 -0700 (PDT)
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
