performance questions and help!
From: <scorpio1348_at_yahoo.com>
Date: Sat, 6 Dec 2008 18:08:51 -0800 (PST)
Message-ID: <282abe74-160f-4afa-9da1-91dc3673919c@i24g2000prf.googlegroups.com>
Date: Sat, 6 Dec 2008 18:08:51 -0800 (PST)
Message-ID: <282abe74-160f-4afa-9da1-91dc3673919c@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:
- 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?
- Your database is performing a significant amount of reading and writing to the temporary tablespace. What steps can you take to reduce the sorting?
- 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. Received on Sat Dec 06 2008 - 20:08:51 CST