impdp not starting db file sequential read
Oracle 19c (19.20.0.0.0)
Hello,
I face with following issues:
IMPDP and DBMS_STATS procedures hangs
IMPDP is not running. I got message "Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0" and it hangs
At dba_datapump_jobs, job has status "NOT RUNNING"
Following queries is still hanging too
EXEC DBMS_STATS.GATHER_SCHEMA_STATS ('SYS');
exec DBMS_STATS.GATHER_DATABASE_STATS (gather_sys=>TRUE);
v$session contains below events for that:
impdp - db file sequential read
stats - read by other session
In v$sql i'm finding queries that trying get data from tables dba_queue_tables and SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.OBJ$ OI