Warning: mysql_real_escape_string(): Access denied for user 'www-data'@'localhost' (using password: NO) in /data/www/84/thebonsai.net/wp-content/plugins/statpress/statpress.php on line 1191

Warning: mysql_real_escape_string(): A link to the server could not be established in /data/www/84/thebonsai.net/wp-content/plugins/statpress/statpress.php on line 1191

Warning: mysql_real_escape_string(): Access denied for user 'www-data'@'localhost' (using password: NO) in /data/www/84/thebonsai.net/wp-content/plugins/statpress/statpress.php on line 1194

Warning: mysql_real_escape_string(): A link to the server could not be established in /data/www/84/thebonsai.net/wp-content/plugins/statpress/statpress.php on line 1194

Warning: mysql_real_escape_string(): Access denied for user 'www-data'@'localhost' (using password: NO) in /data/www/84/thebonsai.net/wp-content/plugins/statpress/statpress.php on line 1197

Warning: mysql_real_escape_string(): A link to the server could not be established in /data/www/84/thebonsai.net/wp-content/plugins/statpress/statpress.php on line 1197
Slow datapumping on 10.2.0.4 | TheBonsai's Blog

TheBonsai's Blog

About the days and nights of TheBonsai

Slow datapumping on 10.2.0.4

August 10th, 2010 by TheBonsai

Recently I hacked a on-demand-export for a user. After his (small) data loading, an export is triggered to have his data in a backupable and tranmsportable file. The total amount of all tables was about 7MB only.

The export routines were done with datapump export. I watched a manual run and…

  • datapump started and connected to a database server process: 3 seconds
  • datapump estimated and analyzed the data to export: 36 minutes
  • datapump exported the relevant tables: 4 seconds

Do you see what I see? Yes? Right, datapump played with itself. Over 36 minutes of runtime, where 99% of the time not one bit of data was moved. Reproducable 100%. A datapump TRACE=480300 generated trace set revealed a huge delay in the worker process when calling DBMS_METADATA.FETCH_XML_CLOB (exactly my 36 minutes).

The solution was a patch for bug

  • 7710931: DATAPUMP EXPORT IS EXTREMELY SLOW WHEN EXTRACTING SCHEMA

Now datapump does what it’s designed for: Pumping data without playing with itself!

This entry was posted on Tuesday, August 10th, 2010 at 05:53 and is filed under english, Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply