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 5.
Parameters
|
Parameter |
Description |
|---|---|
|
_FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY |
Whether to freeze database activity during the transaction recovery phase of instance recovery. Defaults to TRUE if any data files use fine-grained locking. |
|
_GC_CLASS_LOCKS |
The number of releasable lock elements to reserve for fine-grained locking of the minor class blocks. |
|
_GC_LATCHES |
The number of lock element latches per partition of the lock elements fixed array. Defaults to two times the number of CPUs, which is ample. |
|
_GC_LCK_PROCS |
The number of LCKn processes. Defaults to 1, which is normally sufficient. |
|
_IGNORE_FAILED_ESCALATES |
Attempts to convert a PCM lock straight after a ping appears to fail because Oracle does not know which instance last modified the protected blocks. However, this merely means that the lock value block is invalid and cannot be used for SCN generation. The lock is usable in every other respect, and so the default setting of TRUE should be accepted. This parameter is not available in release 8.1. |
|
_KGL_MULTI_INSTANCE_INVALIDATION |
This can be set to FALSE to disable global library cache invalidation locks. |
|
_KGL_MULTI_INSTANCE_LOCK |
This can be set to FALSE to disable global library cache locks. |
|
_KGL_MULTI_INSTANCE_PIN |
This can be set to FALSE to disable global library cache pins. |
|
_LM_DIRECT_SENDS |
The processes that can send ... |
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.