Discussion in 'SQL PL/SQL' started by bnramesh8, Aug 17, 2015.
Can any one post the performance tuning Technics in oracle sql?
what did you want to ask?
Here not everything is so simple...
Yes, one expert can be engaged in setup of productivity of a system.
But also, the Best results in case of the solution of such class of tasks will be reached when the command of experts works.
Suggest any link for performance tunning technics in oracle sql?
For s start ...
Database Performance Tuning Guide
additional links ...
Beyond what Sergey indicated, it matters a great deal whether you are talking about tuning the server itself or SQL. There are very different methods involved between the two.
Hi I want to tune SQL alone not server help me?
Thanks for your help
A Google search for "Oracle SQL Tuning" turns up hundreds of possibilities. As is pretty common (Google is good), the top ten are all pretty good options. The best place to start is probably the Oracle documentation on the topic:
Database SQL Tuning Guide
As has been said by others you've asked a very broad question; obviously you're experiencing what you think is a performance issue and you want to address it. Knowing WHAT that issue is makes a huge difference in what responses you receive.
One of the best resources I know is Jonathan Lewis, and his monitoring and performance scripts are found here:
His "Cost-based Oracle Fundamentals" is, in my opinion, a must-read:
The more you know the easier it is to recognize and solve problems.