Oracle Performance - 'war stories' needed

Folks,
 I am helping out someone who is writing a book. It will be published by Osborne McGraw-Hill (Oracle Press) sometimes April/May 2001. The book is titled "Oracle Tuning 101 - Learning the Essentials of Oracle".

 It would be a great help to us to hear your 'war stories' related to Performance of your Oracle based systems. Selected stories will be published in the book with appropriate credits to their contributors. We are interested in knowing your performance related problems and how you went about finding a solution to it, and its impact on the performance of the overall system. If you changed poor performing SQL to an efficient SQL, modified the Application design to better use of 'normalization' or 'de-normalization' techniques, changed physical layout of the database to take advantage of distributing I/O, or any other tricks/techniques that improved the performance of your systems, we would like to hear. If you have examples of bad/good SQL with Explain plans and performance statistics, that would be even better.  

According to the Author of the book, all selected stories will be entered into a raffle for a few free copies of the book.

Just one request : Please send your contributions directly to me. NOT to the list. My e-mail address is kirti.deshpande_at_verizon.com.

Please feel free to e-mail me directly, if you need more information or have any questions.

Thanks for your help in this effort.

Regards,

• Kirti Deshpande http://www.superpages.com