- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle IO Problems VA7400 or MOD12H
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
тАО09-19-2002 12:34 PM
тАО09-19-2002 12:34 PM
We are having some IO performance bottlenecks running our Oracle Database on top of Autoraid MOD12H.
We have 2 MOD12H(s) connected to an N Class Server. Every AutoRaid unit has 5 Luns, one unit is dedicated to datafiles and the other unit to indexes. All of this but we still have IO problems.
The vendor is talking us into switching to a VA7400 subsystem. I don't know if this will solve our problems but I surely don't want to spend the money and the time to migrate and find out that we have not done anything.
Has anyone here been in the same situation ? any feedback would be greatly appreciated.
Aziz.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 12:45 PM
тАО09-19-2002 12:45 PM
Re: Oracle IO Problems VA7400 or MOD12H
Ray
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 12:58 PM
тАО09-19-2002 12:58 PM
Re: Oracle IO Problems VA7400 or MOD12H
dbc_max_pct 2
dbc_min_pct 2
How many users are connected to your database on average ?
Thank you for the feedback.
Aziz
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 01:40 PM
тАО09-19-2002 01:40 PM
Re: Oracle IO Problems VA7400 or MOD12H
Now that I've said all this there is a very good chance that nothing hardware or tuning related is going to fix your problem. The vast majority of Oracle performance problems reside in the application's SQL code itself. It is not uncommon for an 10x-20x increase in throughput to result from the addition of a single index. Long before you consider switching hardware take a very close look at the code.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 01:40 PM
тАО09-19-2002 01:40 PM
Re: Oracle IO Problems VA7400 or MOD12H
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 01:44 PM
тАО09-19-2002 01:44 PM
Re: Oracle IO Problems VA7400 or MOD12H
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 01:46 PM
тАО09-19-2002 01:46 PM
Re: Oracle IO Problems VA7400 or MOD12H
Could you please explain the timeslice parameter you mentioned, I would really appreciate it.
Thank you for your comments.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 01:55 PM
тАО09-19-2002 01:55 PM
Re: Oracle IO Problems VA7400 or MOD12H
The best definition of timeslice that I've ever heard was given by Stephen Ciullo. He describes it as "the maximum number of ticks that a process ain't gonna get". What this means is that when timeslice is set to 10, your process will get no more than 10 ticks (9) before voluntarily going to sleep so that other processes
can run. Now it timeslice is set to 1, how many ticks does that allow the process to run?
In this state, the system does context switches and very little else. You will see very strange semaphore behavior and in one extreme case, I actually saw that cursor keys could not be recogized because before the ESC [ C (or whatever) sequence could be processed, the process would sleep and the sequence would be read as three distinct characters because curses could not process the sequence.
Set timeslice to 10 before you do anything else on this box.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 02:08 PM
тАО09-19-2002 02:08 PM
Re: Oracle IO Problems VA7400 or MOD12H
Bear in mind that I have used this system for over 12 months now with these parameters. nothing like what you mentioned above.
Is this responsible for the IO problems I am suffering from when the Oracle databases are heavily accessed ?
Again, I can't thank you enough for the feedback you're providing here.
Aziz.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 02:25 PM
тАО09-19-2002 02:25 PM