topic Re: oracle exports in Operating System - HP-UX

oracle exports

james gould — Wed, 19 Sep 2001 17:22:28 GMT

Oracle exports taking much longer at different
times on server running 11.0. Some days the
process will run in 20 minutes when the export
is run other times it will take 3 hours to run.

Not much is happening on the system at all days. The export will sometimes run from 9%
to 25% when it runs longer.

Re: oracle exports

A. Clay Stephenson — Wed, 19 Sep 2001 18:27:38 GMT

Hi James:

You really don't give us much to go on but I will take a few wild guesses (I will assume that all these exports are the same and not a full vs incremental).

1) Your fast exports may be done soon after most tables have been defragmented.
2) If you are running an AutoRAID, usage patterns have caused most of the tables to be stored in RAID 0/1 rather than RAID 5.
3) More is actually running on your server at times than you think.

You really need to use Glance and/or Measureware to gather performance stats during both the good and bad times and I suspect the problem will become obvious. You can install 30 day Trial version of Glance if you don't already have it.

Re: oracle exports

Andreas D. Skjervold — Thu, 20 Sep 2001 07:59:15 GMT

Hi
Just a tip on how to get the export time reduced:
Use direct path export (DIRECT=Y).
This will speed up your export and your subsequent import of this dump file even more. This due to the fact that Oracle loads data directly into place in the tables (not as sql inserts).
2 things to be aware of is that you can't export LOB or BLOB data, and during import data is placed over the High Watermark in the segment (table). This might require more space in your segments.

Andreas

Re: oracle exports

Volker Borowski — Thu, 20 Sep 2001 08:08:58 GMT

If you say "not much" happens, where does it come from ? Is the application accessing the database running during the export ?
If this is the case, you might have a LOCK problem.
If the application LOCKs a table in exclusive mode, the export will wait until the LOCK is released.
If the user who locks this table is in a meeting, it might take some time.....

Stop the application during the export.

Hope this helps
Volker

Re: oracle exports

Alexander M. Ermes — Thu, 20 Sep 2001 08:13:52 GMT

Hi there.
Some basics :
place the database in dba mode for export / import, so that no user has any influence.

Set the NLS language to American_America.

The direct export / import does not touch the logfiles, that is the reason for the speedup with direct=y.

Did you spread the database file over several disks and controler interfaces ?

Rgds
Alexander M. Ermes

Re: oracle exports

Jayaprakash_1 — Thu, 27 Sep 2001 08:46:26 GMT

the exports time depends on the total no of objects and the total no of rows.suppose during the time of 20 min there must less no of records in the database.pls verify the same.

Re: oracle exports

Carlos Fernandez Riera — Thu, 27 Sep 2001 10:24:01 GMT

See :
http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0xa56b37f45ef7d4118fef0090279cd0f9,00.html