Negative impact on Oracle DB after Solaris recommended patching


 
Thread Tools Search this Thread
Operating Systems Solaris Negative impact on Oracle DB after Solaris recommended patching
# 1  
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.
# 2  
Old 05-16-2013
You will have to either log a call to oracle support - be prepared with lots of logs, you will probably be asked to run explorer as well.

Or you can try searching by patch number on the OTN for known issues.

Has your DBA done a THROROUGH alert log check?

And, of course the DBA's have pushed no schema changes, there were zero production code changes.

If that fails startup sa (sar) sar monitoring to get a baseline. Keep 30 days worth of data. Then on month end start comparing daily sar output against what you get during month-end.

Last edited by jim mcnamara; 05-16-2013 at 06:30 PM..
# 3  
Old 05-17-2013
Check Ulimit and Kernel parameters

you may have something that reset your kernel parameters in /etc/system. I would look to ensure those have not changed as well
# 4  
Old 05-22-2013
Hi os2mac,

nothing has changed in kernel parameters in /etc/system

Hi jim,
our DBA has logged call with Oracle and also shared the patches we applied last month to get a response from them. Lets wait and see what oracle has to say on this.

After checking logs, DBA could only confirm that there is very high Logical I/O activity. There is no wait I/O on the system and DBA also confirmed physical I/O is negligible from his logs.

Could it be that the high logical I/O is caused by some application defect ? Also we have lot of memory available on the system which is not used by oracle. Shall i ask DBA to increase SGA to include the free memory ? Will it help reduce the logical I/O. Any comments will be appreciated.
# 5  
Old 05-22-2013
Quote:
Originally Posted by abhi_8029
Hi os2mac,

nothing has changed in kernel parameters in /etc/system

Hi jim,
our DBA has logged call with Oracle and also shared the patches we applied last month to get a response from them. Lets wait and see what oracle has to say on this.

After checking logs, DBA could only confirm that there is very high Logical I/O activity. There is no wait I/O on the system and DBA also confirmed physical I/O is negligible from his logs.

Could it be that the high logical I/O is caused by some application defect ? Also we have lot of memory available on the system which is not used by oracle. Shall i ask DBA to increase SGA to include the free memory ? Will it help reduce the logical I/O. Any comments will be appreciated.
If you are running a modern version of the Oracle DB then you can use and AWR report to determine if the DB needs more ram allocated.
# 6  
Old 05-22-2013
Tools like Toad and Spotlight are great for locating performance issues
# 7  
Old 05-22-2013
Check with
vmstat 3
how CPU distributes on system and user, and with
prstat
how user CPU distributes on processes.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

8. 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
Login or Register to Ask a Question