473,383 Members | 1,737 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Running Oracle Trace

After opening up a ticket with a 3rd party vendor to find out what SQL
they use behind the scenes, they advised and gave me instructions on
running an Oracle trace.

Basically, they told me to set TRACE_LEVEL_CLIENT to USER and to set the
TRACE_DIRECTORY_CLIENT and TRACE_FILE_CLIENT parameters. I did, and the
trace file gets generated, but I don't see any actual SQL calls.

Am I missing anything else? Also, is there a good reference for running
Oracle traces?

Thanks.
P.S. I reran the trace setting the TRACE_LEVEL_CLIENT to ADMIN, and that
generated more data, but no visible SQL.

Jul 19 '05 #1
1 5521
Terry Coccoli wrote:
After opening up a ticket with a 3rd party vendor to find out what SQL
they use behind the scenes, they advised and gave me instructions on
running an Oracle trace.

Basically, they told me to set TRACE_LEVEL_CLIENT to USER and to set the
TRACE_DIRECTORY_CLIENT and TRACE_FILE_CLIENT parameters. I did, and the
trace file gets generated, but I don't see any actual SQL calls.

Am I missing anything else? Also, is there a good reference for running
Oracle traces?

Thanks.
P.S. I reran the trace setting the TRACE_LEVEL_CLIENT to ADMIN, and that
generated more data, but no visible SQL.


All you have done so far is trace traffic between the client & the DB
server.

To actually see SQL go research how to set event 10046 on a "remote"
session.

Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: kristoff plasun | last post by:
I have a problem with a C++ DCOM application that prints Crystal Reports with data from Oracle. The SQL query is relatively complex but when the report is printed from the Crystal Reports...
0
by: petro | last post by:
I am trying to deploy an asp.net application to my web server. My application uses system.data.oledb to connect to an oracle database. On my development machine I have the oracle client 10g...
0
by: petro | last post by:
I am trying to deploy an asp.net application to my web server. My application uses system.data.oledb to connect to an oracle database. On my development machine I have the oracle client 10g...
5
by: petro | last post by:
Hello all, My asp.net web application works on my machine but I get the following error on our test web server, There is only one oracle home on the test server. Does anyone know how to resolve...
4
by: BookerW | last post by:
I am not sure which forum I should post this on, but here is the problem. I have a front end web application(VB) on asp,net 1.1 framework. Inside of the code, I have the following lines to...
0
by: bw171 | last post by:
Hopefully, I frame this problem/question correctly. I have some code written/updated in visual studio 2003. This code when setup on other machines where I have installed the Oracle 9i client, and...
1
by: =?Utf-8?B?Ym9va2VyQG1ndA==?= | last post by:
Hopefully, I frame this problem/question correctly. I have some code written/updated in visual studio 2003. This code when setup on other machines where I have installed the Oracle 9i client,...
1
by: Terry Coccoli | last post by:
After opening up a ticket with a 3rd party vendor to find out what SQL they use behind the scenes, they advised and gave me instructions on running an Oracle trace. Basically, they told me to...
3
by: John | last post by:
Hi. I have a number of batch jobs that are ran nightly on our Windows 2000 based Oracle 8.1.7 (soon to be 9i) server. I have these designed just right, so the Windows Scheduled Tasks runs them...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.