The more experience you have as an Oracle DBA, the harder you're going find this book's techniques to initially trust. Data warehousing is truly a strange new world for anyone, but especially accomplished DBAs. In particular, star schemas require that you:
Throw out your OLTP experience baggage.
Be a good dog willing to learn some new tricks.
Forget all your Oracle design and tuning Golden Rules.
This is no small challenge. It took me over a year to feel comfortable that what I was doing was right (remember, I had no book such as this to soothe my concerns). All my OLTP DBA counterparts thought I was a “crackpot.” But as I explained to them, my database's temporary and rollback tablespaces were each double the size of their ...