Read more
Informationen zum Autor HENRY H. LIU, PHD, is a Software Developer at BMC Software, Inc., with a physicist background from his prior career. His primary responsibilities at BMC include helping build performance and scalability into BMC's cloud computing and enterprise service management software products. Dr. Liu is the author of the highly acclaimed Software Performance and Scalability: A Quantitative Approach (Wiley). Klappentext A data-driven, fact-based, quantitative text on Oracle performance and scalabilityWith database concepts and theories clearly explained in Oracle's context, readers quickly learn how to fully leverage Oracle's performance and scalability capabilities at every stage of designing and developing an Oracle-based enterprise application. The book is based on the author's more than ten years of experience working with Oracle, and is filled with dependable, tested, and proven performance optimization techniques.Oracle Database Performance and Scalability is divided into four parts that enable readers to progressively learn and apply new skills:* Part 1, Getting Started with Oracle, describes how to set up a working Oracle environment, offering a quick tour to illustrate major database concepts* Part 2, Oracle Architecture from Performance and Scalability Perspectives, explains all the major database concepts and architectural features that readers need to know to optimize Oracle performance and scalability* Part 3, Optimizing Oracle Performance and Scalability, offers hands-on instructions to optimize and fine-tune performance and scalability for all database applications* Part 4, Case Studies: Oracle Meeting Real-World Performance and Scalability Challenges, sets forth quantitative case studies based on the author's first-hand experience that demonstrate how readers can apply proven techniques to dramatically improve the performance and scalability of actual database productsIn addition to case studies, this book offers a detailed secure online banking application as an example, making it possible for readers to fully explore Oracle's performance and scalability features on their own. Oracle Database Performance and Scalability is an ideal text for pre-conditioning college students and training software developers. Zusammenfassung The innovative performance and scalability features with each newer edition of the Oracle database system can present challenges for users. This book teaches software developers and students how to effectively deal with Oracle performance and scalability issues throughout the entire life cycle of developing Oracle-based applications. Inhaltsverzeichnis Preface xxv Why This Book xxv Who This Book is for xxvi How This Book is Organized xxvii Software and Hardware xxviii How to Use This Book xxix How to Reach the Author xxxi Acknowledgments xxxiii Introduction 1 Features of Oracle 2 Objectives 4 Conventions 5 Performance versus Scalability 6 Part 1 Getting Started with Oracle 7 1 Basic Concepts 9 1.1 Standard versus Flavored SQLS 10 1.2 Relational versus Object-Oriented Databases 11 1.3 An Instance versus a Database 11 1.4 Summary 12 Recommended Reading 12 Exercises 12 2 Installing Oracle Software 14 2.1 Installing Oracle 11g Server Software 15 2.2 Configuring a Listener 18 2.3 Creating an Oracle Database 18 2.4 Installing Oracle 11g Client Software 28 2.5 Oracle Grid Control versus DB Control 31 2.6 Summary 33 Recommended Reading 33 Exercises 33 3 Options for Accessing an Oracle Server 34 3.1 A Command Line Interface (CLI) versus a GUI-Based Console 35 3.2 The Oracle Enterprise Manager Java Console (OEMJC) 37 3.3 Using the SQL*Plus Tool 40 3.4 Oracle E...
