Oracle 12c for dummies
Demystifying the power of the Oracle 12c database The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world's largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, New Jersey :
Wiley
2013
|
| Edición: | 1st edition |
| Colección: | --For dummies
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628806906719 |
Tabla de Contenidos:
- Contents at a Glance; Table of Contents; Introduction; About This Book; Who Are You?; Icons in This Book; Beyond the Book; Where to Go from Here; Part I: Getting Started with Oracle 12c; Chapter 1: Discovering Databases and Oracle 12c; Discovering Databases; Choosing Oracle; Keeping a Database Safe and Sound; Chapter 2: Understanding Oracle Database Architecture; Defining Databases and Instances; Deconstructing the Oracle Architecture; Walking Down Oracle Memory Structures; Trotting around the System Global Area; Program Global Area; Managing Memory; Following the Oracle Processes
- Getting Physical with FilesApplying Some Logical Structures; Pluggable Databases; Chapter 3: Preparing to Implement Oracle; Understanding How an Oracle Database Fits into a System's Architecture; Verifying System Requirements; Part II: Implementing an Oracle Database; Chapter 4: Creating Your Database; Feeling at Home in Your Environment; Configuring an Instance; Creating Your Oracle Database; Using the Database Configuration Assistant (DBCA) to Create Databases; Doing a Post-Creation Check-Up; Chapter 5: Connecting to the Database; Starting and Stopping the Database
- Connecting to the Database InstanceSidestepping Connection Gotchas; Chapter 6: Understanding the Language of Databases: SQL; Learning the Basics of SQL; Using the Data Dictionary; Programming with PL/SQL; Chapter 7: Loading Data into Your Database; Making Tablespaces; Understanding Users and Schemas; Creating Database Objects; Part III: Caring for and Feeding an Oracle Database; Chapter 8: Keeping the Database Running; Doing Your Database Chores; Automating Chores with the Oracle Scheduler; Using Oracle Data Pump; Creating Oracle Directories; Using Data Pump with a Parameter File
- Chapter 9: Tuning an Oracle Database for PerformanceTuning Costs; Tuning Basics; Tuning Tools; Tuning the Database before Something Goes Wrong; Tuning after a Problem Arises; Tuning SQL; Tuning the Database; Chapter 10: Securing and Auditing Your Database; Staying Authentic with Authentication; Granting Privileges; Creating Roles; Auditing: Oracle's Big Brother; Chapter 11: Facilitating Backup and Recovery; Understanding Threats to Your Database; Finding Files with Recovery Manager; Backup File Types with RMAN; Viewing Backup Information; Putting It in the Archives; Maintaining the Archives
- Recovering Your Oracle DatabaseChapter 12: Troubleshooting an Oracle Database; Troubleshooting with System Methodology; Troubleshooting Using Oracle Database Logs; Benefiting from Other Diagnostic Utilities; Chapter 13: Managing Your Database with Enterprise Manager; Getting to Know the Enterprise Manager Family; Configuring EM Database Express with the DBCA; Navigating EM Database Express; Creating and Managing EM Database Express Users; Part IV: Advanced Oracle Technologies; Chapter 14: Advanced Features; Flashing Back; Compressing Data for Purging, Retention, and Archiving
- Flashback Data Archive
