Oracle in a nutshell / Rick Greenwald and David C. Kreines.

Format:

Book

Author/Creator:

Greenwald, Rick, author.

Kreines, David C., author.

Series:

In a nutshell (O'Reilly & Associates)

In a nutshell series.

In a nutshell series

Language:

English

Subjects (All):

Oracle (Computer file).

Relational databases.

Physical Description:

1 online resource (928 p.)

Edition:

First edition.

Place of Publication:

Beijing ; Sebastopol, CA : O'Reilly & Associates, [2003]

Language Note:

English

System Details:

text file

Summary:

Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently changing information about the database and its capabilities.The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference. Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security administrators need as they manage Oracle databases and write code for these databases. It includes: Oracle Foundations--Overview of the Oracle architecture (memory structures and fundamental concepts), Oracle's various editions and packaging options, summary of the initialization file parameters and data dictionary views, and fundamentals of Oracle's concurrency scheme, security mechanisms (privileges, profiles, roles), and networking files (TNSNAMES.ORA, SQLNET.ORA, LISTENER.ORA, DAP.ORA, NAMES.ORA, CMAN.ORA) and options. Oracle Languages--Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package headers, and Java (JDBC and SQLJ) interfaces to the Oracle database. Oracle Tools--Commands provided with SQL Plus, SQL Loader, Import and Export, Oracle Recovery Manager (RMAN) and other backup/recovery methods, Oracle Enterprise Manager, and various performance tuning tools (Explain Plan, TKPROF, AUTOTRACE, UTLBSTAT, UTLESTAT, Statspack). Appendixes--Summary of Oracle datatypes, operators, expressions, conditions, numeric and date formats, and resources for additional reading.

Contents:

Table of Contents; Preface; Which Platform and Version?; Structure of This Book; Conventions Used in This Book; Comments and Questions; Acknowledgments; From Rick; From Dave; I; Architecture and Packaging; Oracle Instances and Databases; The Components of a Database; Tablespaces; Physical Files in an Oracle Database; Control Files; Datafiles; Datafile structure; Extents and segments; Redo Log Files; Multiplexing redo log files; How Oracle uses the redo logs; Archived redo logs; The Components of an Instance; Memory Structures for an Instance; Database buffer cache; Shared pool

Redo log bufferLarge pool; Background Processes for an Instance; Oracle Versions; Oracle Packaging; Editions; Options; Configuration; Parameter Files and Types; INIT.ORA: The Initialization File; SPFILE: The Server Parameter File; Dynamically Modifiable Parameters; Initialization Parameters; Auditing; AUDIT_FILE_DEST; AUDIT_TRAIL; TRANSACTION_AUDITING; Backup and Recovery; BACKUP_DISK_IO_SLAVES; BACKUP_TAPE_IO_SLAVES; FAST_START_IO_TARGET; FAST_START_MTTR_TARGET; FAST_START_PARALLEL_ROLLBACK; FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY; RECOVERY_PARALLELISM; Clustered Databases; CLUSTER_DATABASE

CLUSTER_DATABASE_INSTANCESCLUSTER_INTERCONNECTS; DELAYED_LOGGING_BLOCK_CLEANOUTS; DRS_START; GC_DEFER_TIME; GC_FILES_TO_LOCKS; GC_LCK_PROCS; GC_RELEASABLE_LOCKS; GC_ROLLBACK_LOCKS; INSTANCE_GROUPS; INSTANCE_NAME; INSTANCE_NUMBER; LM_LOCKS; LM_PROCS; LM_RESS; LOG_FILE_NAME_CONVERT; MAX_COMMIT_PROPAGATION_DELAY; OPS_ADMIN_GROUP; PARALLEL_SERVER; PARALLEL_SERVER_IDLE_TIME; PARALLEL_SERVER_INSTANCES; Cursors; CLOSE_CACHED_OPEN_CURSORS; CURSOR_SHARING; CURSOR_SPACE_FOR_TIME; OPEN_CURSORS; ROW_CACHE_CURSORS; SERIAL_REUSE; SESSION_CACHED_CURSORS; Database Links; DBLINK_ENCRYPT_LOGIN; OPEN_LINKS

OPEN_LINKS_PER_INSTANCEDistributed Operations and Heterogeneous Services; COMMIT_POINT_STRENGTH; DISTRIBUTED_LOCK_TIMEOUT; DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME; DISTRIBUTED_TRANSACTIONS; HS_AUTOREGISTER; MAX_TRANSACTION_BRANCHES; I/O and Space Management; DB_BLOCK_CHECKING; DB_BLOCK_SIZE; DB_FILE_DIRECT_IO_COUNT; DB_FILE_MULTIBLOCK_READ_COUNT; DB_FILE_SIMULTANEOUS_WRITES; DB_FILES; DISK_ASYNCH_IO; HASH_MULTIBLOCK_IO_COUNT; LGWR_IO_SLAVES; Java; JAVA_MAX_SESSIONSPACE_SIZE; JAVA_POOL_SIZE; JAVA_SOFT_SESSIONSPACE_LIMIT; Jobs; JOB_QUEUE_INTERVAL; JOB_QUEUE_KEEP_CONNECTIONS

JOB_QUEUE_PROCESSESLicenses; LICENSE_MAX_SESSIONS; LICENSE_MAX_USERS; LICENSE_SESSIONS_WARNING; Locking and Transactions; DISCRETE_TRANSACTIONS_ENABLED; DML_LOCKS; ENQUEUE_RESOURCES; ROW_LOCKING; SPIN_COUNT; TRANSACTIONS; TRANSACTIONS_PER_ROLLBACK_SEGMENT; Logging and Archiving; ARCH_IO_SLAVES; ARCHIVE_LAG_TARGET; CPU_COUNT; DB_CREATE_ONLINE_LOG_DEST_n; FAL_CLIENT; FAL_SERVER; LOG_ARCHIVE_BUFFER_SIZE; LOG_ARCHIVE_BUFFERS; LOG_ARCHIVE_DEST; LOG_ARCHIVE_DEST_n; LOG_ARCHIVE_DEST_STATE_n; LOG_ARCHIVE_DUPLEX_DEST; LOG_ARCHIVE_FORMAT; LOG_ARCHIVE_MAX_PROCESSES; LOG_ARCHIVE_MIN_SUCCEED_DEST

LOG_ARCHIVE_START

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

Description based on print version record.

ISBN:

9781491942956

1491942959