expdp taking long time on one table
650635Jun 2 2011 — edited Aug 11 2019Hi,
I am trying to use data pump export to get a dump of a schema to copy across to another database. It's been working on one table now for 6 hours, which I think is a problem.
Database is 10.2.0.4.0 on Windows 2003
The table in question has 35,000,000 rows, with an average row length of 586, it takes up 25Gb (3million x 8k blocks).
Looking at the waits, it's always just waiting on db file sequential read on one of the datafiles that holds the data for this table.
I've just started at this company so I don't know much about the data, database structures etc. but in terms of size, number of blocks across datafiles etc. there's a very similar table in the database (it may even be a recent copy, the name is the same but with a _T suffix). If I expdp that table, it completes in under 10 minutes.
Just wondering if anyone has any ideas on what might be wrong, where I can look for the cause of this?
Cheers,
Ados