- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- how to spped up import?
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
тАО04-27-2002 01:39 AM
тАО04-27-2002 01:39 AM
how to spped up import?
We have to migarate a oracle databaser from dec box( oracle7.3.4 )to 2 hp box ( oracle 8.1.7 ops n4000, 12G mem), importing the 50G exportfile took about 10 hr. how to speed up import?
the redo log is 100M , rollback is 400M. is using ops import help?
I attched th init file .
Thanks
Sunny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2002 03:25 AM
тАО04-27-2002 03:25 AM
Re: how to spped up import?
You are doing a little more than migrating, you are converting, and depending upon which DEC box you have and which DEC OS you are using, you could be UN-"BYTE SWAPPING".
Oracle is a pig, it's just something we have to live with, and every year, with evry release, it's only going to get worse.
5GB an hour isn't really bad, but I agree it should be better. On the HP side, make sure you have done all of the performance tuning.
One thing you left out, is HOW you are getting the DATA (exportfile) from the DEC over to the HP. And how long was this process?
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2002 06:19 PM
тАО04-27-2002 06:19 PM
Re: how to spped up import?
geting the 50G file from dec to hp took 1.5 hr.
Thanks
Sunny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2002 09:03 PM
тАО04-28-2002 09:03 PM
Re: how to spped up import?
You might want to consider to run the import with INDEXES=N and build the indexes afterwards. That way you'll definitely speed up the import (and your indexes will be a lot "cleaner" afterwards).
Hope this helps,
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2002 09:50 PM
тАО04-28-2002 09:50 PM
Re: how to spped up import?
Some more hints :
- do a no-rows export for getting the structure of the database only
- run this as an import on the new database without creating indexes
- import the data without creating indexes
while running this import you should permanently keep compiling invalid objects, because your import might get stuck if you don't. You can do this by running the scripts through cron. There are scripts available like compile.sh or so from Oracle Support.
- run a now-rows import of the data after that.
this will create missing objects and build up the indexes.
Hope i could help.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2002 01:30 AM
тАО04-29-2002 01:30 AM
Re: how to spped up import?
The recipee is more complicated in detail. To really do it right you need to do some raw editing of the dry dump (rows=n) to create all objects minus indices and constraints ahead of import. After data import use the same dry dump to import indices and constraints.
I let all tablespaces grow naturally starting with a reasonably small size and autoextending by reasonable increments. Same for tables and indices. A dump gives you a good overview of how much space the database really needs. In the end the new DB was less than 30 GB and ran significantly better than the original.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2002 02:33 AM
тАО04-29-2002 02:33 AM
Re: how to spped up import?
On your 8.1.7 you can alter all tablespaces as no loggin.
import with rows=n indexes=n;
run an export with rows=n indexes=yes.
run imp indexfile=yes
split this indexfile.sql in some files and then you can run all them at a time. You alse can add unrecoverable to each create index.
While running sqls for create index set the multi_read_count=32 in init.ora.
Just ideas.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2002 12:04 PM
тАО04-29-2002 12:04 PM
Re: how to spped up import?
This will help you sort in memory instead of using the database TEMP space on disk. Make sure to reset this sort_area_size when the import completes, or each user will grab this amount when sorts are required.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2002 12:23 PM
тАО04-29-2002 12:23 PM
Re: how to spped up import?
Sandip
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2002 12:59 PM
тАО04-29-2002 12:59 PM
Re: how to spped up import?
Also check the nslookup takes how much time to resolve DEC machines name on your HP box. Normally nfs mounting transfers take more time.
I will suggest you to transfer Oracle database through ftp, it will be very fast. I have done that thing few days back and transfered 2GB file within 5 minutes.
Hopethis helps.
-pap