随笔分类 -  Oracle 官方 Tuning

19 Using Optimizer Hints
摘要：19.1 Overview of Optimizer Hints A hint is an instruction to the optimizer. In a test or development environments, hints are useful for testing ... 阅读全文
posted @ 2015-07-20 09:25 神之一招 阅读(185) 评论(0) 推荐(0) 编辑
16 SQL Tuning Overview
摘要：16.1 Introduction to SQL Tuning Identifying high load or top SQL statements that are responsible for a large share of the application workload and ... 阅读全文
posted @ 2015-07-20 09:24 神之一招 阅读(264) 评论(0) 推荐(0) 编辑
15 sql base line 工作机制
摘要：正常配置一下, 就OK了, 不用理了, oracle 11g 默认启动发展: 1、从Oracle的发展角度来看，估计这种方法是Oracle发展和改进的方向，如今outline已经被废弃，sql profile 估计在后续的发行版本中也难有改进，因此，对于从11g开始接触O... 阅读全文
posted @ 2015-07-20 09:23 神之一招 阅读(417) 评论(0) 推荐(0) 编辑
14 Using Indexes and Clusters
摘要：do not build indexes unless necessary. 索引是非常占资源的To maintain optimal performance, drop indexes that an application is not using. 不用的索引可以drop掉, 通过toad可以... 阅读全文
posted @ 2015-07-20 09:22 神之一招 阅读(148) 评论(0) 推荐(0) 编辑
12 Using_explain_plan
摘要：The row source tree is the core of the execution plan. The tree shows the following information: An ordering of the tables referenced by the statem... 阅读全文
posted @ 2015-07-20 09:21 神之一招 阅读(304) 评论(0) 推荐(0) 编辑
11 The Query Optimizer (over view) 精细
摘要：/*11 The Query OptimizerOverview of the Query OptimizerOverview of Optimizer Access PathsOverview of JoinsReading and Understanding Execution PlansCon... 阅读全文
posted @ 2015-06-28 10:23 神之一招 编辑
Tuning 简介
摘要：典型的不好的设计: 破坏了系统的可扩展性(韧性) Applications requiring significant concurrency management as user populations increase Increased locking activities Increased... 阅读全文
posted @ 2015-06-02 14:53 神之一招 阅读(515) 评论(0) 推荐(0) 编辑