- 博客(14)
- 收藏
- 关注
RSS订阅转载 sql hint
explain plan from @?/rdbms/admin/utlxplsselect /*+ index(tablename,index_name) */ * from table_name; ...
2012-07-10 16:21:37
79
转载 push_subq
select /* + push_subq */ * from emp a,dept bwhere a.deptno=b.deptno and exists (select 1 from dept1 where dept1...
2012-07-10 16:13:33
90
转载 online shring database segments online
alter table t shring space;alter table t enable row movementalter index index_name coalescealter index index...
2012-07-10 16:09:09
73
转载 绑定变量
参数cursor_sharing:提示：强制SQL硬解析，避免children cursor过多还来的负面性能影响cursor_sharing_exact例sqlplus "/as sysdba"...
2012-07-10 15:57:02
70
转载 bitmap conversion 执行计划导致CPU100%
bitmap conversion from /to rowidsalter session set "_b_tree_bitmap_plans"=false;alter session set "_b_tree_bit...
2012-07-10 15:54:32
178
转载 sqlid hash_value互相转换
select sql_id,hash_value,dbms_utility.sqlid_to_sqlhash(sql_id)from v$sql where rownum<9select lower(t...
2012-07-10 15:20:09
202
转载 dbms_stats vs analyze监控索引的使用
当某个索引处于monitoring usage的时候，如果使用dbms_stats去分析表并且同时分析索引，会将该索引的v$object_usage.USED设置为TRUE，导致监控了N天的可疑索引前功近弃。这并不是我们所希望的...
2012-07-10 14:46:38
55
转载 Oracle对象支持重命名
CLUSTER can’t be renamed.FUNCTION can’t be renamed.INDEX ALTER INDEX old_name RENAME TO new_name;INDEX PARTITION A...
2012-07-10 14:46:11
110
转载 oracle shutdown immediate 前最好的习惯
for large transactionsselect sum(used_ublk) from v$transaction;select * from v$fast_start_transactionsselect...
2012-07-10 14:24:13
91
转载 软解析和硬解析
9i-10g 术语1、用“library cache lock”代表名为library cache lock的enqueue；2、用“library cache pin”代表名为library cache pin的e...
2012-07-07 23:25:26
151
转载 单实例升级到10.2.4
一、先决条件1。表空间需求system表空间至少10M空间可用2。系统参数show parameter shared_pool_sizeshow prameter java_pool_sizealter ...
2012-07-06 08:52:34
51
转载 linux oracle hugepages 配置和案例分析
一.系统当前状态[root@node1 ora11g]# cat /proc/meminfo | grep -i hugepages HugePages_Total: 0 HugePages_Free:...
2012-07-05 14:51:41
108
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人