Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

expdp taking long time on one table

650635Jun 2 2011 — edited Aug 11 2019
Hi,

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 8 2011
Added on Jun 2 2011
7 comments
4,482 views