- 博客(6)
- 收藏
- 关注
RSS订阅转载 sql tuning (three utilities)
1. using the explain plan The EXPLAIN PLAN tool is great for this experimentation, as it immediately lets y...
2011-06-14 15:30:19
106
转载 segregated among tablespaces
The following bulleted points identify some of the conditions you might use to determine how segments should be se...
2011-04-18 17:04:32
120
转载 create index-organized table
How to create index-organized table===key clauseORGANIZATION:The ORGANIZATION clause lets you specify the order in...
2011-03-01 16:35:34
122
转载 create the database manually
1. ORACLE_SID=ocm export ORACLE_SID2. orapwd file=$ORACLE_HOME/dbs/orapwocm password=sys entries=10 force=y3....
2011-02-16 16:29:22
799
转载 install oracle on redhat9
1. check the memory grep MemTotal /proc/meminfo（physical） grep SwapTotal /proc/meminfo（swap）2. check the packa...
2011-02-14 16:01:07
75
转载 硬解析和软解析
开篇：不积跬步，无以至千里1.硬解析和软解析（如果硬分析率每秒大于100，则认为硬分析过多）p932 分析软硬解析的方法有几种？ 1. sql trace, tkprof查看分析信息 alter sessi...
2011-02-12 09:31:33
215
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人