RE: 10046 - Unable to trace JDBC thin client?
- From: "Tracy Rahmlow" <tracy.rahmlow@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 17 Aug 2004 10:55:40 -0500
Hi Mladen,
I have traced all the sessions generated by the connection pool. And even
then I do not receive any trace data in any file. If a new connection
were to be spawned it would not be timed out until 30 minutes were up. No
additional sessions were spawned after the application was invoked.
Leading me to believe that I had all the possible sessions traced.
Therefore, if the application was initiating 1 or more calls, I think I
would have hit at least one statement and the results should have been
logged in 1 or more trace files.
"Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
08/17/2004 09:59 AM
To: Tracy Rahmlow@AMEX
cc:
Subject: RE: 10046 - Unable to trace JDBC thin client?
(sorry for sending private message, but Ecartis bounced
the one directed to the list)
Oracle supports tracing of a session connected to
a dedicated server, not a client per se. Now, when
you have an application server that is essentially a
web server plus a servlet engine, you have to ask
yourself one question: how is SQL being executed?
The answer is the following:
- User sends a request to the application server, which
in process of fullfilling that request, sends a SQL to
the first available database server (allocated by the
application server, when pools are configured).
- Data from that request is processed and sent back to the user.
- user generates the new SQL request, which is handled by the
first free server, not necessarily the same one as the last one.
That means that websphere users have their SQL statements executed by
several processes with dedicated connections, and that all of the traces
belonging to a processes used by websphere can contain relevant
information.
The only way to group and gather the statements belonging to the same
module is to execute DBMS_APPLICATION_INFO and then gather statistics with
TRCSESS. That is not possible before 10g.
--
Mladen Gogala
Oracle DBA
email:mladeng@xxxxxxxxx
Ext: 9787
> -----Original Message-----
> From: Tracy Rahmlow [mailto:tracy.rahmlow@xxxxxxxx]
> Sent: Tuesday, August 17, 2004 10:45 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: 10046 - Unable to trace JDBC thin client?
>
>
> Are you confirming that this feature (tracing jdbc thin
> client) is not
> supported? Why would Oracle not support the tracing of a jdbc thin
> client?
>
>
>
>
> "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> 08/17/2004 09:35 AM
> Please respond to oracle-l
>
>
> To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
> cc:
> Subject: RE: 10046 - Unable to trace JDBC thin client?
>
>
> Well, the solution would be to use DBMS_APPLICATION_INFO
> to set CLIENT_ID and then to enable tracing of all sessions
> having that CLIENT_ID by using DMBS_MONITOR package, then
> collect all trace files for that CLIENT_ID by using trcsess,
> but the problem is that you cannot do so on 8i database or 9i
> database. That capability exists only on 10g. You are from
> Amex, which means that your databases cannot be upgraded
> without 6-9 months long project, and even if the upgrade
> happens, it will going to be a conservative one, to 9.2,
> rather then to 10g. I'm afraid that the only method for
> tracing in your situation is based on supernatural forces and
> their mercy.
>
> --
> Mladen Gogala
> Oracle DBA
> email:mladeng@xxxxxxxxx
> Ext: 9787
>
>
> > -----Original Message-----
> > 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)
> >
> > However, when attempting to trace a "JDBC thin client" in the same
> > fashion I never can produce a trace file. I saw a brief
> reference on
> > Metalink in
> > a forum that tracing a JDBC thin client was not possible. Is this
> > true and is it documented other than in a forum? If true, do I have
> > any alternatives since most of our new applications will be
> > utilizing the jdbc
> > thin client? Thanks
> >
> > American Express made the following
> > annotations on 08/17/2004 07:25:07 AM
> > --------------------------------------------------------------
> > ----------------
> > **************************************************************
> > ****************
> >
> > "This message and any attachments are solely for the intended
> > recipient and may contain confidential or privileged
> information. If
> > you are not the intended recipient, any disclosure,
> copying, use, or
> > distribution of the information included in this message and any
> > attachments is prohibited. If you have received this
> communication in
> > error, please notify us by reply e-mail and immediately and
> > permanently delete this message and any attachments. Thank you."
> >
> > **************************************************************
> > ****************
> >
> >
> > ==============================================================
> > ================
> >
> >
> > ----------------------------------------------------------------
> > 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
> > -----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
>
>
> American Express made the following
> annotations on 08/17/2004 07:44:27 AM
> --------------------------------------------------------------
> ----------------
> **************************************************************
> ****************
>
> "This message and any attachments are solely for the
> intended recipient and may contain confidential or privileged
> information. If you are not the intended recipient, any
> disclosure, copying, use, or distribution of the information
> included in this message and any attachments is prohibited.
> If you have received this communication in error, please
> notify us by reply e-mail and immediately and permanently
> delete this message and any attachments. Thank you."
>
> **************************************************************
> ****************
>
>
> ==============================================================
> ================
>
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
American Express made the following
annotations on 08/17/2004 08:55:26 AM
------------------------------------------------------------------------------
******************************************************************************
"This message and any attachments are solely for the intended recipient
and may contain confidential or privileged information. If you are not the
intended recipient, any disclosure, copying, use, or distribution of the
information included in this message and any attachments is prohibited. If you
have received this communication in error, please notify us by reply e-mail and
immediately and permanently delete this message and any attachments. Thank
you."
******************************************************************************
==============================================================================
----------------------------------------------------------------
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:
