- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle import process
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
тАО10-16-2011 12:06 AM
тАО10-16-2011 12:06 AM
Oracle import process
Hi ,
We are having rx6600 box with 16gb ram , 32gb virtual memory , 4 cpu
oracle 9i . 11iv2 O.S
We are trying to import two tables each with 10 milliion records.
with eva 4k and 20 hdd of 300gb disk and 16 hdd of 146gb disk.
The import process is slow.
solid performance issue i guess.
Can some tuning be done
- Tags:
- Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2011 12:09 AM
тАО10-16-2011 12:09 AM
Re: Oracle import process
PFA disk report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-18-2011 02:54 AM
тАО10-18-2011 02:54 AM
Re: Oracle import process
this is pure IO issue. in sar output, wio value exceed 30%. That show you have IO bottleneck.
12:39:51 %usr %sys %wio %idle
12:39:56 17 13 64 7
12:40:01 28 15 50 7
12:40:06 21 14 59 7
12:40:11 26 13 53 8
12:40:16 22 9 60 9
high IO utilization are coming from these LUNs.
c1t3d7 100.00 0.72 1453 28319 0.18 2.60
c1t3d1 92.80 0.58 620 36535 0.15 7.32
there is no easy way to do this but you need to spread your IO to multiple LUNs. That would ease your IO load.
Creating a stripe volume across multiple LUN is also good at this moment.
//
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2011 10:14 AM
тАО10-25-2011 10:14 AM
Re: Oracle import process
Hi
could you supply some extra information ?
=> Where are the source files located ? (or is it one export file for both tables)
Please specify if one or two files.
=> Is database on same disk as files above ?
Can you move export file elsewhere ?
=> could you supply oracle import parameter files ?
eg. do you rebuild indexes on the fly or have you specified INDEXES=N ?
values for parameters COMMIT, BUFFER, FULL
Regards
Jean-Luc