October 1999
Intermediate to advanced
136 pages
4h 15m
English
Content preview from Oracle Internals: An Introduction
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,
O’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.I 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.I’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.I'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.
Reference
This section contains a quick reference to the parameters, events, statistics, waits, and APT scripts mentioned in Chapter 4.
Parameters
|
Parameter |
Description |
|---|---|
|
_DISTRIBUTED_LOCK_TIMEOUT |
Timeout for assumed deadlocks on distributed transactions. Defaults to 60 seconds. |
|
_ENQUEUE_HASH |
The size of the enqueue hash table. |
|
_ENQUEUE_HASH_CHAIN_LATCHES |
The number of latches used for access to the enqueue hash table. Defaults to the CPU count. |
|
_ENQUEUE_LOCKS |
The number of enqueue lock structures. |
|
DML_LOCKS |
The size of the DML locks fixed array. Where possible, DML locking should be disabled to reduce locking overheads and the risk of blocking locks. |
|
ENQUEUE_RESOURCES |
The size of the enqueue resources array. |
|
PARALLEL_TRANSACTION_RESOURCE_TIMEOUT |
Timeout for assumed deadlocks between the branches of a parallel transaction and another transaction in release 8.0. |
|
TEMPORARY_TABLE_LOCKS |
This parameter is obsolete in Oracle8. It does still exist in release 8.0, but setting it has no effect. |
Events
|
Event |
Description |
|---|---|
|
60 |
This is the enqueue deadlock detection error. In cases of recurrent, mysterious deadlock problems, you may need to take a systemstate dump on this event to diagnose the interactions causing the deadlocks. |
|
370 |
This event is signaled for assumed buffer cache deadlocks, and can be used for investigating severe buffer locking contention, using processstate dumps. |
|
4020 |
This is the library cache deadlock detection error. With a systemstate dump on this event, ... |
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
O’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.
I 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.
I’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.
I'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.