Oracle8iInternalServices资源-CSDN文库

需积分: 15 181 浏览量 2007-09-13 16:49:40 上传评论收藏 384KB PDF 举报

资源推荐

资源详情

资源评论

Table of Contents

Index

Full Description

About the Author

Reviews

Colophon

Examples

Reader reviews

Errata

Oracle8i Internal Services for Waits, Latches, Locks,

and Memory

Steve Adams

Publisher: O'Reilly

First Edition October 1999

ISBN: 1-56592-598-X, 132 pages

Buy Print Version

Based on Oracle8i, release 8.1, this concise book contains

detailed, hard-to-find information about Oracle internals

(data structures, algorithms, hidden parameters, and

undocumented system statistics). Main topics include waits,

latches, locks (including instance locks used in parallel

server environments), and memory use and management.

Aimed especially at readers doing advanced performance

tuning.

Preface

A few years ago, I set my heart on researching and writing a truly advanced

Oracle performance-tuning book. Soon, I had a detailed outline running to more

than thirty pages. But when I started to write, I began to realize how much I had

yet to learn about Oracle. Each chapter was going to require considerably more

research than I had at first imagined. In particular, I began to realize that an

understanding of some aspects of Oracle internals would be vital to my quest. So

I began to learn what I could of Oracle internals, starting with the X$ tables.

If I had known then what I know now, about how vast an undertaking I was

commencing, I would probably never have attempted it. And many times I would

have given up in despair, except for the encouragement of my friends. They

always believed that I could comprehend the incomprehensible and construct a

coherent understanding of how Oracle works and should be tuned. It has been

somewhat like trying to determine the exact shape of an iceberg by walking all

over it and taking careful measurements of subsurface vibrations.

Why This Book?

My advanced Oracle performance-tuning book is still a dream. This little book is

something else: an introduction to Oracle internals. It builds the foundation

necessary for advanced performance tuning by explaining some of the basic

aspects of Oracle internals in detail.

Here you will find many of the undocumented system statistics explained. You

will learn how to gather additional statistics from the X$ tables. Your

understanding of how Oracle works will be deepened with clear explanations of

many of Oracle's internal data structures and algorithms. You will be alerted to

potential performance problems that are not mentioned in the documentation.

And you will expand your repertoire of tuning solutions and troubleshooting

techniques by learning how to use numerous hidden parameters and other

undocumented features.

Warnings

The kind of Oracle internals information I've included in this book is not readily

available to customers. Because I have never been an Oracle insider, the material

in this book has had to be compiled the hard way. I began by studying the

structure and contents of the X$ tables, and poring over trace files. I then

formulated hypotheses and tested them. Because of this approach, it is likely that

some of my conclusions about how things work are wrong, and that some of my

suggestions are misguided, or applicable only under limited conditions. So, the

onus is on you to test everything for yourself. If you find any errors, please email

me so that they can be corrected (see "Comments and Questions").

You should also note that this book goes boldly where Oracle Support fears to tread.

I explain and at times recommend the use of various undocumented features that I

find essential to advanced performance tuning. However, Oracle has chosen to leave

those same features undocumented—presumably with valid reasons. So please don't

expect Oracle to assist you in their use. Try them by all means, but if you have a

problem, quit. Don't bother Oracle Support about it.

Finally, please note that this book is oriented towards Oracle8i, release 8.1.

Although most of the material is applicable to earlier releases as well, some of it is

not. In particular, there have been major changes in Oracle Parallel Server in

both the 8.0 and 8.1 releases, and a number of the parameters have been hidden

in release 8.1.

Audience for This Book

This book is intended for Oracle database administrators (DBAs) and developers

who need to understand Oracle performance in detail. Although the information

is advanced, the presentation is easy to follow. Anyone who is familiar with the

basics of the Oracle architecture and has an aptitude for performance tuning will

be able to appreciate everything in this book. However, seasoned veterans will no

doubt appreciate it the most.

About the APT Scripts

This book makes a number of references to APT scripts. APT stands for Advanced

Performance Tuning. It is merely my personal toolkit of Oracle performance

tuning scripts. The scripts referred to in this book can be obtained from O'Reilly's

web site or from my own (see "Comments and Questions"). APT is not a

commercial product, and I do not warrant that the scripts are error-free. But you

are free to use them, or glean from them what you may.

Conventions Used in This Book

The following conventions are used in this book:

剩余122页未读，继续阅读

评论收藏

内容反馈

wuxue0427

粉丝: 5
资源: 12

Oracle8i Internal Services

Oracle8i Internal Services for Waits, Latches, Locks,and Memory

《Oracle8i Internal Services》英文版PDF格式

oracle8i.internal.services.for.waits.latches.locks.pdf

Oracle8i internal services for waits latches locks

Oracle Core Essential Internals for DBAs and Developers

Oracle Database 12c Release 2 Real Application Clusters Handbook

2010年10月最新ORACLE OCP培训教程

最全的oracle常用命令大全.txt

oracle学习文档 笔记 全面 深刻 详细 通俗易懂 doc word格式 清晰 连接字符串

CNVD-C-2019-48814-CNNVD-201904-961:CVE-2019-2725poc汇总更新绕过过CVE-2017-10271补丁POC

PostgreSQL 9 Administration Cookbook

php.ini-development

restful restful所需要的jar包

Loadrunner报错日志

端口查看工具

Geoserver用户手册

oci.dll 12版本全部

数据库系统概念（原书第七版）课后作业题

fineReport课后10题答案.zip

win64-11gR2-client.zip

Oracle19c-Windows客户端

oracle 12c windows 安装包下载

Kingbase KCA题库

Oracle11安装依赖包，11.2.0.4.0版本

Oracle19c(19.3)数据库驱动ojdbc.jar

2024年日历excel和Oracle新增sql（标记上班日，周末，节假日）

OracleClient-19C Oracle客户端，包括windows和Linux

最新资源

oracle学习文档笔记全面深刻详细通俗易懂 doc word格式清晰连接字符串