- 博客(7)
- 收藏
- 关注
原创 python 传入类型错误 导致走index fast full scan
1.select esbflowno from esb2_trans_log where esbserviceflowno=:esbserviceflownoselect sql_id, sql_text, version_count, loads, hash_value, address, plan_has...
2018-09-20 09:28:03 236
原创 oracle 执行计划改变
1.sqlSQL> set linesize 200SQL> set pagesize 200SQL> select nvl(max(to_number(mingxibh)), 0) as lMaxXuhao from klnl_dkkhmx where dkjiejuh = '20151020000935' and farendma = '9999' ...
2018-09-14 17:29:15 1745
原创 oracle 根据pid查sql
1.SQL> select sid,serial#,status,process,machine,port,program, module from v$session a where a.username='TLCBUSER'; SID SERIAL# STATUS PROCESS MACHINE PORT PROGRAM MODULE...
2018-09-14 13:35:03 1902
原创 sql加了hints sql_id就发生变化
v$sqlv$sql 列出统计信息在shared SQL areas 没有GROUP BY 字句,每行包含每个原始SQL文本的每个child v$sql 显示的统计信息是通常更新在查询执行尾端。v$sqlarea:v$sqlarea v$sqlarea 显示统计信息在恭喜SQL区域,每个SQL语句 一行测试1:先清空shared pool:SQL> ...
2018-09-13 18:25:54 308
原创 index fast full scan
-- Create tablecreate table TEST( farendma VARCHAR2(4) default '' not null, mingxibh VARCHAR2(32) default '' not null, dkzhangh VARCHAR2(32) default '' not null, dkjiejuh VARCHAR2(35) defau...
2018-09-13 10:15:54 239 1
原创 v$sqlarea 和v$sql 多版本子游标
select nvl(max(to_number(mingxibh)), 0) as lMaxXuhao from klnl_dkkhmx where dkjiejuh=:1 and farendma=:2 and trim(translate(mingxibh,'0123456789',' ')) is null SQL_TEXT SQL_FU...
2018-09-12 18:15:23 267
原创 sql当hints index fast full scan走不了 会走index range scan的情况
explain plan for select /*+INDEX_FFS(a t100_idx1)*/ owner from t100 a where a.owner='TLCBUSER';select * from table(dbms_xplan.display());PLAN_TABLE_OUTPUTPlan hash value: 4259608525 -------...
2018-09-12 16:44:55 367
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人