- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle exports
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2001 10:22 AM
тАО09-19-2001 10:22 AM
oracle exports
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2001 11:27 AM
тАО09-19-2001 11:27 AM
Re: oracle exports
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-20-2001 12:59 AM
тАО09-20-2001 12:59 AM
Re: oracle exports
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-20-2001 01:08 AM
тАО09-20-2001 01:08 AM
Re: oracle exports
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-20-2001 01:13 AM
тАО09-20-2001 01:13 AM
Re: oracle exports
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2001 01:46 AM
тАО09-27-2001 01:46 AM
Re: oracle exports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2001 03:24 AM
тАО09-27-2001 03:24 AM