SQLT(SQLTXPLAIN)
来源:互联网 发布:直销会员管理系统 php 编辑:程序博客网 时间:2024/04/28 22:54
SQLT也叫SQLTXPLAIN,如果某一条SQL执行效率很低,也不知道从哪里下手,可以使用SQLT来收集和性能相关的各种信息(如:Execution plans, Cost-based Optimizer CBO statistics, Schema objects metadata, Performance statistics, Configuration parameters...)
How many and which tables are involved?
How big are the objects involved?
How many, what type and what columns are indexed?
How accurate are the optimizer statistics?
Are there histograms on the columns?
Are there any non-default init.ora parameters that could be causing problems?
What is the execution plan?
Has it changed recently?
......
详见Note 215187.1 : SQLT (SQLTXPLAIN) - Tool that helps to diagnose SQL statements performing poorly
Step 1) Download SQLT
Step 2) Install SQLT
Step 3) Execute SQLT
Step 4) Review the output
- SQLT(SQLTXPLAIN)
- SQLTXPLAIN
- 【SQL工具】SQL调优和诊断神器SQLTXPLAIN (SQLT)简介
- SQLT安装及使用
- sqlt之一 安装篇
- SQLT工具的安装过程
- SQLT 诊断工具 (文档 ID 1526574.1)
- 官方文档关于sqlt工具的介绍
- SQLT -- Oracle单句SQL性能调优工具
- hibernate级联查询执行n+1次sqlt语句问题(内含解决办法,优化方式)
- 移植opencv 到codec engine 成功
- 设计模式11 - Flyweight
- C++第15周项目2——杨辉三角
- visualsvn集成vs的插件如何使用新的repository
- 使用样式控制gridview的宽度
- SQLT(SQLTXPLAIN)
- 2 双向链表 PushBack/PopFront
- 纵谈进程枚举
- linux-0.11 系统调用 int 0x80 实现
- Java开源自然语言处理工具-LingPipe
- exit,fread,fgetc
- C++第15周项目5——-电子词典
- IQueryable & IEnumberable 区别
- [C++]c++沉思录第10章例子“字符图像”