A guide to designing and constructing Oracle databases covers leveraged tablespaces, partitioning, LOBs, autonomous transactions, row-level security, parallel query, parallel server, and Oracle's new analytical functions.
Amazon.com description: Product Description
: What is really involved in building effective Oracle database systems, and how do you approach the endeavor in a way that increases your chances for success? Practical Oracle8i offers a real-life approach to constructing Oracle databases--one that is geared toward solving important business problems. This book will help you devise an appropriate strategy for database design that takes into account Oracles technical underpinnings, hardware and user limitations, and tradeoffs between simplicity and efficiency. It discusses selecting the Oracle features needed to perform specific functions and shows you how to structure code most effectively for the features being implemented. Practical Oracle8i presents an overview of Oracle that clearly explains the central functions that are key to Oracles operation. In addition, the book presents the fundamentals of the system, covering the way in which data is stored, packed, and made visible, as well as the dynamic features involved in transactions and calculations. Specific topics covered include: *A discussion of why Oracle projects fail *Leveraging tablespaces *Partitioning *LOBs *Autonomous transactions *Row-level security for virtual privat