Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 10046 - Unable to trace JDBC thin client?

RE: 10046 - Unable to trace JDBC thin client?

From: Tracy Rahmlow <tracy.rahmlow_at_aexp.com>
Date: Tue, 17 Aug 2004 09:44:44 -0500
Message-ID: <OF9F2E95F1.C15EC52F-ON86256EF3.0050DC65-86256EF3.0050F02E@ipc.us.aexp.com>


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_at_aetn.com> Sent by: oracle-l-bounce_at_freelists.org
08/17/2004 09:35 AM
Please respond to oracle-l  

        To:     "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
        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_at_aetvn.com
Ext: 9787



> -----Original Message-----
> 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)
>
> 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_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
> -----------------------------------------------------------------
>
---------------------------------------------------------------- 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 ----------------------------------------------------------------- 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_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 - 09:41:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US