Home » RDBMS Server » Performance Tuning » TkProf-Perormance Tunning (merged)
TkProf-Perormance Tunning (merged) [message #386584] Mon, 16 February 2009 03:23 Go to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Hi To All,

How to run TKprof for performance tunning.
I have assign Quey tuning work.I m new in tunning.
Please Provide me help for this.

Re: TkProf-Perormance Tunning [message #386585 is a reply to message #386584] Mon, 16 February 2009 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Database Performance Tuning Guide.

Regards
Michel
TkProf Utility [message #386590 is a reply to message #386584] Mon, 16 February 2009 03:37 Go to previous messageGo to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Hi,
How to run sql query for TKProf utiltiy.
also Explain plan for sql queries.
Re: TkProf Utility [message #386607 is a reply to message #386590] Mon, 16 February 2009 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't repost your question, the answer is the same.

Regards
Michel
Re: TkProf Utility [message #386907 is a reply to message #386607] Tue, 17 February 2009 04:21 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/sqltrace.htm#i4640
Previous Topic: re-write the query to improve performance
Next Topic: Perfoemnace Tunning
Goto Forum:
  


Current Time: Thu Dec 08 14:40:24 CST 2016

Total time taken to generate the page: 0.04719 seconds