- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Importing Data to oracle
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
тАО01-24-2005 08:32 AM
тАО01-24-2005 08:32 AM
Importing Data to oracle
I recently installed Oracle RAC 10g without serviceguard.How long does it take to import 5 GB of data with about 40 milion records to new installed rac database.
in my test it took about 5 hours.Is it usual?
I think something is wrong.what is your idea?
Regards,
Alireza
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2005 08:39 AM
тАО01-24-2005 08:39 AM
Re: Importing Data to oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2005 08:42 AM
тАО01-24-2005 08:42 AM
Re: Importing Data to oracle
If your VA7110 is set up raid 5 you can improve write performance by going with raid 1 or raid 1/0.
Oracle recommends raid 1 or 1/0 (commonly called 10) for data and redo. Other areas can be raid 5.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2005 08:46 AM
тАО01-24-2005 08:46 AM
Re: Importing Data to oracle
Without more data, it's not possible to tell if this is good or bad. If you do have many indices, you might find it more efficient to import with only a primary index and then add the other indices later.
You could also have severe i/o or memory bottlenecks or a very, very badly tuned database and/or OS. You just don't provide information.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2005 09:15 AM
тАО01-24-2005 09:15 AM
Re: Importing Data to oracle
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2005 03:15 PM
тАО01-24-2005 03:15 PM
Re: Importing Data to oracle
Import is a big sequential process and to speed that, you may do the following:
a. Make sure your alert log doesn't have any "checkpoint not complete" or "archival required" messages. These messages indicates that you have insufficient log configured and you should add more.
b. Verify you SORT_AREA_SIZE for index builds, you should consider increasing it during the import.
c. Do everything in parallel. Don't just use a simple exp owner=, imp owner=. Export table by table (in parallel, just fire off several exports). Same applicable for Import.
d. Pre-create your indexes. Don't use import to create the indexes -- use imp ... indexfile=temp.sql to generate a script with the create indexes. Then, modify them to have nologging and parallel. Running them in sqlplus is much faster.
hope this helps!
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2005 07:27 PM
тАО01-24-2005 07:27 PM
Re: Importing Data to oracle
It takes me about 1 hour to import about 1.1Gb of data into a database on an intel 1GHz (x2) Xeon with 1GB RAM.
John.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-14-2005 04:44 AM
тАО02-14-2005 04:44 AM