- 博客(6)
- 资源 (1)
- 收藏
- 关注
转载 MS Excel: SUBTOTAL Function (WS)
refer http://office.microsoft.com/en-ca/excel-help/subtotal-function-HP010062463.aspxReturns a subtotal in a list or database. It is generally easier to create a list with subtotals by using
2013-02-27 16:40:06 561
原创 find
要列出所有的0字节的文件:# find /path -size 0c -exec ls {} \;要直接删除所有的0字节的文件:# find /path -size 0c -exec rm {} \;
2013-02-10 17:27:56 280
转载 all_parameters
CREATE VIEW all_parametersAS SELECT i.ksppinm name, i.ksppdesc description, CV.ksppstvl VALUE, CV.ksppstdf isdefault, DECODE (BITAND (CV.ksp
2013-02-03 21:12:23 420
转载 How to check and disable Adaptive Cursor Sharing in 11g
_optimizer_adaptive_cursor_sharing=false disables the feature.There are 2 new columns in V$sql , IS_BIND_SENSITIVE and IS_BIND_AWARE that indicate the status for individual cursors.1.) The paramet
2013-02-03 21:07:46 1102
原创 格式化 执行计划
set pages 0 set linesize 300 column plan_table_output format a200SELECT * FROM TABLE(DBMS_XPLAN.display_cursor);
2013-02-03 21:05:57 584
转载 Adaptive Cursor Sharing in Oracle Database 11g
DBAs are always encouraging developers to use bind variables, but when bind variables are used against columns containing skewed data they sometimes lead to less than optimum execution plans. This is
2013-02-03 21:03:37 326
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人