Skip to Content
Optimizing Oracle Performance
book

Optimizing Oracle Performance

by Cary Millsap, Jeff Holt
September 2003
Intermediate to advanced
416 pages
14h 1m
English
O'Reilly Media, Inc.
Content preview from Optimizing Oracle Performance

Glossary

Amdahl’s law

A vital insight recognized by Gene Amdahl [Amdahl (1967)], which allows a performance analyst to compute the relevance of various proposed performance improvements:

The performance enhancement possible with a given improvement is limited by the fraction of the execution time that the improved feature is used.

Arrival rate (λ)

The rate of arrivals into a queueing system per unit of time during a specified time interval.

Chi-square goodness-of-fit test

A statistical test that is useful in determining whether a data sample is sufficiently likely to belong to a specified distribution.

Clock interrupt

An interrupt that notifies the operating system kernel that one more time interval has elapsed [Bovet and Cesati (2001) 140].

Closed form solution

A mathematical result that can be expressed exactly in symbolic form. Contrast a mathematical result that can be expressed only approximately in numeric form.

Code path

The computer instructions that are executed to produce a given result. Code path reduction is the process of improving performance by eliminating code path without diminishing the functional result.

Collateral benefit

An unintended positive side effect of an action. A benefit yielded serendipitously by attending to something else.

Collateral damage

An unintended negative side effect of an action.

Completion rate (X)

The throughput of a queueing system.

Compulsive tuning disorder (CTD)

A term created by Gaja Vaidyanatha and Kirti Deshpande to describe an effect of using a performance ...

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

Troubleshooting Oracle Performance

Troubleshooting Oracle Performance

Christian Antognini
Oracle Performance Tuning, 2nd Edition

Oracle Performance Tuning, 2nd Edition

Mark Gurry, Peter Corrigan

Publisher Resources

ISBN: 059600527XErrata Page