950637 wrote:Why do you think any tuning needs to be done?
that just it, i don't know where to start tuning
so i was hoping any of the experts here can tell me what to do
950637 wrote:In my opinion one tunes a configuration, by tuning 1 SQL statement at a time.
well my supervisor ask me to check wether any tuning is needed
i know how to do SQL tuning, and i can check the SQL response time, etc.
but then my supervisor ask me to do some configuration tuning
and that is my question,Which application operation do user report runs "too slow"?
1. how to determine wether any configuration tuning is need to be done or not
2. how can i see the result to any configuration changes i've madeBenchmark current performance
this will sound very stupid, but where/how i benchmark my performance?
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - Production PL/SQL Release 18.104.22.168.0 - Production CORE 22.214.171.124.0 Production TNS for 32-bit Windows: Version 126.96.36.199.0 - Production NLSRTL Version 188.8.131.52.0 - Production
950637 wrote:If you are licensed for performance tuning (you are allowed to use the AWR reports and the performance screens in dbconsole), then you should check the AWR report for the times when the report didn't used to take too long. Also, an explain plan from that time would be good. You see, Oracle has a cost based optimizer, and, while there are ways to lock in a plan, one of the common reasons for a sudden change in the performance of a report is that for one of many reasons, even just a little more data, the optimizer decided to change the plan. In some places, benchmark plans are created as part of the development process, for this very reason. If you don't have one of those, we can help you with what is current as Nikolai said. If you are not licensed, you should google and check the docs for statspack. The use for AWR or statspack in these situations is to see what has changed, and if the report you are tuning is the culprit or the victim of something else. For example, it could be the first clue you have a dying disk controller, or some other process is fighting for your data.
1. Why do they think anything needs tuned?
well, the time it takes to process a report is taking too long.
2. What is the list of things that they think need tuned?Yes, it doesn't hurt to check. However, most tuning problems are the sql. If you can compare a good-times awr or statspack to the current problem time, something may pop out.
they already give me the module to tune, and as just like i stated before
i've already done the SQL tuning, but then they ask me
can i do some configuration tuning?
3. Why do they think that those things need to be tuned?Is there anything else wrong? You don't want to make changes outside the scope of the problem, that can create more problems. There are no silver bullets, and there is instrumentation to tell you what, if anything, is wrong. Sometimes you simply do just need to throw hardware at it. Sometimes the best performance comes from not doing something.
well just like i said they said the amount of time required to process a report is too long
4. Why are you even asking me to do such a ridiculous thing when there is no rhyme or reason for it?Well, that's a learning experience! I don't think he is mad at you, but rather that is how he would feel given your task. Rather than be mad, I would be poking around to see what people are really complaining about, and aren't. It does happen that some systems are so off that people don't even complain, because it's been bad since some vendor hack installed it. It also happens that people complain because they really don't understand what the system does, or sometimes just because they can't complain about what is really bothering them. It can take some detective work, and you don't have the "intuition" that comes with experience. Fresh eyes can be good, too.
i'm sorry if i take your time or offended you in anyway,
i'm a university student who is currently doing an internship with an IT Consultant
and they give me a case and i don't have an oracle background