- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Oracle Performance Issue on VMS 7.3-2 and Orac...
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
тАО12-09-2005 07:31 AM
тАО12-09-2005 07:31 AM
Re: Oracle Performance Issue on VMS 7.3-2 and Oracle 9.205
>> Here is the monitor summary report
>> There is very high Interrupt and Kernel percentage during that time.
Just FWIW, without trying to solve your problem perse, IMHO the stats you shared show very reasonable, possible LOW kernel and interupt time.
It suggests that Oracle and friends are doing some 'real' work, like IOs and LOCKs while doing the user stuff. Not unreasonable IMHO.
From a different perspective... if you where to 'tune' the kernel and int stack time entirely away (not that you could), then I don't think your users would notice
the extra idle time much.
However, if you could somehow half the user time, then the box would have a whole cpu idle. So where do want to spend your tuning time and energy?
Dispatchers and shared servers where all the rage 10+ years ago. They nicely save on memory needs and time wasted resolving contention. They may however have outplived theyr use for you. Have you tried without? A direct client to oracle-slave link, or does that create a prohibitive amount of processes on the backend? I suppose that with a 2 CPU system the shared server may be more appropriate then with higher SMP counts.
Just thinking out loud...
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2005 02:49 PM
тАО12-09-2005 02:49 PM
Re: Oracle Performance Issue on VMS 7.3-2 and Oracle 9.205
It's been too long since I was in charge of a busy Oracle database on VMS but the Monitor stats for Processor Mode don't seem to far off for a 100 process load.
What are the figures for your SGA sizes? Have you done the calculations for the various hit counts? Data buffer hit percentage? SQL cursor re-use? Latch waits?
MTS has historically performed horribly on VMS since Oracle 7.3 but supposedly this has been fixed in 9iR2 (9.2.0.3 and up) so I doubt MTS is the problem. You really need to do a good test with STATPACK running and find out what Orable is doing. My guess is that it's the application which is out of tune rather than the VMS system, but until we know what Oracle is doing it's just a guess.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-11-2005 01:59 PM
тАО12-11-2005 01:59 PM
SolutionYour figures look good from a system perspective. The slow user experience looks application related.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-12-2005 06:16 AM
тАО12-12-2005 06:16 AM
Re: Oracle Performance Issue on VMS 7.3-2 and Oracle 9.205
To catch everyone up to what we have done here and more configuration detail
We are running OpenVMS 7.3-2 with TCPIP 5.4 ECo5.
Oracle verison is 9205 with a patch from Oracle that addresses various items with shared server. VMS patches were also loaded. Neither made a difference.
Late on Dec 9 the DBA reduced the number of dispatchers to 2. That improved the response time by 20% !. The compute queue went way down.
attached is a monitor summary of the test with 2 dispatchers, statspak with 10 dispatchers (Nov) and a stats pak with 2 dispatchers as well as a listing of VMS patches loaded.
VMs patches
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2005 03:56 AM
тАО12-23-2005 03:56 AM
Re: Oracle Performance Issue on VMS 7.3-2 and Oracle 9.205
Thanks to all who contributed. Merry Christmas and happy new year
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2005 03:59 AM
тАО12-23-2005 03:59 AM
Re: Oracle Performance Issue on VMS 7.3-2 and Oracle 9.205
- « Previous
-
- 1
- 2
- Next »