Sumário Itens Encontrados: 278Introduction 1About This Book 1Who Are You? 2Whatâs in This Book 2Part I: You Donât Have to Go to Delphi to Know Oracle 2Part II: Implementing Oracle on Your Own 3Part III: Caring for an Oracle Database 3Part IV: Inspecting Advanced Oracle Technologies 3Part V: The Part of Tens 3Icons in This Book 4Where to Go from Here 4Part I: You Donât Have to Go to Delphi to Know Oracle 5Chapter 1: A Pragmatic Introduction to Oracle 7Introducing a New Kind of Database Management 7Pooling Resources with Grid Computing 8Anticipating Technology and Development Trends 9Meeting Oracle in the Real World 9Making the Oracle Decision 10Chapter 2: Understanding Oracle Database Architecture 13Defi ning Databases and Instances 13Deconstructing the Oracle Architecture 14Walking Down Oracle Memory Structures 15Trotting around the System Global Area 15Shared pool 16Database buffer cache 18Redo log buffer 21Large pool 22Java pool 23Program Global Area 23Managing Memory 24Managing memory automatically 24Following the Oracle Processes 26Background processes 27User and server processes 28Getting into Physical Structures 30Getting Physical with Files 30Data fi les: Where the data meets the disk 31Control fi les 32Redo log fi les 33Moving to the archives 35Server and initialization parameter fi les 36Applying Some Logical Structures 37Tablespaces 38Segments 39Extents 40Oracle blocks 41Chapter 3: Preparing to Implement Oracle in the Real World 43Understanding Oracle Database Deployment Methodology 44Client-server applications 44Muli-tier applications 45Component confi gurations 48Checking on the Requirements 49User and directory requirements 50Hardware requirements 53Software requirements 55Storage requirements 56Other requirements 58Part II: Implementing Oracle on Your Own 61Chapter 4: Creating an Oracle Database 63Feeling at Home in Your Environment 63Finding the Oracle software owner 64Oracle versions 65Getting to home base 65ORACLE_BASE 66ORACLE_HOME 66ORACLE_SID 67PATH 67Sticking with the Oracle Universal Installer and oraenv 68Confi guring an Instance 70Using PFILE and SPFILES 70Setting parameters in the pfi le and spfi le 71Creating Your Oracle Database 74Bossing the Database Confi guration Assistant (DBCA) 74Taking database control 75Taking the DBCA steps 76Sharing (a) memory 86Feeling the Post-Confi guration Glow 87Chapter 5: Connecting to and Using an Oracle Database 89Starting and Stopping the Database 89Environmental requirements 90Starting the database 92Stopping the database 96Connecting to the Database Instance 99Local versus remote connections 100Communication fl ow 100Setting up tnsnames.ora 101Confi guring the database listener with listener.ora 102Starting and stopping the database listener 104Testing the connection 107Oracle Net Confi guration Assistant 108Sidestepping Connection Gotchas 108Chapter 6: Speaking the SQL Language 111Using SQL in Oracle 111Sharpening the SQL*Plus Tool 112Using SQL Connection Commands 113SQL*Plus Profi le Scripts glogin.sql and login.sql 114SQL*Plus buffer and commands 115SQL*Plus commands 115Getting Help from SQL*Plus 118SQL language elements 119Using the Oracle Data Dictionary 121Getting a PL/SQL Overview 125Blocking PL/SQL 126Chapter 7: Populating the Database 129Creating Tablespaces 130Creating Users and Schemas 136Creating Database Objects 140Object types 140Object creation methods 143Part III: Caring for an Oracle Database 147Chapter 8: Protecting Your Oracle Database 149Assessing Database Threats 149Instance failure 149Oracle code tree 150Dropped objects 150Media failure 150Corruption 151User error 152Getting Your Oracle Recovery Manager 152Starting RMAN 152Confi guring RMAN 153RMAN catalog 156Putting It in the Archives 158Turning archiving on and off 159Archive logs 160Enabling archiving 161Enabling the Flash Recovery Area 161Backup File Types with RMAN 164Backing up with backup sets 165Making copies 169Maintaining the Archives 170Viewing Backup Information 171Recovering Your Oracle Database 173Verifying the problem 174Complete recovery 175Incomplete recovery 180Recovering your database with copies 182Chapter 9: Protecting Your Oracle Data 185Authentication 185User authentication 186Password authentication 187Operating system authentication 190Granting the Privileged Few 191System privileges 192Object privileges 194Role Playing 196Oracle-supplied roles 197The SYSDBA role 198Virtual Private Database Concept 198Auditing Oracleâs Big Brother 198Getting ready to audit 199Enabling and disabling audits 202Auditing system privileges 202Auditing objects 204Verifying an audit 205Viewing audit information 207Turning off audits 207Encrypting a Database 208Chapter 10: Keeping the Database Running 211Doing Your Chores 211Making way, checking space 212Monitoring space in your segments 216Growing and shrinking: Tricky tables 217Checking users 223Audit records 228System logs 228Automating Jobs with the Oracle Scheduler 228Scheduler objects 229Creating your fi rst scheduler job 230Using Oracle Data Pump 234Data Pump Export 235Data Pump Import 238Creating Oracle Directories 239Using Data Pump with a Parameter File 240Chapter 11: Tuning an Oracle Database 243Evaluating Tuning Problems 243Tuning Your Database 246Gathering Performance Information with Automatic WorkloadRepository 247SQL*Plus method 248Database Control method 250Using the Automatic Database Diagnostic Monitor (ADDM) 252Improving Queries with SQL Tuning 255Explain plan 256Active Session History (ASH) 258SQL Access Advisor 259SQL Tuning Advisor 259SQL Profi ling and Plan Management 26010046 trace event 262Chapter 12: Troubleshooting an Oracle Database 269Troubleshooting with System Methodology 270Identifying the real problem 270Performing basic system checks 272Performing basic database checks 278Analyzing error messages 281Developing and applying a solution 283Troubleshooting Using Oracle Database Logs 286Database log infrastructure 286Database alert log 288Trace and dump fi les 290Listener log 291Benefi ting from Other Diagnostic Utilities 292Oracle Enterprise Manager 292Remote Diagnostic Agent 294Diagnostic database scripts 296Chapter 13: Monitoring and Managingwith Enterprise Manager 299Tasting Oracle Enterprise Manager Flavors 300OEM Java Console 300OEM Database Control 301OEM Grid Control 301Confi guring Enterprise Manager with the DBCA 302Creating and Managing Database Control Users 303Working with Metrics and Policies 305Setting Up Notifi cations 307Setting Up User Notifi cations 308Navigating Database Controlâs Main Page 311Inspecting the Database Control main page 311Accessing other targets 313Part IV: Inspecting Advanced Oracle Technologies 315Chapter 14: Flashing Back and Replaying: Advanced Features 317Rolling Back with Flashback Database 317Confi guring and enabling a fl ash back 318Using restore points 320Flashing back your database 321Using Flashback Data Archive 322Oracle Database Replay 324Using database replay 325Replaying the workload 326Chapter 15: Using High-Availability Options 329Gathering Real Application Clusters 330Exploring RAC Architecture 331Hardware considerations for RAC 331Software considerations for RAC 334Preparing for a RAC Install 336Tools for managing a RAC installation 337Oracle RAC application for high availability 341Defending Oracle Data Guard 342Data Guard architecture 342Physical standby database 344Logical standby database 347Performing switchover and failover operations 348Part V: The Part of Tens 351Chapter 16: Top Ten Oracle Installation Doâs 353Read the Documentation 353Observe the Optimal Flexible Architecture 354Confi gure Your Profi le 355Running the Wrong Bit 356Set umask 356Become Oracle 357Stage It 357Patch It 358Mind the User and Group IDs 359Back It Up 360Chapter 17: Top Ten Database Design Doâs 361Using Oracleâs Built-In Constraints 361Spreading Out Your IO 362Knowing Data Normalization 363Using Naming Conventions 363Setting Up Roles and Privileges Properly 364Keeping Ad-Hoc Queries to a Minimum 364Enforcing Password Security 364Limiting the Number of DBAs 365Storing Code in the Database 365Testing Your Recovery Strategy 366Appendix A: Quick Start Install of Oracle 11gon Linux 369Setting Up the Operating System 369Checking your operating system version 370Checking your kernel version 370Checking your OS packages 371Creating Linux operating system groups and users 372Creating the Oracle Software Owner 372Confi guring the Linux Kernel Parameters 373Creating the ORACLE_BASE directory 374Confi guring the Oracle userâs environment 374Installing the Oracle 11g database software 375Index 379