August 2000
Intermediate to advanced
288 pages
7h 50m
English
Content preview from Oracle Parallel ProcessingBecome 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.
Chapter 9. Storage Management in OPS
Storage management is an important aspect of database tuning. Oracle manages storage space using several storage management parameters. You can use some of these storage management parameters—in particular, FREELISTS, FREELIST GROUP, and PCTFREE—to improve the performance of Oracle Parallel Server. This chapter explains the concepts behind these parameters and describes how to set them in an OPS environment.
In this chapter we also discuss Oracle’s reverse key index feature, which you can use to spread the index entries in an index tree more evenly when the indexes are based on sequential keys. Use of reverse key indexes can reduce contention for index leaf blocks during index updates when many instances are inserting rows into the same table.
Using Free Lists and Free List Groups
Free lists
and free list
groups are structures that Oracle uses to keep track of
the free space within a segment such as a table, index, or cluster.
If you have a large number of processes updating or inserting data
into a segment, they will all need access to the segment’s free
list. Too much contention for a segment’s free list can cause
performance to suffer. The FREELISTS and FREELIST GROUP space
management parameters are used to reduce contention for a
segment’s free list as follows:
- FREELISTS
You can set this parameter in both OPS and non-OPS environments. Use it to reduce contention for free lists when multiple-user processes are inserting or updating the same ...
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.