August 2000
Intermediate to advanced
288 pages
7h 50m
English
Content preview from Oracle Parallel Processing
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.
Monitoring and Tuning IDLM
The Integrated Distributed Lock Manager is responsible for maintaining a list of database resources and for allocating locks on those resources. IDLM coordinates lock requests from different OPS instances. In some cases, lock requests are granted immediately, while in other cases lock requests are queued up until the remote instance that holds the lock in a conflicting mode releases the lock. The views that return information about IDLM performance are summarized in Table 10.8.
Table 10-8. Views with IDLM Statistics
|
Dynamic View |
Description |
|---|---|
|
V$DLM_CONVERT_LOCAL GV$DLM_CONVERT_LOCAL |
Returns the counts for different types of local lock mode conversions, as well as the time taken for those conversions |
|
V$DLM_CONVERT_REMOTE GV$DLM_CONVERT_REMOTE |
Returns the counts for different types of lock mode conversions in a remote node, as well as the time taken for those conversions |
|
V$DLM_LATCH GV$DLM_LATCH |
Returns IDLM latch statistics |
|
V$DLM_MISC GV$DLM_MISC |
Returns some miscellaneous IDLM statistics |
|
V$DLM_RESS GV$DLM_RESS |
New in Oracle8i; returns information on all resources known to IDLM |
|
V$DLM_ALL_LOCKS GV$DLM_ALL_LOCKS |
New in Oracle8i; returns information on all locks known to IDLM |
|
V$DLM_LOCKS GV$DLM_LOCKS |
New in Oracle8i; returns a subset of results of the V$DLM_ALL_LOCKS view and return information on all locks that are either blocked or blocking others |
Tuning IDLM
IDLM has internal data structures that contain lists of all database resources. IDLM ...
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.