Re: performance questions and help!

On Dec 6, 9:08 pm, scorpio1...@xxxxxxxxx wrote:
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.

Have you ever heard of bind variables explain plans or order by
clauses?

This sounds suspiciously like homework to me ... but if you do some
research one or more of the hints I gave may apply against one or more
of your questions.
.