Re: Invoke TKPROF from the client machine
Date: 22 Jul 2006 04:05:24 -0700
Message-ID: <1153566324.890799.233650_at_h48g2000cwc.googlegroups.com>
Ghalib wrote:
> IS there any way to invoke TKPROF from the client machine ?
>
> I needed to perform tuning of some PLSQL Packages and SQL.
>
> Our database is Oracle 10G. Windows 2000 Advance Server is the
> operating system.
>
> Some example will be better.
>
> Asad
Copy the trace file from the user dump location on the server to the client, and then execute tkprof from the client computer: C:\TraceFiles\Scheduler>tkprof Allocations1.TRC c:\alloc1.txt
TKPROF: Release 10.2.0.1.0 - Production on Sat Jul 22 06:54:21 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Send the results of tkprof to a mapped drive: C:\TraceFiles\Scheduler>tkprof Allocations1.TRC m:\alloc1.txt
TKPROF: Release 10.2.0.1.0 - Production on Sat Jul 22 06:55:14 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Send the results of tkprof to a UNC location: C:\TraceFiles\Scheduler>tkprof Allocations1.TRC \\remotecomputer\d$\alloc1.txt
TKPROF: Release 10.2.0.1.0 - Production on Sat Jul 22 06:56:38 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Remotely execute tkprof on the client computer using psexec, which is available from www.sysinternals.com (Microsoft just bought this company a couple days ago, so it may not be available for long): J:\Utilities\PSTools>psexec \\remotecomputer tkprof c:\Allocations1.TRC c:\alloc1.txt
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Sat Jul 22 2006 - 13:05:24 CEST