11g中如何禁用自动统计信息收集作业

11g中如何禁用自动统计信息收集作业?

因为11g中auto stats gather job被集成到auto task中,所以与10g中的禁用方式不一样:

 

 

SQL> select client_name,status from DBA_AUTOTASK_CLIENT;

CLIENT_NAME                                                      STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection                                  ENABLED
auto space advisor                                               ENABLED
sql tuning advisor                                               ENABLED

begin
DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'auto optimizer stats collection',
operation => NULL,
window_name => NULL);
end;
/
PL/SQL procedure successfully completed.

SQL>  select client_name,status from DBA_AUTOTASK_CLIENT;

CLIENT_NAME                                                      STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection                                  DISABLED
auto space advisor                                               ENABLED
sql tuning advisor                                               ENABLED

Richard Niemiec又一力作《Oracle Database 11g Release 2 Performance Tuning Tips & Techniques》

对Oracle数据库调优性能浓厚的朋友肯定没有错过TUSC著名的Richard Niemiec的<Oracle Database 9i/10g Performance Tuning & Tips & Techniques> ,这2本书目前有中文译版; 这2本书包含了 Richard Niemiec 丰富的Oracle Database 调优经验、详细的案例研究。 Richard Niemiec是一名世界顶尖的Oracle优化专家,同时他也是一位Oracle认证的管理大师OCM, 他的书为优化人员提供了大量的提示和技巧:

 

 

 

 

随着10g 版本正式进入Sustaining Support, 12c R1版本可能在12年末、13年初release , 现在正是 11g Release 2开始在国内大范围推广使用的时段。

 

如果你现在对 11g 的Tuning 新特性还不甚了解,包括如:adaptive Cursor Sharing、Result Cache、SQL Performance Analayze …. 。 你完全需要一本 11g 调优的完全指南,  而 Richard Niemiec 的 <Oracle Database 11g Release 2 Performance Tuning Tips & Techniques> 就是这样一本好书, 奉上封面和章节目录, 虽然这本书目前还没有中译版,但是相信很快可见:

 

 

 

 

·        Chapter 1   11g R1 & R2 New Features: Rewritten completely for basic Oracle11gR2 new features

·        Chapter 2   Basic Index Principles: Expanded to cover all of the index types and tested for 11gR2

·        Chapter 3   Disk Implementation: Updated for 11gR2: ASM, LMT, Auto UNDO, and improved I/O sections

·        Chapter 4   Initialization Parameters: Added MEMORY_TARGET and updated parameters for 11gR2

·        Chapter 5   Enterprise Manager & Grid Control: Added 11g screen shots, Grid Control, and some Exadata

·        Chapter 6   Explain Plan, SQL Plan Management, DBMS_MONITOR, and TRCSESS

·        Chapter 7   Using Hints for Tuning: Added new hints and updated others—the best resource for hints!

·        Chapter 8   Basic Query Tuning: Updated for 11gR2; added Result Cache and SQL Performance Analyzer

·        Chapter 9   Table Joins & Advanced Tuning: Updated for 11gR2; updated block tuning and added DB Replay

·        Chapter 10   PL/SQL Tuning: Expanded again as PL/SQL tuning expands; added 11gR2 changes

·        Chapter 11   Exadata, RAC, & Parallel Features: Added Exadata, improved RAC, & updated Parallel Query

·        Chapter 12   The V$ Views: Expanded again to show more V$ view queries, especially those new in 11gR2

·        Chapter 13   The X$ Tables: Expanded X$ queries, trace section, and X$ naming conventions

·        Chapter 14   AWR Report & Statspack: Updated AWR, Statspack for 11gR2; added mutexes & block tuning

·        Chapter 15   Quick System Review: Updated for 11gR2 and for much larger systems

·        Chapter 16   Monitoring the System Using Unix Utilities: Unix chapter updated to include more commands

·        Appendix A   Key Initialization Parameters: Updated queries for 11gR2 & new Top 25 initialization parameters

·        Appendix B   V$ Views: Updated for 11gR2 with updated V$ view queries

·        Appendix C   X$ Tables: Updated for 11gR2 with updated X$ queries

收到了TUSC寄来的V$ View For Oracle Database 11g

V$ view For oracle 10g版本的总览图相信大家都有看过, 而 这个11g版本的 我专门问了一下TUSC ,目前只有hard copy 版本的, 一起欣赏下吧:

 

IMG_20120306_105051

 

IMG_20120306_104935

Oracle 11g Database SQL语言基础 by Kevinlin

同事 Kevinlin 写的一个<Oracle 11g  Database SQL语言基础> ,内容非常丰富, 详细介绍了11g SQL的一些新特性和基础概念,  原本是给客户做培训用的 , 这里分享一下, 感谢Kevinlin在Oracle领域为我们做出的贡献!

 

简单介绍下 Kevinlin: 资深DBA ,高级Oracle技术支持,拥有超过10年的Oracle 管理使用经验, 擅长 故障诊断和性能调优。

 

下载地址:http://www.askmaclean.com/wp-content/uploads/2011/11/Oracle11g-Database-SQL语言基础.ppt

 

Download (PPT, 2.03MB)

 

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569