OraFAQ Forum: Performance Tuning » Tkprof trace file meaning

Home » RDBMS Server » Performance Tuning » Tkprof trace file meaning (Oracel10g)

Thu, 26 March 2009 06:38

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.

Thu, 26 March 2009 06:42

ThomasG
Messages: 3212
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.

Thu, 26 March 2009 06:45

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

Thu, 26 March 2009 09:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Previous Topic:	statspack error
Next Topic:	Performance tuning

Goto Forum:

]

Current Time: Fri Nov 22 18:06:30 CST 2024