性能测试须知
转自: http://bbs.51testing.com/viewthread.php?tid=279799&extra=&page=1没有任何需求的情况下,如何展开性能测试工作?1、性能测试前需要做哪些准备工作?2、没有需求的情况下,如何去搜集有利的测试需求?刚好...
Oracle 性能相关的几个 视图 和 参数
转自:http://blog.csdn.net/tianlesoftware/article/details/5867276 Oracle 性能相关的几个 视图 和 参数 一.性能视图 &nbs...
Oracle SQL的优化
转自:http://blog.csdn.net/tianlesoftware/article/details/4672023 Oracle SQL的优化 SQL的优化应该从5个方面进行调整:1.去掉...
Oracle Hint
转自:http://blog.csdn.net/tianlesoftware/article/details/5833020 Oracle Hint 分类: Oracle 性能调优 2010-08-23 21:23 ...
Oracle 索引 详解
转自:http://blog.csdn.net/tianlesoftware/article/details/5347098 Oracle 索引 详解 一.索引介绍 1.1 索引的创...
多表连接的三种方式详解 HASH JOIN MERGE JOIN NESTED LOOP
转自:http://blog.csdn.net/tianlesoftware/article/details/5826546 多表连接的三种方式详解 HASH JOIN MERGE JOIN NESTED LOOP 在多表联合查询...
Oracle Statistic 统计信息 小结
转自:http://blog.csdn.net/tianlesoftware/article/details/4668723Oracle Statistic 统计信息 小结 分类: Oracle 性能调优 200...
Oracle 索引扫描的五种类型
转自:http://blog.csdn.net/tianlesoftware/article/details/5852106 Oracle 索引扫描的五种类型 分类: Oracle 高级知识 ...
Oracle 索引的维护
转自:http://blog.csdn.net/tianlesoftware/article/details/5680706 Oracle 索引的维护 一.查看系统表中的用户索引在Oracle中,SYST...
How The Oracle Database Processes SQL Statements
The Oracle Database Concepts is a great resource not only if you are just getting started with Oracle, but also if you are an experienced Oracle professional and looking to review the basic concept...
Oracle 高 Version counts 问题说明
转自:http://blog.csdn.net/tianlesoftware/article/details/6628232Oracle 高 Version counts 问题说明一. version count 说明 MOS上有...
Throughput part 4: A day at the races (Hotspotting case)
转自:http://www.vmdamentals.com/?p=330The fourth part of this triptych ( ) is a customer case of hotspotting on storage. The graphs speak for themselves! Some storage design decisions they made ...
Throughput part 3: Data alignment
转自:http://www.vmdamentals.com/?p=328A lot of people have discovered yet another excuse why their environment is not quite performing as it should: misalignment. Ever since a VMware document sta...
Throughput part 2: RAID types and segment sizes
转自:http://www.vmdamentals.com/?p=296In part one I covered all stuff you can think of in regards to delays and latencies you encounter on physical disk drives and solid states. Now it is time to ...
Throughput part 1: The Basics
转自:http://www.vmdamentals.com/?p=266As I tackle more and more disk performance related issues, I thought it was time to create a series of blogposts about spindles, seektimes, latency and all th...
Oracle 4种Join 类型
Oracle 4种Join 类型要想了解如何分析执行计划就必须先了解join 的种类及机制,下面对oracle的4中join 方法做个总结。一、查询优化器如何执行join 语句在有join的语句中优化器是如何选择执行计划的呢?优化器需要...
Oracle中的Hash Join祥解
Oracle中的Hash Join祥解作者: fuyuncat来源: www.HelloDBA.com转自:http://www.hellodba.com/Doc/Oracle_Hash_Join.htm一、 hash join概念 hash join(HJ)是一种用于equ...
Oracle 常见的33个等待事件
Oracle 常见的33个等待事件转自:http://blog.csdn.net/tianlesoftware/archive/2010/08/12/5807800.aspx 300) {text = text + "\r\n\n本文来自CSDN博客,转载请标明出处:" + location.href;...
ORACLE锁机制研究
ORACLE锁机制研究转自:http://blog.chinaunix.net/u2/66205/showart_527088.html锁概念基础数据库是一个多用户使用的共享资源。当多个用户并发地存取数据时,在数据库中就会产生多个事务同时存取同一数据...
Secret of oracle Logical IO: Full Table Scan: Part 2
Secret of oracle Logical IO: Full Table Scan: Part 2作者: fuyuncat 来源: www.HelloDBA.com Full Table Scan --- Medium Table Then, let's involve more factors into the proce...