how to run tkprof on a trace file

Posted on 2011-09-29
Medium Priority
Last Modified: 2012-05-12
I want to run  tkprof on a traclefile. What's the proper method. I have a70 mb file and tkprof is running from last 30 min.
Question by:nirvairghuman
LVL 15

Assisted Solution

by:Devinder Singh Virdi
Devinder Singh Virdi earned 248 total points
ID: 36817787
login to server, set your environment using . oraenv
then use tkprof trancefile outputfile

Are you able to see any growth in output file?
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 252 total points
ID: 36817791
If might take a while to process a 70M file.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question