Home » Developer & Programmer » Forms » Invoke TKPROF from the client machine
Invoke TKPROF from the client machine [message #183691] Sat, 22 July 2006 02:55 Go to next message
ghalib
Messages: 8
Registered: July 2006
Location: INDIA
Junior Member



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

Report message to a moderator

Re: Invoke TKPROF from the client machine [message #183693 is a reply to message #183691] Sat, 22 July 2006 03:04 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
You can - if it's installed on your local machine (check in your ORACLE_HOME/bin directory). However, you still need to get a SQL trace file from the database server.

Report message to a moderator

Re: Invoke TKPROF from the client machine [message #183732 is a reply to message #183693] Sat, 22 July 2006 15:24 Go to previous messageGo to next message
ghalib
Messages: 8
Registered: July 2006
Location: INDIA
Junior Member
It means that TKPROF can be invoked through forms as well.
Can the client using forms do that?

Asad

Report message to a moderator

Re: Invoke TKPROF from the client machine [message #183733 is a reply to message #183691] Sat, 22 July 2006 16:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can the client using forms do that?
As long as Form is programmed to do it.

Can Forms deposit money into my checking account?

Report message to a moderator

Re: Invoke TKPROF from the client machine [message #183738 is a reply to message #183733] Sun, 23 July 2006 01:47 Go to previous message
ghalib
Messages: 8
Registered: July 2006
Location: INDIA
Junior Member

Example will be useful for me.Plz send someone

Asadullah Khan Ghalib

Report message to a moderator

Previous Topic: remove hardcode
Next Topic: Calendar Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:46:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.