Sumário Itens Encontrados: 3411 Introducing Oracle 1The Evolution of the Relational Database 3Relational Basics 4How Oracle Grew 5The Oracle Database Family 7Summary of Oracle Database Features 9Database Application Development Features 10Database Programming 10Database Extensibility 13Database Connection Features 14Oracle Net Services 14Oracle Internet Directory 14Oracle Connection Manager 14The Role of Oracle Fusion Middleware 15Oracleâs WebLogic Server 16Oracle Tuxedo 18Data Integration Tools 18Business Intelligence Tools 19WebCenter 19Identity Management 20Distributed Database Features 20Distributed Queries and Transactions 21Heterogeneous Services 21Data Movement Features 22Transportable Tablespaces 22Advanced Queuing and Oracle Streams 22Database Performance Features 23Database Parallelization 23Data Warehousing 23Managing the Oracle Database 25Oracle Enterprise Manager 12c 26Real Application Testing Option 27Pluggable Databases 27Storage Management 28High Availability 28Database Security Features 32Advanced Security Option 32Label Security Option 32Database Vault Option 33Audit Vault and Database Firewall Option 33Oracle Database Development Tools 33Oracle SQL Developer 34Oracle Application Express 34Other Oracle Databases 35Oracle MySQL 35Berkeley DB & Oracle NoSQL Database 36Oracle TimesTen 37Cloudera Distribution of Hadoop 372 Oracle Architecture 39Databases and Instances 39Oracle Database Structures 40Pluggable Databases 44Database Initialization 45Deploying Physical Components 46Control Files 46Datafiles 48Redo Logfiles 50Instance Memory and Processes 56Memory Structures for an Instance 58Background Processes for an Instance 60Configuration, Engineered Systems, and the Cloud 62The Data Dictionary 633 Installing and Running Oracle 65Installing Oracle 65Optimal Flexible Architecture 67Supporting Multiple Oracle Versions on a Machine 67Upgrading an Oracle Database 67Creating a Database 68Planning the Database 68The Value of Estimating 70Tools for Creating Databases 70Oracle Net Services and Oracle Net 72Resolving Oracle Net Service Names 73Global Data Services 74Oracle Net Manager 74Oracle Connection Pooling 75Auto-Discovery and Agents 75Oracle Net Configuration Files 76Starting Up the Database 77Shutting Down the Database 78Accessing a Database 79Server Processes and Clients 79Application Servers and Web Servers As Clients 80Oracle Net and Establishing Network Connections 81The Shared Server/Multi-Threaded Server 82Database Resident Connection Pooling 86Oracle in the Cloud 86Oracle at Work 87Oracle and Transactions 87Flashback 89A Transaction, Step by Step 904 Oracle Data Structures 93Datatypes 93Character Datatypes 94Numeric Datatype 95Date Datatype 96Other Datatypes 97Type Conversion 99Concatenation and Comparisons 100NULLs 101Basic Data Structures 102Tables 102Views 103Indexes 104Partitioning 109Additional Data Structures 111Sequences 111Synonyms 111Clusters 112Hash Clusters 113Extended Logic for Data 113Rules Manager 114The Expression Filter 114Data Design 115Constraints 118Triggers 120Query Optimization 122Rule-Based Optimization 123Cost-Based Optimization 124Specifying an Optimizer Mode 128Saving the Optimization 131Comparing Optimizations 131Performance and Optimization 132SQL Translation 132Understanding the Execution Plan 132SQL Advisors 134Data Dictionary Tables 1345 Managing Oracle 137Manageability Features 139Database Advisors 140Automatic Storage Management 142Oracle Enterprise Manager 142Enterprise Manager Architecture 145Oracle Enterprise Manager Consoles 148EM Express 151Backup and Recovery 151Types of Backup and Recovery Options 152Oracle Secure Backup 154Information Lifecycle Management 154ILM in Oracle Database 12c 155Working with Oracle Support 155Reporting Problems 156Automated Patching 1576 Oracle Security, Auditing, and Compliance 159Security 159Usernames, Privileges, Groups, and Roles 160Identity Management 161Security Privileges 161Special Roles: DBA, SYSDBA, and SYSOPER 162Policies 164Restricting Data-Specific Access 164Label Security Option 166Security and Application Roles and Privileges 166Distributed Database and Multitier Security 167Advanced Security Option 169Encryption 170Data Redaction 170Secure Backup 170Auditing 171Compliance 172Oracle Database Vault Option 173Oracle Audit Vault Server 174Flashback Data Archive 175Transparent Sensitive Data Protection 1757 Oracle Performance 177Oracle and Resource Usage 178Oracle and Disk I/O Resources 179I/O Planning Principles for an Oracle Database 179Oracle and Parallelism 184Block-Range Parallelism 185Parallelism for Tables and Partitions of Tables 186What Can Be Parallelized? 187Partition-Based Parallelism 190Oracle and Memory Resources 191How Oracle Uses the System Global Area 191How Oracle Uses the Program Global Area 194Oracle and CPU Resources 196Performance Tuning Basics 198Defining Performance and Performance Problems 199Monitoring and Tuning the Oracle Database for Performance 199Using the Oracle Database Resource Manager 202Additional Monitoring and Tuning Available for Oracle Exadata 203A Final Note on Performance Tuning 2048 Oracle Multiuser Concurrency 205Basics of Concurrent Access 206Transactions 206Locks 207Concurrency and Contention 208Integrity Problems 208Serialization 209Oracle and Concurrent User Access 209Oracleâs Isolation Levels 210Oracle Concurrency Features 211How Oracle Handles Locking 213A Simple Write Operation 213A Conflicting Write Operation 214A Read Operation 215Concurrent Access and Performance 217Workspaces 218Workspace Implementation 218Workspace Operations 219Workspace Enhancements 2199 Oracle and Transaction Processing 221OLTP Basics 221What Is a Transaction? 222What Does OLTP Mean? 222OLTP Versus Business Intelligence 224Transactions and High Availability 225Oracleâs OLTP Heritage 225Architectures for OLTP 227Traditional Two-Tier Client/Server 227Stored Procedures 228Three-Tier Systems 228Application Servers and Web Servers 230The Grid 231OLTP and the Cloud 232Oracle Features for OLTP 232General Concurrency and Performance 232Scalability 234Real Application Clusters 237Exadata and OLTP 239High Availability 24010 Oracle Data Warehousing and Business Intelligence 243Data Warehousing Basics 244The Evolution of Data Warehousing and Business Intelligence 245A Topology for Business Intelligence 246Data Marts 247The Operational Data Store and Enterprise Warehouse 248OLTP Systems and Business Intelligence 249Big Data and the Data Warehouse 249Data Warehouse Design 250Query Optimization 252Bitmap Indexes and Parallelism 253Optimization Provided by the Exadata Storage Server Software 255Dimensional Data and Hierarchies in the Database 256Summary Tables 256Materialized Views 257OLAP Option 257Analytics and Statistics in the Database 258Basic Analytic and Statistical Functions 258Other SQL Extensions 259Advanced Analytics Option 260Other Datatypes and Big Data 262Loading Data into the Data Warehouse 263Managing the Data Warehouse 265Business Intelligence Tools 267Oracle Business Intelligence Foundation Suite 267Business Intelligence Applications 269Data Discovery and Oracle Endeca Information Discovery 270Oracle Exalytics 271The Metadata Challenge 271Putting It All Together 272A Complete Analytics Infrastructure 272Best Practices 273Common Misconceptions 274Effective Strategy 27511 Oracle and High Availability 277What Is High Availability? 278Measuring High Availability 278The System Stack and Availability 280Server Hardware, Storage, and Database Instance Failure 281What Is Instance Recovery? 282Phases of Instance Recovery 283Protecting Against System Failure 284Component Redundancy 284Disk Redundancy 285Automatic Storage Management 287Site and Computer Server Failover 288Oracle Data Guard and Site Failures 289Oracle Active Data Guard and Zero Data Loss 291Oracle GoldenGate and Replication 291Real Application Clusters and Instance Failures 293Oracle Transparent Application Failover 296Oracle Application Continuity 298Recovering from Failures and Data Corruption 299Developing a Backup-and-Recovery Strategy 299Taking Oracle Backups 300Using Backups to Recover 300Recovery Manager 302Read-Only Tablespaces and Backups 304Old-Fashioned Data Redundancy 304Point-in-Time Recovery 305Flashback 305Planned Downtime 30712 Oracle and Hardware Architecture 309System Basics 310Symmetric Multiprocessing Systems and Nodes 311Clustered Solutions, Grid Computing, and the Cloud 313Disk and Storage Technology 316Oracleâs Engineered Systems 317Oracle Exadata Database Machine 317Oracle Exalogic 320Oracle SuperCluster 321Oracle Database Appliance 322Other Engineered Systems 322Choosing and Defining the Right Platform 323Sizing and Planning for Growth 323Maximum Availability Architecture Considerations 324Justifying an Oracle Engineered System 32513 Oracle Distributed Databases and Distributed Data 327Accessing Distributed Databases 328Distributed Data Across Multiple Oracle Databases 328Access to and from Non-Oracle Databases 329Two-Phase Commit 330Oracle Tuxedo 331Replication and Data Transport 333Replication Basics 333History of Oracle Replication Offerings 334Oracle GoldenGate 335Global Data Services 336Data Transport Using Database Features 33714 Oracle Extended Datatypes 339Object-Oriented Development 340Object-Relational Features 340Javaâs Role and Web Services 343JavaBeans 344Extensibility Features and Options 345Oracle Multimedia 345Oracle Text 346XML DB 346Oracle Spatial and Graph Option 347The Extensibility Architecture Framework 35015 Oracle and the Cloud 351Cloud Definitions 351Common Characteristics 352Cloud Levels 353Is the Cloud New? 354Use Cases for Cloud Computing 356Oracle Database in the Cloud 357Oracle as a DBaaS 357Oracle as a PaaS 357Consumer and Provider 358Oracle Database Cloud Service 358History of Application Express 360Architecture 361Development with the Database Cloud Service 364SQL Developer and the Database Cloud 369Implementing Provider Clouds 369A Whatâs New in This Book for Oracle Database 12c 371B Additional Resources 379Index 389