查看执行计划
博客专区 > rossiter 的博客 > 博客详情
查看执行计划
rossiter 发表于2年前
查看执行计划
  • 发表于 2年前
  • 阅读 10
  • 收藏 0
  • 点赞 0
  • 评论 0

【腾讯云】如何购买服务器最划算?>>>   

摘要: 查看执行计划

SELECT * FROM etl.etl_prcs_log t
WHERE t.log_msg LIKE "%T_CMN_LUFAX_COIN%"
  AND t.logtm >= trunc(SYSDATE) - 12/24
  ORDER BY 1 DESC ;
 
SELECT T.PRCS_ENDTM-T.PRCS_STRTM,T.* FROM etl.etl_prcs_run_ctrl t
WHERE t.table_name = "CRM_USER_PROFILE_INIT"
  AND T.PRCS_STRTM >= trunc(SYSDATE) - 12/24
  ORDER BY 4 DESC ; 
  
SELECT T.PRCS_ENDTM-T.PRCS_STRTM,T.* FROM etl.etl_prcs_run_ctrl t
WHERE t.table_name = "T_CMN_LUFAX_COIN"
  AND T.PRCS_STRTM >= trunc(SYSDATE) - 12/24
  ORDER BY 4 DESC ;   
  
SELECT * FROM DBA_HIST_SQLTEXT T
WHERE T.sql_text LIKE "%MERGE%T_CMN_LUFAX_COIN%";
/*0cs2yb2ku25dz
0mkqpwhdck3ss
6r2zu3xkdyzsr  */
SELECT DISTINCT t.sql_id,t.plan_hash_value,t.timeSTAMP FROM DBA_HIST_SQL_PLAN T
WHERE T.sql_id = "crktbyuh6wpd2"
ORDER BY T.timeSTAMP DESC ; 
SELECT DISTINCT t.sql_id,t.plan_hash_value,t.timeSTAMP FROM DBA_HIST_SQL_PLAN T,DBA_HIST_SQLTEXT tt
WHERE T.sql_id = tt.sql_id
  AND TT.sql_text LIKE "%INSERT%CRM_USER_PROFILE%"
ORDER BY T.timeSTAMP DESC ;
/*1 crktbyuh6wpd2 1577210454 2016-05-10 03:49:13
2 crktbyuh6wpd2 949450786 2016-04-28 16:46:00*/
SELECT t.plan_hash_value,t.operation,t.options,t.object_name,t.depth,t.cost FROM dba_hist_sql_plan t
WHERE t.sql_id = "crktbyuh6wpd2"
  AND t.plan_hash_value IN(1577210454)
  ORDER BY t.id,t.timeSTAMP;
SELECT t.plan_hash_value,t.operation,t.options,t.object_name,t.depth,t.cost FROM dba_hist_sql_plan t
WHERE t.sql_id = "crktbyuh6wpd2"
  AND t.plan_hash_value IN(949450786)
  ORDER BY t.id,t.timeSTAMP;


SELECT * FROM V$LOCKED_OBJECT A, DBA_OBJECTS B
WHERE A.OBJECT_ID = B.OBJECT_ID
and B.OBJECT_NAME = "USER_AUM_DETAIL_WFID";
SELECT * FROM V$SESSION WHERE SID = 4;
SELECT * FROM V$SQLAREA WHERE SQL_ID = "crktbyuh6wpd2";

 

共有 人打赏支持
粉丝 0
博文 10
码字总数 36923
×
rossiter
如果觉得我的文章对您有用,请随意打赏。您的支持将鼓励我继续创作!
* 金额(元)
¥1 ¥5 ¥10 ¥20 其他金额
打赏人
留言
* 支付类型
微信扫码支付
打赏金额:
已支付成功
打赏金额: