Re: performance questions and help!

<scorpio1348_at_yahoo.com> wrote in message news:282abe74-160f-4afa-9da1-91dc3673919c_at_i24g2000prf.googlegroups.com... Hi
I’m kind of new in oracle administration, take the performance class, and try to learn and understanding the concepts. I came up with some questions. If you can just give me a hint or just help me to find out where should I go to get my answers.
Here they are:

1. A user complains that a part of their application always runs slowly. You determine that it is a single SQL statement that is slow, not the database or whole application. What suggestions do you make to your user for how to identify how the database is processing the SQL statement?
2. Your database is performing a significant amount of reading and writing to the temporary tablespace. What steps can you take to reduce the sorting?
3. You are seeing a significant amount of duplicate SQL statements in the library cache that are not being shared. What steps can you take to increase statement reuse?

Thanks for the helps.
#3 is easy. Read Tom Kyte it has to do with his number 1 pet peave.

#1 and #2 There are only a couple of ways to make something perform better.
Basically it comes down to eliminating bottle necks. So you can either not do something or do less of it.
Jim Received on Sat Dec 06 2008 - 20:28:28 CST