[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