Home » RDBMS Server » Performance Tuning » how to enable tracing via ODBC
how to enable tracing via ODBC [message #65857] Thu, 13 January 2005 12:20 Go to next message
Jianhua
Messages: 4
Registered: January 2005
Junior Member
Hi,

I'm using Oracle on Solaris and can enable session tracing via -

alter session set sql_trace=true;

in SQL Plus. I then use TKPROF.

However I have a 3rd party application with which I need to trace. Since I cannot enter SQL directly into the application I cannot set the sql_trace session variable.

How to enable tracing in ODBC? Following is my data source definition:

[[ODBC Data Sources]]
testDSN=DataDirect WirePro ORACLE

[[testDSN]]
Driver=/opt/odbc/lib/LVora19.so
Description=DataDirect 4.2 Oracle Wire Protocol
HostName=myhost
Database=mydb
LogonID=dba
Password=sql
PortNumber=1521
SID=mydb
CatalogOptions=0
ProcedureRetResults=0
EnableDescribeParam=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
Re: how to enable tracing via ODBC [message #65858 is a reply to message #65857] Thu, 13 January 2005 20:07 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Use dbms_system.set_sql_trace_in_session.
Take a look here

hth
Previous Topic: How much used% we need to keep for this tablespace?
Next Topic: How much used space percentage set for tablespace?
Goto Forum:
  


Current Time: Wed Sep 30 11:07:16 CDT 2020