Oracle essentials / Rick Greenwald, Robert Stackowiak, and Jonathan Stern.

Format:

Book

Author/Creator:

Greenwald, Rick.

Contributor:

Stackowiak, Robert.

Stern, Jonathan.

Language:

English

Subjects (All):

Oracle (Computer file).

Relational databases.

Physical Description:

1 online resource (416 p.)

Edition:

4th ed.

Place of Publication:

Sebastopol, California : O'Reilly, 2008.

Language Note:

English

System Details:

text file

Summary:

Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g. This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains

Contents:

Oracle Essentials, 4th Edition; Audience for This Book; About the Fourth Edition (Oracle Database 11g); Structure of This Book; Conventions Used in This Book; How to Contact Us; Using Code Examples; Safari® Books Online; Acknowledgments; 1. Introducing Oracle; How Oracle Grew; The Oracle Database Family; Summary of Oracle Database Features; Database Application Development Features; PL/SQL; Java; Oracle and web services; Large objects; Object-oriented programming; Third-generation languages (3GLs); Database drivers; The Oracle Call Interface; National Language Support; Database Extensibility

Oracle content managementOracle search capabilities; Oracle Spatial Option; XML DB; Database Connection Features; Oracle Internet Directory; Oracle Connection Manager; Oracle Application Server; Distributed Database Features; Heterogeneous Services; Data Movement Features; Advanced Queuing and Oracle Streams; Extraction, Transformation, and Loading; Database Performance Features; Data Warehousing and Business Intelligence; Star query optimization; Materialized views; Analytic functions; OLAP Option; Data Mining Option; Business intelligence tools; Database Management Features

Information Lifecycle Management and ILM AssistantBackup and Recovery; Incremental backup and recovery; Oracle Secure Backup; Database Availability; Data Guard; Fail Safe; Oracle Real Application Clusters; Data Guard and RAC; Automated Storage Management; Real Application Testing Option; Database Security Features; Label Security Option; Database Vault Option; Audit Vault Server; Oracle Development Tools; Oracle SQL Developer; Oracle Forms Developer; Oracle Reports Developer; Oracle Designer; Oracle Discoverer Administration Edition; Oracle Portal; Embedded Databases; Oracle Berkeley DB

Oracle Lite2. Oracle Architecture; Files of a database; Database Initialization; Deploying Physical Components; Datafiles; Extents and segments; Redo Log Files; How Oracle uses the redo logs; Naming conventions for redo logs; Archived redo logs; ARCHIVELOG mode and automatic archiving; Instance Memory and Processes; Shared pool; Redo log buffer; Other pools in the SGA; Automatic PGA management; Background Processes for an Instance; The Data Dictionary; 3. Installing and Running Oracle; Supporting Multiple Oracle Versions on a Machine; Upgrading an Oracle Database; Creating a Database

The Value of EstimatingTools for Creating Databases; Configuring Oracle Net; Oracle Net Manager; Auto-Discovery and Agents; Oracle Net Configuration Files; Starting Up the Database; Shutting Down the Database; Accessing a Database; Client process; Application Servers and Web Servers As Clients; Oracle Net and Establishing Network Connections; The Shared Server/Multi-Threaded Server; Data dictionary information about the shared server; Oracle at Work; Flashback; A Transaction, Step by Step; 4. Oracle Data Structures; Numeric Datatype; Date Datatype; Other Datatypes; Type Conversion

Concatenation and Comparisons

Notes:

Previous ed.: 2004.

Includes bibliographical references and index.

Description based on print version record.

ISBN:

9781306814645

1306814642

9780596519322

059651932X

9780596555337

0596555334

OCLC:

609840785