There's
a couple good articles in the
new issue of
Oracle Magazine.
"Perform
Without Waiting" by Arup Nanda looks at diagnosing performance problems
using the wait interface in Oracle 10g (see also
this
article by Robin Schumacher
for more on the 10g wait interface), whilst
"Getting
Good Advice About Access" by Kimberly Floss looks at the the
SQL Access Advisor in Oracle 10g.