Oracle 11g for dummies / by Chris Zeis, Chris Ruel, and Michael Wessler.

Format:

Book

Author/Creator:

Zeis, Chris.

Contributor:

Ruel, Chris.

Wessler, Mike.

Series:

--For dummies.

For dummies

Language:

English

Subjects (All):

Oracle (Computer file).

Relational databases.

Database management.

Physical Description:

1 online resource (412 p.)

Place of Publication:

Hoboken, N.J. : Wiley, c2009.

Language Note:

English

Summary:

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 the mysteries of Oracle and database administration. You'll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers:The building blocks behind the database engine a

Contents:

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

Notes:

Includes index.

ISBN:

9780470465059

0470465050

OCLC:

437090095