Home » SQL & PL/SQL » SQL & PL/SQL » Confusion Regarding TKPROF (Oracle 9i,9.2.0.6.0,XP)
Confusion Regarding TKPROF [message #346323] Mon, 08 September 2008 04:01 Go to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear All,

I have one confusion regarding TKPROF utility.
Can we use a trace file of one oracle server (A)
and make a report on oracle server (B) or any oracle
client using it's TKPROF utility.

I tried with client but it will not generate the report.

Do we have to generate the report on the same machine
on which our oracle server is installed.

Regards,
Rajat
Re: Confusion Regarding TKPROF [message #346325 is a reply to message #346323] Mon, 08 September 2008 04:06 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Both the databases are of same version? Because there might be problems in generating if they are not compatible.
Re: Confusion Regarding TKPROF [message #346328 is a reply to message #346325] Mon, 08 September 2008 04:14 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Quote:

Both the databases are of same version?
Because there might be problems in generating
if they are not compatible.



My Database are of same version then in that case.

So are you trying to say that
only on oracle server we can generate the report
and that should be of same version.

Regards,
Rajat
Re: Confusion Regarding TKPROF [message #346341 is a reply to message #346328] Mon, 08 September 2008 04:49 Go to previous messageGo to next message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
I am not sure if Oracle client package comes up with TKPROF utility.Please correct me if I am wrong.
Could you try in the using TKPROF in server B and check if the file gets generated with relevant data?
Re: Confusion Regarding TKPROF [message #346354 is a reply to message #346323] Mon, 08 September 2008 05:44 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the command you tried to execute as well as the output.

Regards
Michel
Previous Topic: Reg dropping Queue tables ORA-24005:
Next Topic: Help On Query to fetch the master records?
Goto Forum:
  


Current Time: Sat Dec 03 14:09:11 CST 2016

Total time taken to generate the page: 0.12087 seconds