[Orca-users] group cascade effect

Regee, Ashish aregee at seic.com
Wed Dec 28 06:34:33 PST 2005


 
There are two groups configured - 
1) statspack 
2) oem. 
 
Statspack and oem groups have mutually exclusive  plot defintions, both groups however show their plots combined with plots defined for the other group 
 
Each group has input files in their respective directories and the group defintions are as shown below. Each database has its own sub-directory (e.g. dgwmppe1.seic.com) under the main group directory. 
 
 
group statspack {
find_files              /apps/orca/var/statspack/(.*)/(?:(?:statspack)|(?:percol))-\d{4}-\d{2}-\d{2}(?:-\d{3,})?(?:\.(?:Z|gz|bz2))?
column_description      first_line
date_source             column_name timestamp
interval                3600
filename_compare        sub {
                          my ($ay, $am, $ad) = $a =~ /-(\d{4})-(\d\d)-(\d\d)/;
                          my ($by, $bm, $bd) = $b =~ /-(\d{4})-(\d\d)-(\d\d)/;
                          if (my $c = (( $ay       <=>  $by) ||
                                       ( $am       <=>  $bm) ||
                                       (($ad >> 3) <=> ($bd >> 3)))) {
                            return 2*$c;
                          }
                          $ad <=> $bd;
                        }
}
 
group oem {
find_files              /apps/orca/var/oem/(.*)/(?:(?:oracle)|(?:percol))-\d{4}-\d{2}-\d{2}(?:-\d{3,})?(?:\.(?:Z|gz|bz2))?
column_description      first_line
date_source             column_name timestamp
interval                3600
filename_compare        sub {
                          my ($ay, $am, $ad) = $a =~ /-(\d{4})-(\d\d)-(\d\d)/;
                          my ($by, $bm, $bd) = $b =~ /-(\d{4})-(\d\d)-(\d\d)/;
                          if (my $c = (( $ay       <=>  $by) ||
                                       ( $am       <=>  $bm) ||
                                       (($ad >> 3) <=> ($bd >> 3)))) {
                            return 2*$c;
                          }
                          $ad <=> $bd;
                        }
}

 
Group statspack files in - /apps/orca/var/oem/dgwmppe1.seic.com
                                     ls -l
                                            oracle-2005-11-05-000
                                            oracle-2005-11-06-000
 
Group statspack files in - /apps/orca/var/statspack/dgwmppe1.seic.com
                                      ls -l
                                             statspack-2005-11-05-000
                                             statspack-2005-11-06-000
 
Is this related  to how find_files is defined?
 
 
 
 
 

	 





More information about the Orca-users mailing list