Oracle
文章平均质量分 58
iteye_18449
这个作者很懒,什么都没留下…
展开
-
开始写《Effective Oracle by Design》的读书笔记。
Oracle自学有一小段时间了。Oracle 9i 10g编程艺术大体的看了一下。现在要深入学习Effective Oracle了,打算把里面的知识都弄明白,这本书不要囫囵吞枣了。打算写的详细一点,把里面不明白的知识点一起都记录下来。争取这个月能看完小布都是的9i Oracle 9i DBA Fundamental,和oracle 9i 性能调优系列培训先都快点看完...2010-04-08 11:18:18 · 88 阅读 · 0 评论 -
因工作需要开始读新书 Expert Oracle Database 10g Administration
本来应该trouble shooting看完了再换书的,不过现在工作需要直接操作数据了。 还是先看看DBA入门的书吧。 在网上找到了一本Expert Oracle Database 10g Administration 还不知道公司到底用的是哪个版本的呢,希望是10g, 别整个9i,那就晕了。 9i的文档还没有呢。 DBA TASK: Securi...原创 2010-06-18 13:35:17 · 85 阅读 · 0 评论 -
重新学习概率统计
做收入预测系统,虽然现在数学知识用的还不是那么多。 不过还是简单学习一下概念统计吧。 现在在看 这本书,还行,挺有意思的。《漫画统计学入门》(The Cartoon Guide to Statistics...原创 2010-06-17 13:53:26 · 112 阅读 · 0 评论 -
Oracle access path logical read "rules of thumb"
Access paths that lead to less than about 5 logical reads per returned row are probably goodAccess paths that lead to up to about 10-15 logical reads per returned row are probably acceptable.Acce...原创 2010-06-12 08:58:41 · 104 阅读 · 0 评论 -
Oracle Execution Plans
Obtaining Execution PlansExecute the SQL statement EXPLAIN PLAN,and then query the table where the output was written.Query a dynamic performance view showing the execution plans cached in the li...原创 2010-06-01 16:10:48 · 198 阅读 · 0 评论 -
I/O cost of table accesses based on index range scans
Access the root block of the index.Go through the branch blocks to locate the leaf block containing the first keys.For each key fulfilling the search criteria, do the following: Extr...原创 2010-06-01 16:06:27 · 122 阅读 · 0 评论 -
Chapter 1 Road Maps to Reading / Database Independence vs Dependence
Required Reading for Both Developers and DBAsConcepts GuideNew Features GuideRequired Reading for DevelopersApplication Developers Guid(Fundamentals)PL/SQL Users Guide and ReferencePerf...2010-06-01 16:06:15 · 106 阅读 · 0 评论 -
oracle init parameters
db_file_multiblock_read_countSegment headers ard read with single-block readsPhysical reads never span server extents.Blocks already in the buffer cache, except for direct read, are not reread ...2010-06-01 16:05:45 · 135 阅读 · 0 评论 -
Configuring the Query Optimizer
Configuration Road Map2010-05-27 13:13:16 · 80 阅读 · 0 评论 -
Debugging Events
DEBUGGING EVENTA debugging event, which is identified by a numeric value, is the means used to set a type of flag in a running database engine process. The aim is to change its behavior, for example...原创 2010-05-25 13:36:47 · 147 阅读 · 0 评论 -
Chapter 1 The Right Approach to Building Applications
常见的错误观念,及解决方法。错误:让开发人员与DBA各自为政。正确让他们有更多的观念交流。错误:测试开销太大。正确: 长久眼光来看,没有测试开销更大。错误:没有深入了解database都提供了什么。正确:原因可能是想着数据库的移植性,或是对db的不熟悉。DBA Don'ts:No views allowed.No stored procedure...2010-04-08 16:06:00 · 91 阅读 · 0 评论 -
Oracle 集合学习笔记
关联数组:一维的,无界限的,同种元素的稀疏集合,只在PL/SQL中可用。在oracle 8i中称为索引表,9i后改为关联数组。 嵌套表:一维的,无界限的,同种元素的稀疏集合;初始化是紧密的,可能被删除能稀疏的。嵌套表在PL和数据库里使用。 嵌套表是多重表,里面元素没有继承顺序。 变长数组:一维的同种元素集合。有限的,并且不是稀疏的。当定义变长数组时必须...原创 2010-08-04 15:35:20 · 129 阅读 · 0 评论