Oracle 11g for dummies
Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you'll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through...
| Otros Autores: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, N.J. :
Wiley
c2009.
|
| Edición: | 1st edition |
| Colección: | --For dummies.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627857606719 |
Tabla de Contenidos:
- Oracle 11g For Dummies; Table of Contents; Introduction; About This Book; Who Are You?; What's in This Book; Icons in This Book; Where to Go from Here; Part I: You Don't Have to Go to Delphi to Know Oracle; Chapter 1: A Pragmatic Introduction to Oracle; Introducing a New Kind of Database Management; Pooling Resources with Grid Computing; Anticipating Technology and Development Trends; Meeting Oracle in the Real World; Making the Oracle Decision; Chapter 2: Understanding Oracle Database Architecture; Defining Databases and Instances; Deconstructing the Oracle Architecture
- Walking Down Oracle Memory StructuresTrotting around the System Global Area; Program Global Area; Managing Memory; Following the Oracle Processes; Getting into Physical Structures; Getting Physical with Files; Applying Some Logical Structures; Chapter 3: Preparing to Implement Oracle in the Real World; Understanding Oracle Database Deployment Methodology; Checking on the Requirements; Part II: Implementing Oracle on Your Own; Chapter 4: Creating an Oracle Database; Feeling at Home in Your Environment; Sticking with the Oracle Universal Installer and oraenv; Configuring an Instance
- Creating Your Oracle DatabaseBossing the Database Configuration Assistant (DBCA); Feeling the Post-Configuration Glow; Chapter 5: Connecting to and Using an Oracle Database; Starting and Stopping the Database; Connecting to the Database Instance; Sidestepping Connection Gotchas; Chapter 6: Speaking the SQL Language; Using SQL in Oracle; Sharpening the SQL*Plus Tool; Using SQL Connection Commands; SQL*Plus Profile Scripts glogin. sql and login. sql; Getting Help from SQL*Plus; Getting a PL/SQL Overview; Chapter 7: Populating the Database; Creating Tablespaces; Creating Users and Schemas
- Creating Database ObjectsPart III: Caring for an Oracle Database; Chapter 8: Protecting Your Oracle Database; Assessing Database Threats; Getting Your Oracle Recovery Manager; Putting It in the Archives; Backup File Types with RMAN; Maintaining the Archives; Viewing Backup Information; Recovering Your Oracle Database; Chapter 9: Protecting Your Oracle Data; Authentication; Granting the Privileged Few; Role Playing; Virtual Private Database Concept; Auditing Oracle's Big Brother; Encrypting a Database; Chapter 10: Keeping the Database Running; Doing Your Chores
- Automating Jobs with the Oracle SchedulerUsing Oracle Data Pump; Creating Oracle Directories; Using Data Pump with a Parameter File; Chapter 11: Tuning an Oracle Database; Evaluating Tuning Problems; Tuning Your Database; Gathering Performance Information with Automatic Workload Repository; Using the Automatic Database Diagnostic Monitor (ADDM); Improving Queries with SQL Tuning; Chapter 12: Troubleshooting an Oracle Database; Troubleshooting with System Methodology; Troubleshooting Using Oracle Database Logs; Benefiting from Other Diagnostic Utilities
- Chapter 13: Monitoring and Managing with Enterprise Manager
