Manage

Slow performance when exporting referential integrity constraints

Published: 30 Dec 2003

We have a database of 300 MB on P-4 Intel machine with 1 GB RAM. Previously, every evening when I used to take export it would finish in 15-20 mins. But for the last couple of months, it exports the users tables at the same speed it used to do, but it hangs -- it takes a lot of time to export referenitial integrity constraints when all the user tables are exported and it exports views, dimensions, etc. My user tables are exported within 15-20 mins but exporting referential integrity constraints takes around one hour. Can you help?
You didn't mention what kind of export you are doing. Are you doing a user by user export or is this a full export? Are there partitioned tables involved? Are you doing the export while users are on the system? Have you tried exporting without constraints and then doing a separate export of just the constraints (i.e. no table data, etc)? Also check your OPTIMIZER_MODE paramter. At one time there was a MetaLink note about slowness on exports if OPTIMIZER_MODE = FIRST_ROWS. Another thing to check is to make sure your statistics are current. Having "bad" statistics may also be a problem.

Dig Deeper on Oracle database performance problems and tuning

Restoring to a backup instance on a backup server for a disaster recovery plan In this Oracle database and backup recovery tip, expert Brian Peasland helps a reader restore a backup instance on a backup server in order to develop a disaster recovery plan.

Importing tables with integrity constraints An Oracle user asks why they are receiving errors when importing a table with integrity constraints.

Can I change the import order of tables in a dump file? A SearchOracle.com member asks, "Can I change the order in which a table gets imported in a dump file?"

ABAP for newbies: How to dynamically create test data for our database table With the new build of the SAP NetWeaver 2004s ABAP trial version (SP11), you may need to update your ABAP developer skills (beginners and experienced) to understand the new version. By the end of this tip series, you should have a good understanding of what's going on in the ABAP application server. In part 14, Thomas Weiss shows us how to dynamically create test data for our database table.

"Not a valid month" error I am trying to perform a partial export of a table. Every day, I want to export just the rows created yesterday. I am using a PL/SQL shell script and executing code in a par file. I get an error: "ORA-01843: not a valid month."

Importing table structure only to new schema How do I import the table structure only to another schema with a different tablespace for data, as well as for constraints?

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Slow performance when exporting referential integrity constraints

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

SearchSAP

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SearchSQLServer

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

TheServerSide.com

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

SearchDataCenter

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

SearchContentManagement

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

SearchHRSoftware

IT's technology experience problem gets HR tool

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.