SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK ORACLE DATABASE 11G ESSENTIALS 4TH EDITION
SUMMARY
-
Items Found: 112
- Preface xi
- 1. Introducing Oracle 1
- The Evolution of the Relational Database 2
- The Oracle Database Family 7
- Summary of Oracle Database Features 9
- Database Application Development Features 9
- Database Connection Features 13
- Distributed Database Features 17
- Data Movement Features 18
- Database Performance Features 20
- Database Management Features 23
- Database Security Features 27
- Oracle Development Tools 28
- Embedded Databases 31
- 2. Oracle Architecture 33
- Databases and Instances 33
- Deploying Physical Components 38
- Instance Memory and Processes 48
- The Data Dictionary 54
- 3. Installing and Running Oracle 56
- Installing Oracle 56
- Creating a Database 59
- Configuring Oracle Net 63
- Starting Up the Database 68
- Shutting Down the Database 69
- Accessing a Database 70
- Oracle at Work 77
- 4. Oracle Data Structures 82
- Datatypes 82
- Basic Data Structures 90
- Additional Data Structures 98
- Extended Logic for Data 100
- Data Design 102
- Constraints 104
- Triggers 107
- Query Optimization 108
- Understanding the Execution Plan 118
- SQL Advisors 120
- Data Dictionary Tables 120
- 5. Managing Oracle 122
- Manageability Features 124
- Oracle Enterprise Manager 126
- Fragmentation and Reorganization 132
- Backup and Recovery 133
- Working with Oracle Support 137
- 6. Oracle Security, Auditing, and Compliance 139
- Security 139
- Auditing 150
- Compliance 151
- 7. Oracle Performance 154
- Performance Tuning Basics 154
- Oracle and Disk I/O Resources 160
- Oracle and Parallelism 169
- Oracle and Memory Resources 176
- Oracle and CPU Resources 182
- Database Resource Manager 184
- 8. Oracle Multiuser Concurrency 186
- Basics of Concurrent Access 187
- Oracle and Concurrent User Access 190
- Oracle’s Isolation Levels 191
- Oracle Concurrency Features 192
- How Oracle Handles Locking 194
- Concurrent Access and Performance 197
- Workspaces 198
- 9. Oracle and Transaction Processing 201
- OLTP Basics 201
- Oracle’s OLTP Heritage 205
- Architectures for OLTP 206
- Oracle Features for OLTP 211
- High Availability 217
- Oracle Streams and Advanced Queuing 218
- Object Technologies and Distributed Components 221
- 10. Oracle Data Warehousing and Business Intelligence 222
- Business Intelligence Basics 223
- Data Warehouse Design 227
- Query Optimization 230
- Analytics, OLAP, and Data Mining in the Database 233
- Managing the Data Warehouse 236
- Other Software for the Data Warehouse 236
- The Metadata Challenge 248
- Best Practices 249
- 11. Oracle and High Availability 253
- What Is High Availability? 254
- System Failure 257
- Protecting Against System Failure 262
- Recovering from Failures 275
- Complete Site Failure 281
- Data Redundancy Solutions 285
- Rolling Upgrades 289
- 12. Oracle and Hardware Architecture 290
- System Basics 290
- Uniprocessor Systems 292
- Symmetric Multiprocessing Systems 293
- Clusters 295
- Non-Uniform Memory Access Systems 298
- Grid Computing 299
- Disk and Storage Technology 300
- Which Platform Deployment Solution? 302
- 13. Oracle Distributed Databases and Distributed Data 305
- Accessing Multiple Databases As a Single Entity 305
- Moving Data Between Distributed Systems 310
- 14. Oracle Extended Datatypes 318
- Object-Oriented Development 318
- Extensibility Features and Options 324
- Using the Extensibility Framework in Oracle 329
- 15. Beyond the Oracle Database 331
- Application Express 331
- Oracle Fusion Middleware 332
- Oracle SOA Suite 345
- A. What’s New in This Book for Oracle Database 11g 349
- B. Additional Resources 356
- Index 365
