warehouse客栈

ITPUB认证区版主

  • 博客访问: 4852355
  • 博文数量: 858
  • 用 户 组: 普通用户
  • 注册时间: 2007-12-07 15:08
  • 认证徽章:
个人简介

了解并联系warehouse: http://blog.itpub.net/19602/viewspace-1059211/

文章分类

全部博文(858)

文章存档

2018年(7)

2017年(7)

2016年(20)

2015年(19)

2014年(42)

2013年(65)

2012年(66)

2011年(87)

2010年(68)

2009年(103)

2008年(140)

2007年(142)

2006年(38)

2005年(53)

2004年(1)

发布时间:2008-11-12 13:32:54

doc的原话,随手记录!The SQL Access Advisor's recommendations are significantly improved if you gather structural statistics about table and index cardinalities, and the distinct cardinalities of every dimension level column, JOIN KEY column, and fact table key column. You do this by gathering either exact or estimated statistics with the DBMS_STATS package. Because gathering statistics is time-consuming and extreme statistical accuracy is not required, it is generally preferable to estimate sta......【阅读全文】

阅读(3352) | 评论(0) | 转发(0)

发布时间:2008-11-10 12:24:15

doc原话,随手记录一下!http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/storage003.htm#sthref369[@more@]Using the Undo AdvisorThe amount of undo data that can be retained depends on the size of your undo tablespace. If your tablespace is set to auto-extend, then Oracle automatically acquires space as needed. If you choose to disable auto-extend, however, then you are responsible for ensuring that the undo tablespace has enough space. In this situation, Oracle configures the undo re......【阅读全文】

阅读(4056) | 评论(0) | 转发(0)

发布时间:2008-11-10 11:20:03

doc的原话,随手记录一下![@more@]Tuning FAST_START_MTTR_TARGET and Using MTTR AdvisorTo determine the appropriate value for FAST_START_MTTR_TARGET for your database, use the following four step process:Calibrate the FAST_START_MTTR_TARGETDetermine the Practical Range for FAST_START_MTTR_TARGETEvaluate Different Target Values with MTTR AdvisorDetermine Optimal Size for Redo LogsCalibrate the FAST_START_MTTR_TARGETThe FAST_START_MTTR_TARGET initialization parameter causes the database to calculate......【阅读全文】

阅读(7755) | 评论(0) | 转发(0)

发布时间:2008-11-05 13:54:53

可以通过em使用Sql Tuning Advisor来寻找sql的优化建议,这里使用了package:DBMS_SQLTUNE获得sql优化的建议,只是想大致了解下Sql Tuning Advisor的过程。[@more@]SQL> create table t1(id int , name varchar2(10));表已创建。SQL> create table t2(id int , name char(1000));表已创建。SQL> begin 2 for i in 1..10000 loop 3 insert into t1 values(i,'a'||i); 4 insert into t2 values(i,'b'||i); 5 end loop 6 ; 7 commit; 8 end; 9 /PL/SQL 过程已成功完成。SQL> DECLARE 2 my_task_name VARCHAR2......【阅读全文】

阅读(82436) | 评论(0) | 转发(0)

发布时间:2008-11-05 13:49:24

尽管可以通过em使用Segment Advisor,不过我还是想通过调用dbms_advisor来简单的了解一下Segment Advisor的大致流程![@more@]SQL> create table tt1 as select * from dba_objects;表已创建。SQL> SET SERVEROUTPUT ONdeclareuf_blocks number ;uf_bytes number;fs1_blocks number;fs1_bytes number;fs2_blocks number;fs2_bytes number;fs3_blocks number;fs3_bytes number;fs4_blocks number;fs4_bytes number;full_blocks number;full_bytes number;begindbms_space.space_usage('TEST','TT1','TABLE',uf_blocks ,uf_bytes ,fs1......【阅读全文】

阅读(4803) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册