Bo's Oracle Station

查看: 2034|回复: 0

SQL Tuning和快速调优工具,1Z0-053第15章,课程第62/63次(2017-03-11星期日上下午)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-3-13 11:19:07 | 显示全部楼层 |阅读模式
上完1Z0-053第15章(SQL Tuning)
1Z0-052共19章(上完19章),1Z0-053共21章(上完19章),1Z0-063多租户部分共9章(上完0章)
总共上完全部49章中的38章

2017-03-12.sql:
  1.     select  t.NUM_ROWS , t.LAST_ANALYZED
  2.     from dba_Tables t
  3.     where t.TABLE_NAME='T_BIG' and
  4.        t.OWNER='HR';
  5.     begin
  6.     dbms_stats.delete_table_stats('HR','T_BIG');
  7.     end;
  8.     begin
  9.     dbms_advisor.quick_tune(advisor_name=>'SQL Access Advisor',
  10.     task_name=>'Mytask1',
  11.     attr1=>'select  sum(line)  from  hr.t_big group by text',
  12.     template=>'SQLACCESS_OLTP');
  13.     end;
  14.     begin
  15.     dbms_Stats.gather_table_stats('HR','T_BIG');
  16.     end;
  17.     select  t.NUM_ROWS , t.LAST_ANALYZED
  18.     from dba_Tables t
  19.     where t.TABLE_NAME='T_BIG' and
  20.        t.OWNER='HR';
  21.     begin
  22.     dbms_advisor.quick_tune(advisor_name=>'SQL Access Advisor',
  23.     task_name=>'Mytask2',
  24.     attr1=>'select  sum(line)  from  hr.t_big group by text',
  25.     template=>'SQLACCESS_OLTP');
  26.     end;
  27.     begin
  28.     dbms_advisor.quick_tune(advisor_name=>'SQL Access Advisor',
  29.     task_name=>'Mytask5',
  30.     attr1=>'select  sum(line)  from  hr.t_big group by type',
  31.     template=>'SQLACCESS_OLTP');
  32.     end;
  33.     ---
  34.     CREATE MATERIALIZED VIEW LOG ON
  35.     "HR"."T_BIG"
  36.     WITH ROWID, SEQUENCE("LINE","TEXT")
  37.     INCLUDING NEW VALUES;
  38.     grant create MATERIALIZED VIEW  to hr;
  39.     grant query rewrite to hr;
  40.     ALTER MATERIALIZED VIEW LOG FORCE ON
  41.     "HR"."T_BIG"
  42.     ADD ROWID, SEQUENCE("TYPE","LINE")
  43.     INCLUDING NEW VALUES;
  44.     CREATE MATERIALIZED VIEW hr.MV1
  45.     REFRESH FAST WITH ROWID
  46.     ENABLE QUERY REWRITE
  47.     AS SELECT TYPE C1, SUM(LINE) M1, COUNT(LINE)
  48.     M2, COUNT(*) M3 FROM HR.T_BIG GROUP BY TYPE;
  49.     begin
  50.     dbms_stats.gather_table_stats('HR','MV1');
  51.     end;
  52.     select  *  from dba_segments s
  53.     where s.SEGMENT_NAME  in ('T05318_A', 'I05318_A');
  54.     create table t05318_part ( a  number )
  55.         partition by range(a)
  56.        ( partition p1 values less than(10),
  57.          partition p2 values less than (maxvalue)) ;
  58.     select  *  from dba_segments s
  59.     where s.SEGMENT_NAME  in ('T05318_PART', 'I05318_PART');
  60.     select   s.bytes  from dba_segments s
  61.       where s.SEGMENT_NAME='I05318_B';
复制代码


复制代码

关于1Z0-053第18章的内容:
http://124.16.180.178:8080/studentguide_sec_O11g/1Z0-053-18/
游客,本帖隐藏的内容需要积分高于 100 才可浏览,您当前积分为 0


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 21:31 , Processed in 0.033854 second(s), 24 queries .

快速回复 返回顶部 返回列表