- 博客(8)
- 收藏
- 关注
RSS订阅转载 Oracle性能诊断艺术-第7章
<br />第7章<br />SQL优化技术<br />每<br />当查询优化器（query optimizer）不能自动产生高效的执行计划时，就需要一些手工的优化技术。为此，Oracle提供了多项技术，表7-1对它们进行了汇总。本章的目的不仅是要详述这些技术，还将解释每一项技术能做什么，以及在哪些情况下可以利用它们。为了从众多技术中做出选择，绝对有必要先问自己如下三个基础的问题。<br />q 这条SQL语句是已知并且确定不变的吗？<br />q 即将采用的措施会影响到单个会话（甚至整个系统）的
2011-03-08 00:20:00
480
原创 14 Manageability
<br />14 Manageability<br /><br />--------------------------------------------------------------------------------<br />001 Oracle Database 10g represents a major milestone in Oracle's drive toward self-managing databases. It automates many routine adminis
2011-02-24 00:36:00
932
原创 13 Data Concurrency and Consistency
<br />13 Data Concurrency and Consistency<br /><br />--------------------------------------------------------------------------------<br />001 This chapter explains how Oracle maintains consistent data in a multiuser database environment.<br /> 本章讲述 Oracl
2011-02-24 00:28:00
981
原创 9 Process Architecture
<br />9 Process Architecture<br /><br />--------------------------------------------------------------------------------<br />001 This chapter discusses the processes in an Oracle database system and the different configurations available for an Oracle sys
2011-02-24 00:25:00
514
原创 5 Schema Objects
<br />5 Schema Objects<br /><br />--------------------------------------------------------------------------------<br />001 This chapter discusses the different types of database objects contained in a user's schema.<br /> 本章讨论存储在用户方案（schema）内的各类数据库对象。<br
2011-02-24 00:19:00
1235
原创 8 Memory Architecture
<br />8 Memory Architecture<br /><br />--------------------------------------------------------------------------------<br />001 This chapter discusses the memory architecture of an Oracle instance.<br /> 本章讨论 Oracle 实例的内存体系结构。<br /><br />002 This chapter
2011-02-24 00:14:00
692
转载 1 Introduction to the Oracle Database
<br />1 Introduction to the Oracle Database<br />--------------------------------------------------------------------------------<br />1 <br /> This chapter provides an overview of the Oracle database server. The topics include: <br />Oracle Database Archi
2011-02-24 00:11:00
2329
转载 18 Partitioned Tables and Indexes
<br />001 This chapter describes partitioned tables and indexes. It covers the following topics: <br />Introduction to Partitioning <br />Overview of Partitioning Methods <br />Overview of Partitioned Indexes <br />Partitioning to Improve Performance <br /
2011-02-24 00:03:00
1165
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人