Sponsored Content
Operating Systems Solaris Negative impact on Oracle DB after Solaris recommended patching Post 302808429 by jim mcnamara on Thursday 16th of May 2013 05:25:11 PM
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..
 

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
sar(1)							    BSD General Commands Manual 						    sar(1)

NAME
sar -- system activity reporter SYNOPSIS
sar [-dgpu] [-n mode] [-o filename] t [n] sar [-dgpu] [-n mode] [-e time] [-f filename] [-i seconds] [-s time] DESCRIPTION
The sar command is used to sample and report various cumulative statistic counters maintained by the operating system. It can be invoked in two different ways. In the first usage instance, n samples are reported at t second intervals. If n is not specified, only one sample will be captured. When the -o option is specified, sar will write the binary sampling data to the output file specified by filename. In the second usage instance, there is no on-going sample interval to specify. This is because the sampling input comes from a previously recorded, binary activity file. The binary activity file can be specified using the -f filename option. When the -f option isn't used, sar attempts to open a default binary activity file, /var/log/sa/sadd, where dd represents the current day of the month. The starting and ending time of the report can be restricted using the -e and -s options. Here, the time field is specified in the form hh[:mm[:ss]]. Finally, the -i option can be used to select the sampling interval. Only records at least seconds apart will be reported. When the -i option is not used, all of the previously recorded interval samples are reported. Due to the nature of on-going sample collection, the data is reported in a verbose mode when more than one sampling option is specified. Column headers are printed at the beginning of the report and averages are printed when the sar command terminates. OPTIONS
The following options restrict the sample set that sar reports. -d Report disk activity. device The BSD name of the device. r+w/s The number of reads and writes per second. blks/s Number of blocks (in device's default blocksize) transferred to a device per second. -g Report page-out activity. pgout/s The number of pages paged out per second. -p Report page-in and page fault activity pgin/s The number of pages paged in per second. pflts/s The number of faults that caused a page to be copied in per second. vflts/s The number of times vm_fault routine has been called. -n mode Report network activity with modes DEV, EDEV, or PPP. Multiple network modes can be specified. DEV The DEV mode reports network device statistics. The following information is displayed for each interface. IFACE The network interface name. Ipkts/s The number of packets received per second. Ibytes/s The number of bytes received per second. Opkts/s The number of packets sent per second. Obytes/s The number of bytes sent per second. EDEV The EDEV mode reports network device error statistics. The following information is displayed for each interface. IFACE The interface name. Ierrs/s The input errors per second. Oerrs/s The output errors per second. Coll/s The collisions that occurred per second. Drops/s The number of dropped packets per second. PPP The PPP mode must be specified in order to display ppp connections in the network statistics. This will also turn on the PPP modify mode in sadc (8) when sampling data is not being read from a file. By default, both the collection and report- ing of ppp statistics is turned off. See sadc (8). -u Report CPU activity (default) %usr, %sys, and %idle These report the percentage of time running in user mode, system mode and idle. FILES
/var/log/sa/sadd Default daily activity file that holds the binary sampling data. dd are digits that represent the day of the month. SEE ALSO
sa1(8), sa2(8), sadc(8), iostat(8), vm_stat(1), netstat(1), top(1), sc_usage(1), fs_usage(1) Mac OS X Jul 25, 2003 Mac OS X
All times are GMT -4. The time now is 12:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy