Oracle in a nutshell
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...
| Other Authors: | , |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
Beijing ; Sebastopol, CA :
O'Reilly & Associates
[2003]
|
| Edition: | First edition |
| Series: | In a nutshell series.
In a nutshell (O'Reilly & Associates) |
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626905906719 |
Table of 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
