Negative impact on Oracle DB after Solaris recommended patching Post: 302808107

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

05-16-2013

Registered User

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.

abhi_8029

View Public Profile for abhi_8029

Find all posts by abhi_8029

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

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.

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...

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...

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...

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 ...

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...

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...

LEARN ABOUT SUNOS

suninstall

suninstall(1M)						  System Administration Commands					    suninstall(1M)

NAME

       suninstall - install the Solaris operating system

SYNOPSIS

       suninstall

DESCRIPTION

       install-solaris(1M) is now the preferred command for starting and restarting the Solaris Installation program. It should be used instead of
       suninstall. suninstall is symbolically linked to install-solaris.

       suninstall is a forms-based and graphical subsystem for installing the operating system.

       suninstall exists only on the Solaris installation media (CD or DVD) and should only be invoked from there. Refer to the Solaris 10 Instal-
       lation Guide: Basic Installations for more details.

       suninstall allows installation of the operating system onto any standalone system. suninstall loads the software available on the installa-
       tion media. Refer to the Solaris 10 Installation Guide: Basic Installations for disk space requirements.

USAGE

       Refer to the Solaris 10 Installation Guide: Basic Installations for more information on the various menus and selections.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcdrom (Solaris  instal-  |
       |			     |lation media)		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       pkginfo(1), install(1M), install-solaris(1M), pkgadd(1M), attributes(5)

       Solaris 10 Installation Guide: Basic Installations

NOTES

       It is advisable to exit suninstall by means of the exit options in the suninstall menus.

SunOS 5.10							    9 Sep 2004							    suninstall(1M)