Had a long running MLOAD which was running since 7 Hrs. Looked into TD Manager the AMP state was while PE state was .
Used to find the current status of MLOAD, please find below the report generated. The report generated by Query Session is showing State Detail as and MLOAD Phase as . The ETL job completed after after sometime i generated this report.
Have bit confusion as per the report how can the data loading be progress if the parent and child sessions are inactive.
Can any one give me insight on the concurrent occurance of the State Detail and Mload Phase highlighted above.