- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- VMS and Oracle
Operating System - OpenVMS
1753756
Members
5018
Online
108799
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО02-27-2007 08:03 AM
тАО02-27-2007 08:03 AM
VMS and Oracle
Hello,
We are running VMS 8.2 and Oracle 9.2.0.5, I am being told that our application is slow. I have an ES45 4 processor's and 16gb of memory. I will attach the output of monitor mode and disk, show mem/cache. As far as I can tell this system isn't doing anything.
Certain parties are trying to say that my systems aren't tuned or I have disk contention. I was wondering if anyone can give me any pointers on how to monitor a system for Oracle or how to tell if the database is properly tuned.
Thanks Julie
We are running VMS 8.2 and Oracle 9.2.0.5, I am being told that our application is slow. I have an ES45 4 processor's and 16gb of memory. I will attach the output of monitor mode and disk, show mem/cache. As far as I can tell this system isn't doing anything.
Certain parties are trying to say that my systems aren't tuned or I have disk contention. I was wondering if anyone can give me any pointers on how to monitor a system for Oracle or how to tell if the database is properly tuned.
Thanks Julie
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2007 11:02 AM
тАО02-27-2007 11:02 AM
Re: VMS and Oracle
Julie, You do not say how long the Monitor disk was left running for, it looks like a brief snapshot rather than from an extended run, but I would certainly concur that your system appears on the face of this evidence to be doing nothing...
In truth we need a lot more information about your environment before any diagnosis could be given. Where are the consumers of the data in the Oracle database ? Logged into the machine, or elsewhere on your intranet ? If the latter, the entire problem could be external to VMS.
Should the need arise, there are a number of contributors to this forum who can offer expert paid consultancy. Unfortunately, I am the wrong side of 'the pond' to help more than a reply here.
JT:
In truth we need a lot more information about your environment before any diagnosis could be given. Where are the consumers of the data in the Oracle database ? Logged into the machine, or elsewhere on your intranet ? If the latter, the entire problem could be external to VMS.
Should the need arise, there are a number of contributors to this forum who can offer expert paid consultancy. Unfortunately, I am the wrong side of 'the pond' to help more than a reply here.
JT:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2007 11:34 AM
тАО02-27-2007 11:34 AM
Re: VMS and Oracle
Hello and welcome to ITRC.
Fire up MONITOR and run a recording pass over a week or two. You might want to restart the job on a daily basis, but you get the idea, I'd run MONITOR ALL set to record data to a file at intervals of, say, five or ten minutes. This is your baseline performance collection. The interval is fairly long to avoid accumulating stonking huge wads of data.
I'd prepare a second MONITOR command (with recording) with a much shorter interval (say fifteen seconds) and have this ready to go upon the arrival of a verifiable performance complaint. This to capture the specific interval. This can accumulate said stonking huge files, so mind your disk space and how long you run this.
If you should have available disk storage to burn, have at.
Next wander over to the HP OpenVMS site and rummage around for a copy of the T4 tool. This will help you analyze the MONITOR data.
And poke around inside Oracle itself, and set that up for performance monitoring as best you can manage. Statspack or its analog, if you can manage it.
With Oracle and MONITOR, you're typically looking at the MODES activity first, and specifically exec-mode activity.
As for Statpack, that's Oracle DBA-land. But with the MONITOR data, you can show that OpenVMS is or is not busy when the performance degrades.
The disk queue length, FWIW, should be 0.5 or less and preferably less. A sustained value of 0.5 indicates half of all disk I/O is waiting for a previous I/O; that there's either an overload or an under-bandwidth lurking in the disk path. There are spikes in disk activity likely on most any system, and it really boils down to what the I/O looks like, what memory caching can be enabled, etc., and your tolerance for throughput.
For grins and giggles, also look at system parameter settings, and ensure these meet Oracle requirements, and ensure that the process quotas for the usernames also match, etc. Also take a look at using the AUTOGEN with FEEDBACK over a week or a month, to better dial in the parameter settings.
What was provided for information from MONITOR looked to be a near-quiescent system. This implies that the abominable performance monster wandered past when the camera wasn't recording, or it's not these particular monitored areas of OpenVMS that are feeding the monster.
If you wish to investigate how HP indicates a system performance and tuning operation can be conducted for OpenVMS, there's the performance management manual in the OpenVMS documentation set.
Stephen Hoffman
HoffmanLabs
Fire up MONITOR and run a recording pass over a week or two. You might want to restart the job on a daily basis, but you get the idea, I'd run MONITOR ALL set to record data to a file at intervals of, say, five or ten minutes. This is your baseline performance collection. The interval is fairly long to avoid accumulating stonking huge wads of data.
I'd prepare a second MONITOR command (with recording) with a much shorter interval (say fifteen seconds) and have this ready to go upon the arrival of a verifiable performance complaint. This to capture the specific interval. This can accumulate said stonking huge files, so mind your disk space and how long you run this.
If you should have available disk storage to burn, have at.
Next wander over to the HP OpenVMS site and rummage around for a copy of the T4 tool. This will help you analyze the MONITOR data.
And poke around inside Oracle itself, and set that up for performance monitoring as best you can manage. Statspack or its analog, if you can manage it.
With Oracle and MONITOR, you're typically looking at the MODES activity first, and specifically exec-mode activity.
As for Statpack, that's Oracle DBA-land. But with the MONITOR data, you can show that OpenVMS is or is not busy when the performance degrades.
The disk queue length, FWIW, should be 0.5 or less and preferably less. A sustained value of 0.5 indicates half of all disk I/O is waiting for a previous I/O; that there's either an overload or an under-bandwidth lurking in the disk path. There are spikes in disk activity likely on most any system, and it really boils down to what the I/O looks like, what memory caching can be enabled, etc., and your tolerance for throughput.
For grins and giggles, also look at system parameter settings, and ensure these meet Oracle requirements, and ensure that the process quotas for the usernames also match, etc. Also take a look at using the AUTOGEN with FEEDBACK over a week or a month, to better dial in the parameter settings.
What was provided for information from MONITOR looked to be a near-quiescent system. This implies that the abominable performance monster wandered past when the camera wasn't recording, or it's not these particular monitored areas of OpenVMS that are feeding the monster.
If you wish to investigate how HP indicates a system performance and tuning operation can be conducted for OpenVMS, there's the performance management manual in the OpenVMS documentation set.
Stephen Hoffman
HoffmanLabs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2007 01:08 PM
тАО02-27-2007 01:08 PM
Re: VMS and Oracle
Hi,
Oracle is very reliant upon UNDO and REDO logs. These are very write intensive files and should be moved to spindles and busess away from the data.
Indexes are also a problem, left on for mass updates slows things down and not on for lookups slows it up as well. Maybe someone left an index off - this has happened to us in the past and is a usual suspect.
Robert.
Oracle is very reliant upon UNDO and REDO logs. These are very write intensive files and should be moved to spindles and busess away from the data.
Indexes are also a problem, left on for mass updates slows things down and not on for lookups slows it up as well. Maybe someone left an index off - this has happened to us in the past and is a usual suspect.
Robert.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP