Sponsored Content
Operating Systems Solaris Negative impact on Oracle DB after Solaris recommended patching Post 302808107 by abhi_8029 on Thursday 16th of May 2013 01:24:44 AM
Old 05-16-2013
Negative impact on Oracle DB after Solaris recommended patching

Dear All,

We are facing some performance problems in our oracle DB qerries and reports recently. We applied Solaris 10 recommended patchset on april 24th. Our monthly report generation acitivity ran 3 days i.e may 11,12,13 and application team complained of degraded performance. I can see that the cpu usage on the server is about 100% during the report generation , but everything else is fine. Free memory is 15gb , all mountpoints are under 80% and there is no other hardware issue as well.
Now app team is suspecting that last month patching could be the cause of the problem, because till last month they were performing this activity without having a performance degradtion.

I just need to be sure that solaris 10 recommended patches are not causing this issue. Any of you ever faced such an issue after patch installation ?
The server is V490 with 8 cpu / 32gb RAM. Any hints will be appreciated ?

Thanks in Advance.
 

8 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

upgrade to solaris 9 - mysql impact

I have 4 solaris 8 servers running mysql 5.0.22. I am considering upgrading to solaris 9 and wanted to know if mysql needs to be recompiled for mysql to run under solaris 9. Thank you (4 Replies)
Discussion started by: csgonan
4 Replies

2. Solaris

impact of upgrading the SOLARIS OS from 5.6to 5.8

Please give me some idea about the impact of upgrading the SOLARIS OS from 5.6 to 5.8. We are using object store database of version 5.1. will there be any impact on this. Please help me in this regard. Thanks in advance. (1 Reply)
Discussion started by: vamshikrishnab
1 Replies

3. Solaris

Solaris 10 Recommended Patches

Does anyone get the following error message below when trying to download solaris 10 recommended patch? End-of-central-directory signature not found. Either this file is not a zipfile, or it constitutes one disk of a multi-part archive. In the latter case the central directory and... (8 Replies)
Discussion started by: Sarccastik Dude
8 Replies

4. Solaris

Solaris Trunking and its impact on VCS cluster and others

Hello guys, I have a question regarding link aggregation / trunking in Solaris 9 Sun Trunking does not come by default in Solaris 9 unlike Solaris 10 where we can use the "dladm" command to trunk 4 physical NIC interfaces together. My question is in Solaris 9. Will the configurations of... (1 Reply)
Discussion started by: br1an
1 Replies

5. Solaris

Recommended patchset for Solaris and the patch bundle

Hello I recently downloaded and installed the latest patchset for Solaris 10 (update 5) running on SPARC. Actually I am new to Solaris (I come from Red Hat) and the security department asked me to update the system for security fixes. I logged in to Oracle support and used the recommended patch... (3 Replies)
Discussion started by: abohmeed
3 Replies

6. Solaris

Oracle stopped updating Solaris 10 recommended patch cluster ?

Dear All, Has Oracle stopped updating Solaris 10 recommended patch cluster ? From suport.oracle.com i could see the last patch bundle was released on 11th july and there has been no updates after that. Does anyone know about any official announcement from oracle on this ? Thanks ... (1 Reply)
Discussion started by: abhi_8029
1 Replies

7. Solaris

Patching Procedure in Solaris 10 with sun cluster having Solaris zone

Hi Gurus I am not able to find the patching procedure for solaris 10 ( sol10 u11) to latest patchset with sun cluster having failover zones so that same I should follow. Take an instance, there are sol1 and sol2 nodes and having two failover zones like sozone1-rg and sozone2-rg and currently... (1 Reply)
Discussion started by: nick101
1 Replies

8. Solaris

No New Solaris 10 Recommended cluster in a few months

Hi Guys, I'm looking to download the latest patche cluster, we install them on a monthly basis. I have not seen anything released in the last couple months since January. Did I miss an announcement? Are they going to start releasing quarterly? Or is it just so happening there are no... (2 Replies)
Discussion started by: BG_JrAdmin
2 Replies
LONGRUN(1)						      General Commands Manual							LONGRUN(1)

NAME
Transmeta(TM) Crusoe(TM) LongRun(TM) utility SYNOPSIS
longrun [-c device] [-m device] [-hlpv] [-f flag] [-s low high] DESCRIPTION
The longrun utility is used to control and query LongRun settings on Transmeta Crusoe processors. -c device Set the CPUID device. The default CPUID device is /dev/cpu/0/cpuid. -m device Set the MSR device. The default CPUID device is /dev/cpu/0/msr. -h Print help. -l List LongRun information about available performance levels for the CPU. The following values are reported on all Transmeta CPUs that implement LongRun. % An available performance level, expressed as a percentage of range of available core CPU frequencies. 0 corresponds to the lowest available frequency and 100 corresponds to the highest. MHz The core CPU frequency at that level. Volts The core CPU voltage at that level. usage The power usage relative to the maximum performance level. -p Print current LongRun settings and status: whether LongRun is enabled, whether LongRun Thermal Extensions are active, the current LongRun performance window (expressed as a percentile range), the current LongRun performance level (expressed as a percentile), and the current LongRun flags. -v Be more verbose. -f flag Set a LongRun mode flag. Currently, the two supported flags are performance and economy. This controls whether the processor is in "performance mode" or "economy mode". -s low high Set the current LongRun performance window as a percentile range. The low number cannot be greater than the high number. The minimum and maximum performance values accepted by the CPU are 0 and 100, respectively. ENVIRONMENT
No environment variables are used. FILES
This program requires that the Linux CPUID and MSR devices be compiled into the kernel (or loaded as kernel modules), that the CPUID character device be readable, and that the MSR character device be both readable and writable. SEE ALSO
acpid(8), apmd(8), hdparm(8) AUTHOR
Daniel Quinlan <quinlan@transmeta.com> February 14, 2001 LONGRUN(1)
All times are GMT -4. The time now is 10:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy