I'm looking for some HP-UX platform advise.
A customer has a 110GB database running on 126.96.36.199 on HP-UX, Itanium Superdomes. We are trying to convert this into SQL Server and it's taking a very long time. However there is a bit of a history. For years the customer has issues performing exports. While we can process that database in around an hour, it takes 10-15 hours to perform an export from their production system with minimal load on it.
Now, during the SQL Server conversion, we have a similar situation. We can convert the database with several combinations (Source Oracle on Windows, Oracle on Linux, on a Desktop, a Server, SAN, local SATA disks to any SQL Server basically) in 6 hours on rather old development servers. A test performed onsite this last weekend needed over 22 hours. After looking through the log files I found that all tables without LOB's only take half the time compared to our tests, but the LOB tables take forever. For example a package transferring over 20 million records takes 30 minutes, but half a million images take 7 hours.
Now I don't have proof, but I think the export issues and the unloading of LOB's have the same cause. As mentioned I tested several source databases with more or less CPU and SGA and have no issue and also can't find anything platform specific on Oracle Support.
Is there anyone out there running by chance HP-UX Itaniums and could give me a hint that there is something wrong on that particular platform, some setting we may need?
Thanks in advance.
Thanks for the link, but unfortunately they don't help much. We thought about a network issues, but that has been ruled out by engineers.
DB Console shows constant 90% User I/O which should point to something, if there wouldn't be the SAN guys which say nothing is wrong with it.
Something weird is going on with that particular Oracle setup.
It would be interesting if you copied the database to another platform, and then ran your exports again. Your theory would have all the more credence if the test server was "smaller" and the export was quicker. You'd have to keep load considerations in mind... but if you can do the export at a time of minimal load (perhaps you did just that when you did the weekend export) it shouldn't skew things too much.
Have you opened an SR with Oracle?
Edited by: Justin Mungal on Mar 26, 2013 9:21 PM