Home » RDBMS Server » Performance Tuning » 10046 - Unable to trace JDBC thin client
10046 - Unable to trace JDBC thin client [message #65631] Wed, 17 November 2004 17:52 Go to next message
jebasti@yahoo.com
Messages: 1
Registered: November 2004
Junior Member
Hi,

I am facing the following problem.

I am using the code below for activating the trace of the third party session.

sys.dbms_system.set_ev(sid,serial,10046,12,'');

But i am not able to find my trace file for the program JDBC thin client.For other programs like SQLPLUS,Toad,the trace file is produced in udump directory of the server.

Please help me how to activate the trace for JDBC thin client?

if it possible to trace JDBC thin clients?if not, any
alternatives since most of our new applications will be
 utilizing the jdbc thin client? 

Thanks in advance,

Jebasti
Re: 10046 - Unable to trace JDBC thin client [message #65633 is a reply to message #65631] Wed, 17 November 2004 21:05 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
As far as I know, the JDBC thin client isn't (from the db's perspective) just a client application connecting to the db.
Tracefiles are normally located in user_dump_destination, regardless of the client-app.
If the tracefile doesn't (seem to) show up it could be caused by the fact that the session is performing a statement, started before the tracing was started.
The tracefile will be created only when the statement finishes.

hth
Previous Topic: Index storage
Next Topic: Assigning intial value to CLOB . will this reduce Fragmentation?
Goto Forum:
  


Current Time: Fri Mar 29 08:07:47 CDT 2024