Oracle SQL Tuning
文章平均质量分 79
dbcommando
这个作者很懒,什么都没留下…
展开
-
性能诊断与调优之OWI--OverView
最近在学习关于Oracle调优方面的知识,正在阅读>,这本书以一种独到的见解论述了性能调优的知识。Oracle Wait Interface (OWI) to help DBAs quickly and effectively diagnoseperformance problemsThe old school teaches DBAs to identify an原创 2012-06-07 17:17:20 · 624 阅读 · 0 评论 -
show_space_assm完整版
创建存储过程脚本:create or replace procedure show_space_assm(p_segname in varchar2,p_owner in varchar2 default user,p_type in varchar2 default 'TABLE' )asl_fs1_bytes number;l_fs2_bytes number;l_fs3_bytes转载 2012-08-29 16:40:32 · 454 阅读 · 0 评论 -
oracle不同系统内存参数设置
针对不同(OLTP与OLAP)的系统,以一个实例的内存设置为基础,一般来说 ORACLE实例内存=物理内存*80%对于OLTP系统:PGA=实例内存*20%SGA=实例内存*80%对于OLAP系统:PGA=实例内存*50%SGA=实例内存*50%混合型系统可以设置在二者之间确定内存容量后,对于PGA: 使用WORKAREA_SIZE_PO原创 2012-08-18 13:52:53 · 356 阅读 · 0 评论 -
使用opt_param 提示来预览修改优化器相关参数的优化效果
有时在修改优化器参数来进行调优时,可以采用如下方法进行查看参数修改带来的效果1、与优化器相关的参数有:optimizer_mode, optimizer_index_caching, optimizer_index_cost_adj optimizer_mode:Values:first_rows_nThe optimizer uses a cost-based a原创 2012-08-17 15:27:10 · 1142 阅读 · 0 评论 -
Common Wait Events---db file scattered read
db file scattered readThe db file scattered read event is posted by the session when it issues an I/O request to read multiple data blocks. The blocks read from the datafiles are scattered into th翻译 2012-06-11 22:58:43 · 341 阅读 · 0 评论 -
Common Wait Events---buffer busy waits
buffer busy waitsThe buffer busy waits event occurs when a session wants to access a data block in the buffer cache that is currently in use by some other session. The other session is either readin翻译 2012-06-11 22:36:39 · 500 阅读 · 0 评论 -
性能诊断与调优之V$--V$SYSTEM_WAIT_CLASS
V$SYSTEM_WAIT_CLASS ViewThis V$SYSTEM_WAIT_CLASS shows the instance-level total waits and time waited by wait class since instance startup.The view V$SYSTEM_WAIT_CLASS has the following columns:V$翻译 2012-06-10 23:49:27 · 2476 阅读 · 0 评论 -
性能诊断与调优之V$--V$EVENT_NAME
V$EVENT_NAME view Contrary to its naming convention, V$EVENT_NAME is not a dynamic V$ view.The information it provides does not change over time. It is a referenceview that contains原创 2012-06-08 11:20:16 · 871 阅读 · 0 评论 -
性能诊断与调优之V$--V$SESSION_WAIT_HISTORY
V$SESSION_WAIT_HISTORY ViewHistorical information has been lacking from the Oracle wait events views. Low-level historical data simply doesn’t exist, and DBAs have to rely on high-level data from V$原创 2012-06-10 23:24:15 · 4749 阅读 · 0 评论 -
性能诊断与调优之V$--V$SESSION_EVENT
1、V$SESSION_EVENT ViewThe V$SESSION_EVENT view contains aggregated wait event statistics by session for all sessions that are currently connected to the instance. This view contains all the columns原创 2012-06-09 17:14:11 · 776 阅读 · 0 评论 -
详解10046事件生成的跟踪文件
Applies to:Oracle Server - Standard Edition - Version: 8.0.3.0 to 11.2.0.3 - Release: 8.0.3 to 11.2Oracle Server - Personal Edition - Version: 8.0.3.0 to 11.2.0.3 [Release: 8.0.3 to 11.2]Oracl翻译 2012-06-09 23:59:16 · 1055 阅读 · 0 评论 -
性能诊断与调优之V$--V$SESSION_WAIT
V$SESSION_WAIT ViewThe V$SESSION_WAIT view provides detailed information about the event or resource that each session is waiting for. This view contains only one row of information per session, act原创 2012-06-09 22:10:43 · 4791 阅读 · 0 评论 -
性能诊断与调优之V$--V$SESSION_WAIT_CLASS
1、V$SESSION_WAIT_CLASS View The view V$SESSION_WAIT_CLASS is similar to the V$SYSTEM_WAIT_CLASS view, but it gives session-level information for all sessions that are currently翻译 2012-06-08 15:33:18 · 1043 阅读 · 0 评论 -
性能诊断与调优之OWI--Components
学习目标: At the completion of this chapter you will knowwhere, when, and how to find wait event information that will help diagnose performance problems。很有诱惑啊,从哪儿找,什么时候找,怎么找这些帮助我们进行性能诊断用到的数据。原创 2012-06-07 17:36:12 · 596 阅读 · 0 评论 -
性能诊断与调优之V$--V$SYSTEM_EVEN
V$SYSTEM_EVENT View该视图显示了自实例启动以来所有会话所有事件的累计值,包括各事件的总等待次数,总等待时间。包括如下列:SQL> desc V$SYSTEM_EVENT;Name Type Nullable Default Comments ----------------- ------------ -------原创 2012-06-08 11:36:41 · 778 阅读 · 0 评论 -
禁用优化器动态采样
优化器动态采样有关的参数是:optimizer_dynamic_sampling1、参数的官方文档描述如下:OPTIMIZER_DYNAMIC_SAMPLINGPropertyDescriptionParameter typeIntegerDefault valueIf OPTIMIZER_FEATURES_ENABLE is set to 10.0.0 o原创 2012-08-19 11:07:44 · 720 阅读 · 0 评论