On this site over the coming weeks and months you will find a number of chapters from the upcoming book from Tom Kyte and Wrox Press, Expert One-on-One Oracle Performance By Design. Tom wants your feedback! Click on the links below to read the chapters and the spec, then discuss them with Tom and other developers in our P2P forums:
Whereas most books concentrate 100% on being the hero developer who fixes a broken system, this book will focus on being a solid producer of quality output. Rather than heroically fixing a broken system, I will show how to build systems that do not break. Over time, the person that builds unbreakable systems is the real hero
http://www.wrcontractor.net/portable-toilets-in-rogers-ar/ Rogers portable toilets
This is an architectural level chapter about a) handling many concurrent users and b) handling storage space / large amounts of data, effectively. This is what Oracle was designed to do, so this chapter takes a look at some of the architectural ("macro-level") decisions that can help (or hinder) you in achieving the sort of scalability and performance of which Oracle is capable.
This chapter is about optimizing "behind-the-scenes" processes; about making sure that the work you're getting Oracle to perform for you isn't an unnecessary drain on resources/performance.
The chapter also looks at a new feature of Oracle 9i, automatic PGA memory management, and how this can optimize this process by allowing memory to be used differently as the load on the system grows and shrinks.