Dear Experts,
*1 Node RAC, RDBMS - 11.1.0.7 on RHEL 5*
I'm working on online reorganization of a huge table (1TB) using DBMS_REDEFINITION. It's been running fine over 2 days and is about 85% complete (Based on TOAD, Long ops tab from session browser) before % status disappeared from TOAD and no entry in V$SESSION_LONGOPS. However, I see SID is active and also able to see the current running statement.
SID appears active in v$session and no entry in session longops.
It doesn't sound normal, what could be reason for SID to suddenly disappear from session longops? Below is the current running statement captured from TOAD.. session browser.
From sqlplus, DBMS_REDEFINITION.START_REDEF_TABLE is the procedure running.
Appreciate your help.
/* Formatted on 7/31/2012 11:37:20 PM (QP5 v5.163.1008.3004) */
INSERT /*+ BYPASS_RECURSIVE_CHECK APPEND */
INTO "SCHEMA1"."SCHEMA1_TABLE_ANALYSIS_INT" (
"TABLE_EVAL_ID",
"TABLE_ID",
"TABLE_EVAL_BLK",
"TABLE_EVAL_STA_CD",
"CRE_DTTM",
"PRCS_FLG",
"CRE_USR_ID",
"UPD_DTTM",
"UPD_USR_ID",
"VERS_NUM",
"TABLE_EVAL_PRCS_CD")
SELECT "SCHEMA1_TABLE_ANALYSIS"."TABLE_EVAL_ID",
"SCHEMA1_TABLE_ANALYSIS"."TABLE_ID",
"SCHEMA1_TABLE_ANALYSIS"."TABLE_EVAL_BLK",
"SCHEMA1_TABLE_ANALYSIS"."TABLE_EVAL_STA_CD",
"SCHEMA1_TABLE_ANALYSIS"."CRE_DTTM",
"SCHEMA1_TABLE_ANALYSIS"."PRCS_FLG",
"SCHEMA1_TABLE_ANALYSIS"."CRE_USR_ID",
"SCHEMA1_TABLE_ANALYSIS"."UPD_DTTM",
"SCHEMA1_TABLE_ANALYSIS"."UPD_USR_ID",
"SCHEMA1_TABLE_ANALYSIS"."VERS_NUM",
"SCHEMA1_TABLE_ANALYSIS"."TABLE_EVAL_PRCS_CD"
FROM "SCHEMA1"."SCHEMA1_TABLE_ANALYSIS" "SCHEMA1_TABLE_ANALYSIS"