• 博客访问: 96818
  • 博文数量: 47
  • 用 户 组: 普通用户
  • 注册时间: 2013-11-23 01:02





发布时间:2005-04-20 00:04:29

1. 使用dbms_application_info设置longops的相关信息, 这样我们就可以使用v$session_longops视图来监控我们的程序执行的进度了^_^.在第一个session中执行一个执行时间比较长的匿名块, 我们再在另一个session中监控, 这个session的执行进度^_^.SQL> set echo onSQL> @bbb.sqlSQL> declare  2    rindex binary_integer;  3    slno      binary_integer;  4    total  number := 900;  5    sofar  number ......【阅读全文】

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

发布时间:2005-04-19 20:31:53

上次过去Rudolf问我的问题, 一时不知怎么回答, 其实我很少使用trprof进行诊断, 只是在使用执行计划与相关系统信息都不能找出较优或者无法找到问题的时候, 才会考虑使用tkprof来解决问题. 这位老兄的帖子刚好解决了我的疑惑.. 就直接引用过来了:-) 如有版权问题, 请联系本人^_^Why dose Oracle have 2 fetches for 1 exectuion on dual? Have you ever noticed that there are 2 fetches for 1 exectuion of such simple sql SQL>select * from dual; Let's turn on the 10046 event and check the trace file. PARSING IN ......【阅读全文】

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

发布时间:2005-04-18 09:19:38

Preventing Oracle from Using an IndexCompliments of Oracle FAQ In certain cases, you may want to disable the use of a specific, or all indexes for a given query. Here are some examples demonstrating several methods for doing so:-- Adding an expression to the indexed columnSQL>select count(*) from t where empno+0=1000; COUNT(*)---------- 1Execution Plan--------------------------------------------- ----- -------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=3) ......【阅读全文】

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

发布时间:2005-04-15 11:15:56

initial and lmt - 8i  July 09, 2003 Reviewer:  M. Bento  from Lisbon, Portugal When moving a table into a uniform LMT using alter table without the storage clause the table's initial is not set to the LMT default initial parameter but keeps its previous value ending up with tables with different initial extents inside the same LM tablespace.Should one set the initial along with the alter table in order to prevent fragmentation?Thanks. Followup:  you are confusing the initial ......【阅读全文】

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

发布时间:2005-04-15 09:05:51

Raghu -- Thanks for the question regarding "moving tables across tablespaces", version originally submitted on 2-May-2000 13:20 Eastern US time, last updated 14-Apr-2005 18:04Tom's latest followup | GOTO a Bookmarkable Page | Bottom You Asked (Jump to Tom's latest followup)Tom, What is the best way to move tables from one tablespace to another tablespace in the same instance? and we said...I'll give you the Oracle8.0 and before answer as well as the Oracle8i and above answer (in 8i,......【阅读全文】

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

jametong2014-06-27 16:58


回复  |  举报

登录 注册