Skip to Content
Oracle Internals: An Introduction
book

Oracle Internals: An Introduction

by Steve Adams
October 1999
Intermediate to advanced
136 pages
4h 15m
English
O'Reilly Media, Inc.
Content preview from Oracle Internals: An Introduction

Index

Symbols

_DISTRIBUTED_LOCK_TIMEOUT, Distributed Transactions
_ENQUEUE_HASH, Enqueue Resources
_ENQUEUE_HASH_CHAIN_LATCHES, Enqueue Resources
_ENQUEUE_LOCKS, Enqueue Locking
_FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY, Blocking Factor
_GC_CLASS_LOCKS, Fine-Grained Locking
_GC_LATCHES, PCM Lock Acquisition
_GC_LCK_PROCS, LCKn Processes
_IGNORE_FAILED_ESCALATES, Parameters
_KGL_MULTI_INSTANCE_INVALIDATION, Parameters
_KGL_MULTI_INSTANCE_LOCK, Parameters
_KGL_MULTI_INSTANCE_PIN, Parameters
_LARGE_POOL_MIN_ALLOC, The Large Pool
_LATCH_SPIN_COUNT, Willing-to-Wait Mode
_LATCH_WAIT_POSTING, Latch Wait Posting
_LM_DIRECT_SENDS, Instance Lock Acquisition, Parameters
_LM_DOMAINS, Parameters
_LM_GROUPS, The Instance Lock Database
_LM_SEND_BUFFERS, The Instance Lock Database
_LM_XIDS, Parameters
_MAX_EXPONENTIAL_SLEEP, Sleeps
_MAX_SLEEP_HOLDING_LATCH, Sleeps
_NO_PREEMPT, Preemption Control
_ROW_CACHE_INSTANCE_LOCKS, Row Cache Instance Locks
_SAVE_ESCALATES, Deferred Ping Responses
_SHARED_POOL_RESERVED_MIN_ALLOC, The Reserved List
_SPIN_COUNT, Willing-to-Wait Mode, Tuning the spin count
_SPIN_YIELD_CPU_FREQ, CPU Yielding
_UPCONVERT_FROM_AST, Deferred Ping Responses
_USE_ISM, Parameters
_USE_VECTOR_POSTS, Semaphore Facilities

A

affinity control (see CPU scheduling)
APT scripts, About the APT Scripts , Semaphore Facilities
all_parameters.sql, Semaphore Facilities
create_xviews.sql, Parent and Child Latches
enqueue_locks.sql, Blocking Locks
enqueue_stats.sql, Enqueue Waits
fixed_table_columns.sql, The variable area
fixed_table_hwms.sql, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle in a Nutshell

Oracle in a Nutshell

Rick Greenwald, David C. Kreines

Publisher Resources

ISBN: 156592598XCatalog PageErrata