Database Utilities (MOSC)

MOSC Banner

Export Backup is taking time

edited Oct 8, 2009 12:47AM in Database Utilities (MOSC) 5 commentsAnswered
Dear All,

We are using oracle on Solaris 10 and oracle version 10Gr2. As on date database size is 31G and export backup size is 5.7G but to complete export backup it is taking 70min time. Database is having only one schema and during export maximum 10/15 users used connected to the database through application. Database is having some  table containing LOB data and currently we are using the following script to perform export backup -

exp system@<host string> file=<dump file path> log=<log file path> owner=<user name> buffer=200000000 

need your suggestion how to perform export backup in quicker time.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center