2012-12-12 - 12-14 11gR2 "2 Day + Performance Tuning Guide" page 52 - 168
来源:互联网 发布:杀出重围 知乎 编辑:程序博客网 时间:2024/06/05 05:10
Creating a SQL Tuning Set: Load Method -- SQL TUNING SET的加载方法
Loading Active SQL Statements Incrementally from the Cursor Cache You can load active SQL
statements from the cursor cache into the SQL tuning set incrementally over a
specified period of time. This technique enables you to not only collect current and
recent SQL statements stored in the SQL cache, but also SQL statements that will run
during a specified time period in the future.
-- 从CURSOR CACHE增量加载SQL语句,包括未来某段时间的SQL语句都会加载入
Loading SQL Statements from the Cursor Cache You can load SQL statements from the
cursor cache into the SQL tuning set. However, because only current and recent SQL
statements are in the SQL cache, collecting these statements only once may result in a
SQL tuning set this is not representative of the entire database workload.
-- 从CURSOR CACHE非增量加载SQL语句
Loading SQL Statements from AWR Snapshots You can load SQL statements captured in
AWR snapshots. This is useful when you want to collect SQL statements for specific
snapshot periods of interest that can be used for later comparison or tuning purposes.
-- 从AWR SNAPSHOTS中加载
Loading SQL Statements from AWR Baselines You can load SQL statements captured in
AWR baselines. This technique is useful when you want to collect SQL statements that
are representative of a time period during known performance levels that can be used
for later comparison or tuning purposes.
-- 从AWR BASELINES中加载
Loading SQL Statements from a User-Defined Workload You can load SQL statements by
importing from a table or view. This technique is useful if the workload you want to
analyze is not currently running on the database or captured in an existing AWR
snapshot or AWR baseline.
-- 从USER-DEFINED WORKLOAD中加载
- 2012-12-12 - 12-14 11gR2 "2 Day + Performance Tuning Guide" page 52 - 168
- 2012-12-11 11gR2 "2 Day + Performance Tuning Guide" page 1 - 51
- 2012-12-19 - 12-20 11gR2 "Performance Tuning Guide" page 50 - 69
- 2012-12-17 11gR2 "Performance Tuning Guide" page 1 - 49
- 2012-12-25 11gR2 "Performance Tuning Guide" page 70 - 82
- 2012-12-27 11gR2 "Performance Tuning Guide" page 83 - 113
- 2013-1-6 - 1-7 11gR2 "Performance Tuning Guide" page 114 - 141
- 2013-1-23 - 1-24 11gR2 "Performance Tuning Guide" page 142 - 151
- 2013-1-30 - 1-31 11gR2 "Performance Tuning Guide" page 152 - 162
- 2012-12-2 - 12-3 11gR2 "Database Installation Guide for Linux" page 1 - 47
- 2012-12-6 - 12-7 11gR2 "Database Installation Guide for Linux" page 143 - 246
- 2012-11-12 11gR2 "Backup and Recovery User's Guide" page 1 - 29
- 2012-11-30 - 12-1 11gR2 "Backup and Recovery User's Guide" page 530 - 608
- 2012-12-4 11gR2 "Database Installation Guide for Linux" page 48 - 97
- 2012-12-5 11gR2 "Database Installation Guide for Linux" page 98 - 142
- Performance Tuning Guide
- 2012-10-12 11gR2 concepts page 129 - 160
- 2012-11-14 11gR2 "Backup and Recovery User's Guide" page 65 - 108
- windows下使用ssh认证连接git服务器
- install windows8 12.04 on macbook pro md101 2012-7 version
- 使用beanUtils操作属性
- windows上硬盘安装fedora
- Hibernate: detached entity passed to persist异常解决
- 2012-12-12 - 12-14 11gR2 "2 Day + Performance Tuning Guide" page 52 - 168
- 成长路
- 新的开始-写在毕业的季节
- 【Android游戏开发十二】(保存游戏数据 [上文])详解SharedPreference 与 FIleInputStream/FileOutputStream将数据存储到SD卡中!
- 读书笔记《30天自制操作系统》day08
- Python 数据库操作
- x264中get_frame_total_yuv函数欣赏(顺便复习和巩固fseek函数和ftell函数的用法)
- 第26节 Get和Set方法
- wireshark使用