Oracle Tuning
文章平均质量分 79
Alley_Li
兴趣是最大的老师!
展开
-
How to do a deep SQL tuning
In order to see why the report is slow in BO, we need to identify a good run and a bad run, and trace them and see if they are using a different plan. See the action plan below: 1/ try to run Sql原创 2015-09-25 17:07:20 · 351 阅读 · 0 评论 -
使用SQL Profile稳定SQL语句的执行计划
SQL> @C:\Users\kzvz914\Desktop\AFG\coe_xfr_sql_profile.SQLParameter 1:SQL_ID (required)Enter value for 1: bbp1a0d9xkaggPLAN_HASH_VALUE AVG_ET_SECS--------------- ----------- 3403原创 2016-06-07 17:47:32 · 745 阅读 · 0 评论 -
定位物化视图快速刷新失败的原因
物化视图的快速刷新采用了增量的机制,在刷新时,只针对基表上发生变化的数据进行刷新。因此快速刷新是物化视图刷新方式的首选。但是快速刷新具有较多的约束,而且对于采用ON COMMIT模式进行快速刷新的物化视图更是如此。对于包含聚集和包含连接的物化视图的快速刷新机制并不相同,而且对于多层嵌套的物化视图的快速刷新更是有额外的要求。如此多的限制一般很难记全,当建立物化视图失败时,Oracle转载 2016-02-26 18:41:04 · 1854 阅读 · 0 评论 -
oracle中使用物化视图实现表的同步
表的同步可以使用物化视图来实现,可以是同库的也可以是不同数据库之间进行数据同步,建议在同库的数据同步可以使用实时的同步,如果使用db link建议使用增量的刷新方式,防止dblink导致原库的性能急剧下降。主要步骤:1.在原表上建立物化视图日志2.在创建目标表3.创建与目标表同名的物化视图日志 1.创建原表和物化视图日志SQL> conn bre转载 2016-02-26 16:39:51 · 913 阅读 · 0 评论 -
SQL Plan Management
http://daliborm.blogspot.co.uk/2011/04/sql-plan-management.html?_sm_au_=ikVRsWF6StTJv16POverviewGoal of this page is to help teams stabilize their queries execution plan. It contains scrip转载 2016-02-22 14:26:00 · 461 阅读 · 0 评论 -
ORACLE AWR报告之 log file sync等待事件优化的总结【转自ITPUB】
来自白大师(白鳝)对log file sync等待事件优化的总结,供各位puber们学习参考:一、 log file sync平均等待事件时间超过7ms,如果等待时间过长,说明log write每次写入的时间过长,如果能够优化redo日志文件存储,使之存放在更快的磁盘上,就可以减少这个等待事件的单次等待时间。(RAID 5--> RAID 10) 当无法通过优化redo日转载 2016-03-02 18:19:16 · 9082 阅读 · 0 评论 -
Troubleshooting: 'Log file sync' Waits
http://sateeshv-dbainfo.blogspot.co.uk/2015/08/troubleshooting-log-file-sync-waits.html?_sm_au_=ikVPSjL75FDqsKMsTROUBLESHOOTING STEPSWhat is a 'log file sync' wait?When a user session co转载 2016-03-02 18:12:15 · 636 阅读 · 0 评论 -
Understanding how Informatica and Oracle interact: an Oracle perspective.
Monitoring Informatica from Oracle is a reasonably straight forward exercise if you know where to look and what to look for. I’ll walk through a typical scenario I encounter on a regular basis at转载 2016-01-22 11:19:10 · 353 阅读 · 0 评论 -
DBMS_PROFILER Package
http://www.dba-oracle.com/plsql/t_plsql_profiler.htmThe following Tip is from the outstanding book "Oracle PL/SQL Tuning: Expert Secrets for High Performance Programming" by Dr. Tim Hall, Orac转载 2015-11-19 17:42:29 · 462 阅读 · 0 评论 -
Scripts of Creating_Partitions_Steps
1) Take the back of original transform table TM_POSITION_HCC_ASSIGNMENT in transform schema.Query :create table tm_position_hcc_assign_bkp asselect * from tm_position_hcc_assignment;2) Dro原创 2015-12-11 15:17:18 · 295 阅读 · 0 评论 -
Problem - Slow PL/SQL procedure
http://www.oraclerecipes.com/tuning/using-dbms-profiler-to-find-bottleneck-in-a-procedure/When you work with Oracle you'll probably have a database bigger than 1MB and with lots of data comes lo转载 2015-11-24 14:40:39 · 515 阅读 · 0 评论 -
Write fast and efficient PLSQL - DBMS_PROFILER
http://www.oracleflash.com/44/Write-fast-and-efficient-PLSQL---DBMS_PROFILER.htmlBefore DBMS_PROFILER was introduced tuning long PL/SQL programs was a great pain. Tuning PL/SQL was done by SQL T转载 2015-11-24 15:12:29 · 465 阅读 · 0 评论 -
Toad for Oracle 12.1 – Guide to Using Toad for Oracle
This feature requires that certain objects exist on the server before you can use it. If they do not already exist, Toad prompts you to create them when you click .You can use the DBMS Profiler转载 2015-11-18 17:19:36 · 810 阅读 · 0 评论 -
Toad Oracle tuning advisor time out then change to use package DBMS_SQLTUNE
1. Advisor tuning results belowGENERAL INFORMATION SECTION-------------------------------------------------------------------------------Tuning Task Name : CNSGO7INFO281642270.6094852083Tuni原创 2015-09-28 17:05:20 · 677 阅读 · 0 评论 -
Oracle Optimizer Cardinality Feedback
Cardinality Feedbackhttps://blogs.oracle.com/optimizer/entry/cardinality_feedbackCardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature is to automatically i转载 2016-06-06 13:58:43 · 453 阅读 · 0 评论