查看执行计划

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";

 

转载于:https://my.oschina.net/rossiter/blog/699219