Bo's Oracle Station

查看: 2486|回复: 0

第27次活动:2017-10-25(星期三晚上7:00-9:30)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-10-25 20:03:05 | 显示全部楼层 |阅读模式
索引的树高的小实验:

Screenshot.png

  1. SQL> conn hr/oracle_4U
  2. Connected.
  3. SQL> create table t05111_c ( a char(2000)) ;

  4. Table created.

  5. SQL> create index i05111_c  on t05111_c(a) ;

  6. Index created.

  7. SQL> insert into t05111_c values ('A') ;

  8. 1 row created.

  9. SQL> commit;

  10. Commit complete.

  11. SQL> insert into t05111_c values ('B') ;

  12. 1 row created.

  13. SQL> commit;

  14. Commit complete.

  15. SQL> insert into t05111_c values ('C') ;

  16. 1 row created.

  17. SQL> commit;

  18. Commit complete.

  19. SQL> insert into t05111_c values ('D') ;

  20. 1 row created.

  21. SQL> commit;

  22. Commit complete.

  23. SQL> insert into t05111_c values ('E') ;

  24. 1 row created.

  25. SQL> commit;

  26. Commit complete.

  27. SQL> insert into t05111_c values ('F') ;

  28. 1 row created.

  29. SQL> commit;

  30. Commit complete.

  31. SQL> select  a  , dbms_rowid.rowid_block_number(rowid) from t05111_c;

  32. A
  33. --------------------------------------------------------------------------------
  34. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  35. ------------------------------------
  36. D









  37. A
  38. --------------------------------------------------------------------------------
  39. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  40. ------------------------------------










  41. A
  42. --------------------------------------------------------------------------------
  43. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  44. ------------------------------------







  45.                                  891


  46. A
  47. --------------------------------------------------------------------------------
  48. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  49. ------------------------------------
  50. E









  51. A
  52. --------------------------------------------------------------------------------
  53. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  54. ------------------------------------










  55. A
  56. --------------------------------------------------------------------------------
  57. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  58. ------------------------------------







  59.                                  891


  60. A
  61. --------------------------------------------------------------------------------
  62. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  63. ------------------------------------
  64. F









  65. A
  66. --------------------------------------------------------------------------------
  67. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  68. ------------------------------------










  69. A
  70. --------------------------------------------------------------------------------
  71. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  72. ------------------------------------







  73.                                  891


  74. A
  75. --------------------------------------------------------------------------------
  76. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  77. ------------------------------------
  78. A









  79. A
  80. --------------------------------------------------------------------------------
  81. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  82. ------------------------------------










  83. A
  84. --------------------------------------------------------------------------------
  85. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  86. ------------------------------------







  87.                                  895


  88. A
  89. --------------------------------------------------------------------------------
  90. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  91. ------------------------------------
  92. B









  93. A
  94. --------------------------------------------------------------------------------
  95. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  96. ------------------------------------










  97. A
  98. --------------------------------------------------------------------------------
  99. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  100. ------------------------------------







  101.                                  895


  102. A
  103. --------------------------------------------------------------------------------
  104. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  105. ------------------------------------
  106. C









  107. A
  108. --------------------------------------------------------------------------------
  109. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  110. ------------------------------------










  111. A
  112. --------------------------------------------------------------------------------
  113. DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
  114. ------------------------------------







  115.                                  895


  116. 6 rows selected.

  117. SQL> insert into t05111_c values ('G') ;

  118. 1 row created.

  119. SQL> commit;

  120. Commit complete.

  121. SQL> exec dbms_stats.gather_table_stats('HR','T05111_C') ;

  122. PL/SQL procedure successfully completed.

  123. SQL> truncate table t05111_c;

  124. Table truncated.

  125. SQL> exec dbms_stats.gather_table_stats('HR','T05111_C') ;

  126. PL/SQL procedure successfully completed.

  127. SQL> insert into t05111_c values ('A') ;

  128. 1 row created.

  129. SQL> insert into t05111_c values ('B') ;

  130. 1 row created.

  131. SQL> insert into t05111_c values ('C') ;

  132. 1 row created.

  133. SQL> commit;

  134. Commit complete.

  135. SQL> exec dbms_stats.gather_table_stats('HR','T05111_C') ;

  136. PL/SQL procedure successfully completed.

  137. SQL> insert into t05111_c values ('D') ;

  138. 1 row created.

  139. SQL> commit;

  140. Commit complete.

  141. SQL> exec dbms_stats.gather_table_stats('HR','T05111_C') ;

  142. PL/SQL procedure successfully completed.

  143. SQL>
复制代码
索引的日常维护:
  1. alter index hr.i05111_c coalesce ;

  2. alter index hr.i05111_c rebuild online;
复制代码
Screenshot-1.png

关于job1:
Screenshot.png

  1. alter user sysman identified by oracle_4U account unlock;

  2. alter user dbsnmp identified by oracle_4U account unlock;

  3. select  * from dba_scheduler_job_run_details s
  4.    where s.job_name='JOB1';

  5. select * from dba_scheduler_jobs s
  6.   where s.job_name='JOB1';

  7. select * from dba_scheduler_programs  s
  8. where s.program_name='PROGRAM1';

  9. select  * from dba_scheduler_running_jobs  s
  10.   where s.job_name='JOB1';

  11. select  * from dba_scheduler_schedules s
  12. where s.schedule_name='SCHEDULE1';

复制代码


回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-28 23:57 , Processed in 0.049254 second(s), 27 queries .

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