crt oracle查看执行计划,查看执行计划 - rossiter的个人空间 - OSCHINA - 中文开源技术交流社区...

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