- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: I/O problem
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-31-2003 02:34 AM
тАО01-31-2003 02:34 AM
I/O problem
There is a serious I/O problem on one of our rp5470 model ( with 2x750 MHz CPU, 4GB memory and HP-UX 11i using VA7100 storage via brocade switch being shared by another 2 hosts ).
During Volume Testing, conversion process runs into two steps, first step is the extraction process from tables into flat files and second process uploads it into database. Extraction takes 10 hrs and upload takes 25 hrs.
Same setup/activity, when performed on HP-UX 11.00 ( with 4 x 440 MHz CPU, 4GB memory connected to FC-60 storage through FC interface.) takes 1 Hr for extraction and 12 Hrs for upload. There is an exponential difference in the performance.
Both the servers have latest OS patches. During the activity I/O is observed with the FS where oracle resides and there is no I/O with any other FS as per glance reports and other tools.
Oracle is properly tuned as the above tests on other server shows. CPU and Memory utilization is normal.
Any comments/suggestions.
Thanks
Venky.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-31-2003 02:45 AM
тАО01-31-2003 02:45 AM
Re: I/O problem
1. How often is the system waiting for IO when processing on the VA? (sar -u)
2. How is the System portion of CPU behaving? (sar -u or glance)
First impressions would be that the System may be spending time waiting for IO, or that it may be rolling in and out Processes from memory (did you reduce the number of Oracle processes for the machine with less CPUs?)
Share and Enjoy! Ian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-31-2003 02:49 AM
тАО01-31-2003 02:49 AM
Re: I/O problem
I think that would be the first thing to try. If that doesnt fix the problem then there must be some serious difference between your 2 HP servers or the db setup. You will need to get into eact details, ora .ini config files, db layout/size, sar stats, glance stats, etc. in order to try to track it down.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-31-2003 03:24 AM
тАО01-31-2003 03:24 AM
Re: I/O problem
who configured VA7100 in the SAN? Are you sure it was done properly?
Gather: 'supportshow' outputs from each brocade, 'armdsp -a' output for VA, zip them with winzip and attach to your next reply
Eugeny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-31-2003 01:56 PM
тАО01-31-2003 01:56 PM
Re: I/O problem
Is glance showing bottlenecks during the process. That can point to the real cause of the problem.
There are options concerning block sizes and such that can have a huge impact on oracle performance. It likes big block sizes.
Do you have adequte resources in that database for memory, rollback space and such?
Are archive logs turned off? They should be for a huge operation like that.
I'd like to see kmtune output to see what the kernel looks like and the init.ora file.
I'm a sabbath obervant Jew so I won't be able to look at anything until Saturday night.
P
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-31-2003 02:14 PM
тАО01-31-2003 02:14 PM
Re: I/O problem
Take a look, they might help.
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x4177ef70e827d711abdc0090277a778c,00.html
I'm real proud of that thread and what I've used has been high quality.
P
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com