- 博客(23)
- 收藏
- 关注
RSS订阅转载 trace lsnrctl
strace lsnrtcl start this command will help to trace failure reason. ...
2012-12-16 11:47:45
166
转载 oracle character set
-- 3.5 字符集的更改 ( P94 )-- 数据库创建以后，如果需要修改字符集，通常需要重建数据库，通过导入导出的方式来转换。也可以通过以下方式更改：ALTER DATABASE CHARACTER SET-- 注意修改数...
2012-12-11 13:50:33
185
转载 dbms_advance_rewrite
dbms_advance_rewrite来workround原始sql:select /*+ opt_param('query_rewrite_integrit','trusted') */ * from t_or where ...
2012-12-02 21:39:27
153
转载 min max and page
棉花糖ONE 2009年03月11日 19:57 阅读(51) 评论(1) 分类：个人日记 权限: 公开 字体：大▼ 小 中 大 更多▼ 设置置顶 权限设置 推荐日志 转为私密日志 删除编辑1.最大值和最小值,如果从索引结构上来...
2012-12-02 19:54:14
278
转载 function of sql
将函数解开，你这sql调用了太多的函数，所以会慢。建议：1.如果是11g的话启用函数缓存，这样对于相同的输入参数，返回值如果一样的话，只需计算一次。2.如果无法使用1.，就将函数解开，你这个写代码的人是受到java编程的影响，习...
2012-12-02 15:09:13
85
转载 workarea_size_policy
alter session set workarea_size_policy=manual;alter session set sort_area_size = 尽量大一点的值 ...
2012-12-02 14:27:12
357
转载 disable cartisian
alter session set "_optimizer_mjc_enabled" = false; ...
2012-12-02 11:57:47
172
转载 count, max, dense_rank
selectorderid, canclestate, reportstatusfrom(select orderid, canclestate, ...
2012-11-28 12:58:59
134
转载 contains and like '%abc%'
scott@ORCL> CREATE UNIQUE INDEX SCOTT.I_DEPT_DEPTNO_DNAME ON SCOTT.DEPT2( DNAME);Index created.scott@ORCL&g...
2012-11-28 09:27:40
117
转载 execution plan
select * from table(dbms_xplan.display_cursor(null,null,'iostats last')); (I/O) SELECT * FROM table(dbms_xplan....
2012-11-27 23:16:38
91
转载 hint no_unnest, push_subq, push_pred
http://space.itpub.net/15415488/viewspace-663969http://www.itpub.net/thread-1391316-1-1.htmlswap_join_in...
2012-11-27 22:22:09
116
转载 index about null
about sql : select * from user_table object_id is null;even though there is index about object_id , execution...
2012-11-25 15:46:58
86
转载 track somebody do in oracle
create table sys.audit_tracefile (logontime date, sid number, ins_id number, ...
2012-11-23 10:34:57
90
转载 consistent gets and db block gets
http://mwidlake.wordpress.com/2009/06/02/what-are-consistent-gets/http://jonathanlewis.wordpress.com/2009/06/...
2012-11-22 22:40:48
82
转载 hint gather_plan_statistics AND cardinality
hint gather_plan_statistics AND cardinalitydbms_xplan.display_cursor('sqlid', 0,'ALL IOSTATS LAST')链接:http://w...
2012-11-19 17:16:31
162
转载 v$mystat, v$statname
v$mystat by which we can select current session id and performance consume.v$sessstat is for sessions si...
2012-11-18 19:01:56
133
转载 dump file (index, block, control file, log ,date file)
dump index:alter session set events 'immediate trace name treedump level ';dump control file:alter ...
2012-11-18 17:36:41
87
转载 remove the column of big table
alter table tt set unused column age;alter table tt drop unused column; ...
2012-11-18 16:24:09
67
转载 oracle rowid detail
the following is my practise based on warehose's rowidselect u.rowid from knta_users u where u.username='admin';...
2012-11-18 11:27:40
78
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人