Home » RDBMS Server » Performance Tuning » Tkprof trace file meaning (Oracel10g)
Tkprof trace file meaning [message #394279] Thu, 26 March 2009 06:38 Go to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Hi,
After generating trace file.And converting into .txt file.What we have to check .ie
wha we have to minimized waits, all other things.
Re: Tkprof trace file meaning [message #394283 is a reply to message #394279] Thu, 26 March 2009 06:42 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Check for anything that looks like it is taking longer than it should take.

Which is sometimes quite obvious to spot, sometimes quite hard to find.

Re: Tkprof trace file meaning [message #394286 is a reply to message #394283] Thu, 26 March 2009 06:45 Go to previous messageGo to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Realy i dnat have any idea about tkprof utility.

Parser means what?
waits means ?
how to enable explain plan in text file also.

Please help me
Re: Tkprof trace file meaning [message #394351 is a reply to message #394279] Thu, 26 March 2009 09:53 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
When all else fails, Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/sqltrace.htm#PFGRF01020
Previous Topic: statspack error
Next Topic: Performance tuning
Goto Forum:
  


Current Time: Thu Dec 08 12:30:36 CST 2016

Total time taken to generate the page: 0.16087 seconds