Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Performance Tuning

Status
Not open for further replies.
naveenshindhe

naveenshindhe

Technical User
Joined
Jan 22, 2003
Messages
31
Location
GB
Hi,
I wanted to know how to do
Performance tuning in Oracle.
Regards
Naveen

 
Sort by date Sort by votes
Hi Naveen,
What do you want to know about Performance Tuning. Are you referring to a)Tuning of SQL statements b) Or you want to learn about Performance tuning and hence a reference book sought of.

Regards
Lavanya
 
Upvote 0 Downvote
Lavanya,
Thanks for reply.
I want know tuning of SQL statements.
Please let me know.
Regards
Naveen
 
Upvote 0 Downvote
Naveen,

Performance tuning is a Subject in itself and many books have been written to tackle these.
I guess you are looking at tuning SQL queries. The first step wud be to look at "Explain Plan".
This shows you the path the query has taken to execute.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vpv
  • Locked
  • Question Question
tuning data block
Replies
3
Views
176
prosuc
prosuc
lewisp
  • Locked
  • Question Question
Poor tree performance
Replies
2
Views
191
lewisp
lewisp

Part and Inventory Search

Sponsor

Back
Top