- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Migration of Oracle 7.3.4 database under HPUX ...
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
тАО11-06-2000 07:26 AM
тАО11-06-2000 07:26 AM
Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2000 08:13 AM
тАО11-08-2000 08:13 AM
Re: Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
We have upgrade from 7.3.4 to Oracel 8.0.5.2.2, under 10.20 and have found no problems. Can you give some more information with regards to what you are experiencing? I am assuming that you are refering to SQL_LOADER in your initial statement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2000 08:29 AM
тАО11-08-2000 08:29 AM
Re: Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2000 08:57 AM
тАО11-08-2000 08:57 AM
Re: Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
We are not upgrading to Oracle 8.0.5, but going to 8.0.6. This is on a K-class machine by HP. We currently have 8.0.6 running on a smaller K-class machine with only 2 cpu's compared to the larger one with 6 cpu's. We get slow response on the smaller K-class machine due to memory constraints. But on the larger one, which we expected to see some improvements, we got none. We have also tried splitting the database off onto another even larger machine (N-class), and we still have the performance problems. Thanks for your offer to help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2000 09:10 AM
тАО11-08-2000 09:10 AM
Re: Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
I forwarded your attached notes to our DBA's. I believe for the most part that they have reviewed these things....I think that somewhere we have a pointer that is pointing to the wrong Oracle Home directory or something like that that may be causing the access to the database problems. They just bought Quest monitoring tools, but I don't know how helpful that has been. Do you have a suggestion for some monitoring tools that may give us better insight as to the performance degradation? Thanks for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2000 09:15 AM
тАО11-08-2000 09:15 AM
Re: Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
I wasn't referring to SQL_Loader, in my ignorance of these things, it may be using it in the application. I am guessing that the database access is having trouble because it uses a version of SQLPLUS to access it. As far as technical knowledge of these things, I have none...our DBA's are struggling to find out why we are having these problems. We have taken benchmarks on our smaller machine on 7.3.4 and 8.0.6 and very little difference shows up in our load to the database. However, when we did it on the larger machine, 7.3.4 zips right along, and 8.0.6 loads at a snails pace. We think it may be pointing to the wrong version of Oracle or SQL.
Thanks for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2000 09:45 AM
тАО11-08-2000 09:45 AM
Re: Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
We have not seen any performance degredation to date (K580 6CPU systems). I will pass this on to our DBA, though, and post again if we see any similar issues.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2000 09:59 AM
тАО11-08-2000 09:59 AM
Re: Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
Second thing - are there a lot of batch jobs running in the database? Going to a box with more CPUs is not a guarantee that the database will respond better to users. In fact batch jobs may be running so well, that they are causing a I/O bottleneck, that will make the system slower than it was before.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2000 10:00 AM
тАО11-08-2000 10:00 AM
Re: Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
Second thing - are there a lot of batch jobs running in the database? Going to a box with more CPUs is not a guarantee that the database will respond better to users. In fact batch jobs may be running so well, that they are causing a I/O bottleneck, that will make the system slower than it was before.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2000 10:01 AM
тАО11-08-2000 10:01 AM
Re: Migration of Oracle 7.3.4 database under HPUX 10.2 to Oracle 8.0.6 database.
Second thing - are there a lot of batch jobs running in the database? Going to a box with more CPUs is not a guarantee that the database will respond better to users. In fact batch jobs may be running so well, that they are causing a I/O bottleneck, that will make the system slower than it was before.