Database Administration (MOSC)

MOSC Banner

impdp not starting db file sequential read

edited Jan 4, 2024 11:38AM in Database Administration (MOSC) 4 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center