Oracle数据库11g入门到优化指南

需积分: 0 108 浏览量更新于2024-07-25 收藏 13.09MB PDF 举报

"Oracle+PLSQL从入门到优化" Oracle数据库是全球广泛使用的数据库管理系统之一，尤其在企业级应用中占据重要地位。PL/SQL（Procedural Language/Structured Query Language）是Oracle数据库专有的编程语言，它扩展了SQL的功能，允许开发人员编写存储过程、函数、触发器等复杂的数据库应用程序。《Oracle Database 11g Administration From Novice to Professional》由Iggy Fernandez撰写，是一本针对Oracle数据库11g管理的入门至进阶指南。该书涵盖了从安装配置、数据库架构、安全管理到性能优化等全面的Oracle管理知识。对于初学者，它提供了理解Oracle数据库基础的路径，包括数据存储、备份恢复、权限管理和故障排查。随着内容深入，读者将学习如何使用PL/SQL进行程序开发，如编写存储过程、触发器和游标，以及如何调试和优化PL/SQL代码。在Oracle数据库管理中，了解数据的组织结构至关重要，包括表空间、段、Extent和块的概念。此外，学习如何创建和管理用户、角色和权限，是确保数据库安全的关键步骤。书中还会讲解SQL*Plus的使用，这是一个命令行工具，用于执行SQL查询和PL/SQL脚本。性能优化是Oracle数据库管理中的重要环节，涉及到索引策略、SQL查询优化、数据库调优工具如Automatic Workload Repository (AWR)和SQL Tuning Advisor的使用。通过监控和分析数据库性能，可以识别并解决潜在的瓶颈问题。 PL/SQL编程部分会介绍变量、控制流程语句（如IF-THEN-ELSE，CASE语句）、异常处理以及如何与数据库对象交互。此外，还会讨论PL/SQL包、类型和游标，这些都是编写高效数据库程序的关键元素。通过这本书，读者不仅可以掌握Oracle数据库的基本操作，还能深入了解PL/SQL编程，从而实现从新手到专业级别的过渡。无论你是想成为一名DBA，还是需要在Oracle环境中进行开发工作，这本书都将提供宝贵的指导和实践案例。

NCONTENTS

xvi

PART IV

NNN

Database Tuning

CHAPTER 16 Instance Tuning ............................................357

Using a Systematic Five-Step Tuning Method ......................357

Analyzing DB Time .............................................360

Understanding the Oracle Wait Interface ...........................365

V$SYSSTAT and V$SESSTAT ................................365

V$SESSION_EVENT and V$SYSTEM_EVENT ...................366

Mining the Statspack Repository .................................366

Using the Statspack Report ......................................375

Summary ......................................................376

Exercises ......................................................377

Further Reading ................................................380

CHAPTER 17 SQL Tuning .................................................381

Defining Efficiency ..............................................381

Identifying Inefficient SQL Statements .............................382

Understanding the Causes of Inefficient SQL .......................384

Ways to Improve SQL ...........................................385

Indexes ...................................................386

Hints .....................................................387

Statistics .................................................389

Tuning by Example .............................................391

Creating and Populating the Tables ..........................391

Establishing a Baseline .....................................392

Examining the Query Plan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 397

Indexes and Statistics ......................................401

Using SQL Access Advisor ..................................403

Optimizer Hints ............................................406

Extreme Tuning ...........................................408

But Wait, There’s More! ....................................411

Summary ......................................................413

Exercises ......................................................415

Further Reading ................................................415

INDEX .......................................................................417

xvii

Foreword

There are so many computer books in the world. A few of them are lousy, most of them

are pretty good, and several are excellent.

Fortunately for the Gross National Products of nations, we all buy many of these

books.

Unfortunately, most of these books are never read, just skipped through and left to

gather dust on the shelves with all the other good books (and course materials) that we

never revisited.

So many wise words, wise thoughts, funny and instructive stories, and so many years

of experience collected in these books. And so many people willing to commit (!) the same

mistakes over and over again because they never read the books, but instead perform the

famous skip/skim procedure.

Many authors ask for the skip/skim treatment of their books because, unlike Iggy,

they either quote extensively from manuals or try to advise the reader about the chapters

he or she can skip or skim.

The few people who actually read a handful of good Oracle database books from

cover to cover, including trying out stuff on their test system as they read—they will have

a much easier and more entertaining work life with Oracle’s database.

Iggy is a workhorse. He wrote this book while holding down a day job at Database

Specialists, editing the journal of the Northern California Oracle Users Group (NoCOUG),

and making presentations at the RMOUG, IOUG, and Hotsos conferences. He’s also

a thinking man, who decided (I think) to write the book he wished he’d had when he

started with databases.

So when I looked through the sections and chapters (all of them very useful, by the

way), I saw a pattern:

Section I contains information you can easily find in manuals on

dppl6++p]depe*

kn]_ha*_ki or a good textbook on database theory. The information in Section II could

also be extracted from the manuals if you knew what you were looking for in the first

place—and had the many hours required at your disposal.

Sections III and IV, however, could only be written by someone who has acquired

experience, has made mistakes (and learned from them), and has thought about his job

and his role in the database world—and discussed it with others.

This is a very good book, Iggy. I want a signed copy of it.

Mogens Nørgaard

CEO of Miracle A/S and cofounder

of the OakTable Network

剩余1581页未读，继续阅读

u010613050

粉丝: 0

Oracle数据库11g入门到优化指南

Oracle9i+PLSQL从入门到精通

《Oracle PLSQL 从入门到精通》.zip

Oracle+11g+SQL和PL+SQL从入门到精通

Oracle+PLSQL

orcale plsql从入门到精通

如何在Windows系统中配置PLSQL Developer，以连接到Oracle数据库，并进行性能优化？

oracle plsql程序设计(第5版

oracle安装后安装plsql

PLSQL 执行计划 oracle,plsql执行计划,统计信息.docx

oracle和plsqldeveloper安装

最新资源