Re: oracle sar

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>, "Noor Mulla" <Noor.Mulla@xxxxxx>
  • Date: Tue, 19 Jan 2010 10:45:47 +0100

 

        Some suggestions: 

            man ksh 

            man awk
 On Tue 19/01/10 10:30 , Noor Mulla Noor.Mulla@xxxxxx sent:
        Hi, 
        A program runs and creates a sar output (to track cpu) which has
multiple entries. We should write a program to  to parse the output, 


        send only last 48 hrs of data and email it.... 
        Eg: 
        AIX eqrdb26u1 1 6 00CFD5E34C00    01/13/10 - 01/14/10 
        System configuration: lcpu=8 ent=2.00 mode=Uncapped 

                    %usr    %sys    %wio   %idle   physc   %entc
 13:32:08      25       6       0      69    0.64    31.8
 14:02:08      33       9       1      57    0.86    43.1
 14:32:08      33      10       1      56    0.89    44.7
 15:02:08      27       8       0      65    0.72    36.2
 15:32:08      24       6       0      70    0.61    30.6
 18:32:08      29       8       2      62    0.76    37.8
 19:02:08      45      10       2      43    1.14    57.1
 19:32:08      46      10       1      43    1.16    57.9
 20:02:08      43       9       1      46    1.09    54.3
 09:29:51      41      11       2      46    1.07    53.7
 10:29:51      36      10       1      53    0.94    47.2
 11:29:51      16       6       0      78    0.45    22.5
 12:29:51      25       9       1      66    0.70    34.9
 13:29:51      35      10       2      53    0.93    46.3
 14:29:51      57      10       2      31    1.37    68.6 
        Could any one giveme an idea on this or probably suggest a program. 
        Thanks & Regards 

        Noor M Mulla 

        HCLT - Bangalore 
        DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and
intended for the named recipient(s) only.  It shall not attach any
liability on the originator or HCL or its affiliates. Any views or
opinions presented in  this email are solely those of the author and
may not necessarily reflect the opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and / or publication of  this message
without the prior written consent of the author of this e-mail is
strictly prohibited. If you have  received this email in error please
delete it and notify the sender immediately. Before opening any mail
and  attachments please check them for viruses and defect.
-----------------------------------------------------------------------------------------------------------------------

Other related posts: