读书笔记 - 随笔分类 - Coldest Winter

New Result Caching Functionality（Oracle缓存学习）

摘要：New Result Caching Functionality Oracle Database 11g introduces several new caching features that let you utilize memory moreefficiently, which results in faster query processing. There are actually two types of cachingfeatures: the server result cache that caches SQL query results as well as PL//S. 阅读全文

posted @ 2012-12-24 07:20 Coldest Winter 阅读(445) 评论(0) 推荐(0)

执行计划中的参数解释

摘要：执行计划中的各个参数解释：一、Recursive calls （递归调用）1、参考：Oracle Database Reference, 10g Release 2 (10.2).pdf第916页 Number of recursive calls generated at both the userand system level. Oracle maintains tables used forinternal processing. When Oracle needs to make achange to these tables, it internally generates an. 阅读全文

posted @ 2012-12-13 07:30 Coldest Winter 阅读(1140) 评论(0) 推荐(0)

Efficient Function Calls From SQL-在SQL语句中更高效的使用函数（转载）

摘要：网址：http://www.oracle-base.com/articles/misc/efficient-function-calls-from-sql.phpEfficient Function Calls From SQL对于在SQL中更加高效的使用PL/SQL函数，本文提供了以下几种解决办法： 1、标量子查询 2、使用DETERMINISTC(确定性的；命运注定论的)关键字 3、使用session缓存（在不同的session中也可以共用），该方法只在11g之后的版本可以使用 4、使用PL/SQL集合进行手动的控制缓存 5、使用上下文进行手动的控制缓存 6、注意在WHERE语... 阅读全文

posted @ 2012-12-04 07:31 Coldest Winter 阅读(349) 评论(0) 推荐(0)

subquery unnesting、Subquery unnesting and View Merge

摘要：本文内容系转载，如有侵犯你的知识产权，烦请及时告知本人，本人将即刻停止侵权行为。参考网址：http://space.itpub.net/27064837/viewspace-746501 http://space.itpub.net/471666/viewspace-694608 http://jonathanlewis.wordpress.com/2008/02/17/pushing-predicates-2/ http://www.oraclefans.cn/forum/showtopic.jsp?rootid=6963 http://www.... 阅读全文

posted @ 2012-11-25 16:52 Coldest Winter 阅读(312) 评论(0) 推荐(0)

Difference between Nested & Correlated Subqueries

摘要：参考网址：http://sql-plsql.blogspot.com/2011/09/difference-nested-correlated-subquery.html http://www.java2s.com/Tutorial/Oracle/0040__Query-Select/WritingNestedSubqueries.htm http://www.java2s.com/Tutorial/Oracle/0040__Query-Select/WritingCorrelatedSubqueries.htm需要使用代理方可打开。一、嵌套子查询和关联子查询的区别... 阅读全文

posted @ 2012-11-25 09:12 Coldest Winter 阅读(404) 评论(0) 推荐(0)

Procedure-Level Atomicity（存储过程级别的原子性:）

摘要：网址：http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:1270688200346183091异常的处理：http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:1270688200346183091It is interesting to note that Oracle considers PL/SQL anonymous blocks to be statements as well. Consider the fo 阅读全文

posted @ 2012-10-10 07:43 Coldest Winter 阅读(526) 评论(0) 推荐(0)

Bind variables in 'in' condition（在in中动态的绑定参数（参数个数可变））

摘要：Varying in lists... 在书写SQL语句的过程中，我们可能会遇到，在其中的一张表中会存储一个ID串的字段，那么在写SQL语句的过程中，我们可能会出现以下错误的写法，1 SELECT * FROM WHERE col IN (SELECT col2 FROM dual)本文将给出为什么该语法错误的原因：本文也给出了通用的几种处理方法：网址：http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:110612348061 http://asktom.oracle.com/pls/asktom/f... 阅读全文

posted @ 2012-09-24 07:52 Coldest Winter 阅读(627) 评论(0) 推荐(0)

Row Chaining and Row Migration（转载）

摘要：声明:本文为转载,如果有侵犯知识版权，请通知本人，本人将即刻停止侵权行为:转载网址：http://blog.csdn.net/huang_tg/article/details/5722005本文主要介绍Oracle的行链接（Row Chaining）与行迁移（Row Migration）的产生原因及调整方法。如果数据库存在大量的行迁移及行链接，那么对数据库的性能影响是非常大的。关于数据在数据块中是如何存储的可以参考文章：http://blog.csdn.net/huang_tg/archive/2010/07/08/5722114.aspx及http://blog.csdn.net/huang 阅读全文

posted @ 2012-09-13 21:56 Coldest Winter 阅读(175) 评论(0) 推荐(0)

Clustering Factor: Row Migration’s Victim（转载）

摘要：Clustering Factor: Row Migration’sVictimInPerformanceon2010-03-09at10:15 This article describes the effects of a high row migration rate on the clustering factor and the optimizer’s ability to select the best execution plan. 主要介绍了在高的行链接的情况下对对于聚集因子的影响和对优化器选择最佳执行计划的影响。In my previous article—Row Migra. 阅读全文

posted @ 2012-09-13 06:54 Coldest Winter 阅读(310) 评论(0) 推荐(0)

Row Migration and Row Movement（转载）

摘要：Row Migration and RowMovement声明:本文为转载,如果有侵犯知识版权，请通知本人，本人将即刻停止侵权行为:转载网址：http://blog.fatalmind.com/2010/02/23/row-migration-and-row-movement/InPerformanceon2010-02-23at10:52 The Oracle database knows three distinct processes that are easily mixed up: Row Chaining,Row Migration and Row Movement. Lu... 阅读全文

posted @ 2012-09-12 07:47 Coldest Winter 阅读(410) 评论(0) 推荐(0)

Row Movement in Oracle-转载

摘要：Row Movement 阅读全文

posted @ 2012-09-11 22:05 Coldest Winter 阅读(1451) 评论(0) 推荐(0)

The Secrets of Oracle Row Chaining and Migration（转载）

摘要：Row Chaining and Migration 阅读全文

posted @ 2012-09-10 06:48 Coldest Winter 阅读(489) 评论(0) 推荐(0)

Index Clustering Factor -- Why it Matters

摘要：声明:本文为转载,如果有侵犯知识版权，请通知本人，本人将即刻停止侵权行为:转载网址：http://www.dbasupport.com/forums/archive/index.php/t-38893.htmlIntroduction The index custering factor is a key statistic that can improve both the Oracle optimizer's performance, and the technician's understanding of the utility of an index. index C 阅读全文

posted @ 2012-09-08 22:21 Coldest Winter 阅读(216) 评论(0) 推荐(0)

Oracle Index Clustering Factor 说明（转载）

摘要：Oracle Index Clustering Factor 阅读全文

posted @ 2012-09-08 21:55 Coldest Winter 阅读(281) 评论(0) 推荐(0)

Reading and Understanding Execution Plans

摘要：本文翻译来自于：Oracle Database Performance Tuning Guide, 10g Release 2 (10.2).pdf 官方下载地址：10g：http://www.oracle.com/pls/db102/homepage 11g：http://www.oracle.com/pls/db111/homepage To execute a SQL statement, Oracle might need to perform many steps. Each of thesesteps either retrieves rows... 阅读全文

posted @ 2012-08-27 07:17 Coldest Winter 阅读(210) 评论(0) 推荐(0)

Oracle Core 学习笔记一 -- Redo 和 Undo 机制详解(转载)

摘要：本文转载自:CSDN的知名Oracle博主:tianlesoftware本文转载网址：http://blog.csdn.net/tianlesoftware/article/details/7626421本文英文书籍的下载地址:http://dl.dbank.com/c0hf1ba269本文源码下载：http://www.apress.com/9781430239543为了便于学习，本人对文章中新增了一些自己的注释:如果有侵犯您权益的问题，请及时告知本人，本人将即刻停止侵权行为: The single most important feature of Oracle is one that f 阅读全文

posted @ 2012-07-14 07:05 Coldest Winter 阅读(1282) 评论(0) 推荐(0)

Expert_PL_SQL_Practices-----Do Not Use

摘要：1、Row-by-Row Processing 1 DECLARE 2 CURSOR C1 IS 3 SELECT Prod_Id, Cust_Id, Time_Id, Amount_Sold 4 FROM Sales 5 WHERE Amount_Sold > 100; 6 C1_Rec C1%ROWTYPE; 7 l_Cust_First_Name Customers.Cust_First_Name%TYPE; 8 l_Cust_Last_Name Customers.Cust_Last_Name%TYPE; 9 BEG... 阅读全文

posted @ 2012-05-27 22:58 Coldest Winter 阅读(367) 评论(0) 推荐(0)

Expert PL/SQL Practices for Oracle Developers and DBAs

摘要：http://www.apress.com/oracle/pl-sql/9781430234852These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. LetExpert PL/SQL Practicesopen your eyes to the full power of Oracle’s world-class language for the databa 阅读全文

posted @ 2012-05-14 05:54 Coldest Winter 阅读(298) 评论(0) 推荐(0)

随笔分类 - 读书笔记