#!/usr/bin/perl # # Copyright (c) 2001, 2011, Oracle and/or its affiliates. All rights reserved. # # $Id:oracle_sage_consumergroup_metrics.pl # # # NAME # oracle_sage_consumergroup_metrics.pl # # DESC # # NOTES # # MODIFIED (MM/DD/YY) # spalapu 08/28/08 - # spalapu 08/28/08 - # spalapu 08/27/08 - # spalapu 08/27/08 - replace sagemonitor with cellmonitor # spalapu 08/26/08 - # spalapu 08/26/08 - removed sage from plug-in and added exadata. Also, # fixed realm reports to remove targer_guid from realm # reports. Creating new files from oracle_sage_cell # spalapu 07/17/08 - # spalapu 07/17/08 - fix conversion of collectiontime to secs # loliu 06/20/08 - Bug 7191165: Added iormtimestamp. Fixed IO request # timestamp. # spalapu 05/27/08 - split metrics to small and large # spalapu 05/01/08 - Change cumulative value to Cumulative # spalapu 04/25/08 - # spalapu 04/17/08 - Split IO Requests into Small and Large from current # Read and Write # spalapu 04/03/08 - remove unneccesary fields # spalapu 03/28/08 - change ifs to elsifs where possible # spalapu 03/19/08 - Add Copyright statements # spalapu 03/18/08 - # spalapu 03/17/08 - # spalapu 02/13/08 - new file # spalapud 10/07/06 Created the file. # #CONSUMER GROUP METRICS #---------------------- #CG_IO_RQ #CG_IO_WT_RQ #CG_IO_WT # use XML::Parser; use Class::Struct; require emx::oracle_cell::oracle_cell_common; require "emd_common.pl"; our %consumergroups; # Hash of consumergroups $ipaddress=doPing(@ARGV); if($ipaddress eq "") { print "em_error=Failed to ping Cell\n"; exit -1; } my $command = "ssh -l cellmonitor $ipaddress cellcli -xml -e 'list metriccurrent where objectType=".'\"IORM_CONSUMER_GROUP\"'."'"; EMD_PERL_DEBUG("command = $command \n"); my $xmlout = `$command`; my $str; use Data::Dumper; $str = Dumper($xmlout); EMD_PERL_DEBUG($str); my $parser = XML::Parser->new( Handlers => { Start=>\&handle_start, End=>\&handle_end, Char=> \&characterData, }); $str = Dumper($parser); EMD_PERL_DEBUG($str); my $myinf; my $io_requests; my $io_wait_requests; my $io_wait_per_request; $parser->parse( $xmlout); foreach $consumergroup (keys %consumergroups) { # $io_requests = $consumergroups{$consumergroup}{CG_IO_RQ}; # $io_wait_requests = $consumergroups{$consumergroup}{CG_IO_WT}; # print "em_result=".$consumergroups{$consumergroup}{name}."|".$cellname."|".$realmname."|ConsumerGroup*_Statistics|CONSUMER GROUP|".$io_requests."|".$consumergroups{$consumergroup}{CG_IO_RQ_time}."|".$io_wait_requests."|"."\n"; print "em_result=".$consumergroups{$consumergroup}{name}."|".$cellname."|".$realmname."|".$iormtimestamp."|ConsumerGroup*_Statistics|CONSUMER GROUP|".$consumergroups{$consumergroup}{CG_IO_RQ_SM}."|".$consumergroups{$consumergroup}{CG_IO_WT_SM}."|".$consumergroups{$consumergroup}{CG_IO_RQ_LG}."|". $consumergroups{$consumergroup}{CG_IO_WT_LG}."|".$consumergroups{$consumergroup}{CG_IO_RQ_SM_time}."\n"; } #----------------------------------------------------------------- # FUNCTIONS : handle_start # # # DESC : Does node based parsing of the XML output. # # ARGUMENTS : # elements : Node elements in the XML # attrs : Attributes of the elements. # # #----------------------------------------------------------------- sub handle_start { my( $expat, $element, %attrs ) = @_; #Oracle Sage Properties. $myinf=""; if ($element eq "context") { if( %attrs ) { $cellname = $attrs{cell}; $realmname = $attrs{realm}; $iormtimestamp = $attrs{iormResetTimestamp}; $iormtimestamp = $iormtimestamp/1000; } } elsif ($element eq "cli-output") { $myinf="cli-output"; } elsif ($element eq "name") { $myinf="name"; } elsif ($element eq "metricType") { $myinf="metric_type"; } elsif ($element eq "metricValue") { $myinf="metric_value"; } elsif ($element eq "collectionTime") { $myinf="collection_time"; } elsif ($element eq "metricObjectName") { $myinf="object_name"; } else { EMD_PERL_DEBUG("invisible element = $element \n"); } } sub handle_end { my( $expat, $element, %attrs ) = @_; if ($element eq "metric") { if ($realmname eq "") { $realmname="NONE"; } } else { EMD_PERL_DEBUG("find not metric element: $element \n"); } } sub characterData { my( $parseinst, $data ) = @_; $space=" "; $data =~ s/\n//g; if (($data !~ m/^\s/) and ($data ne "\"")) { if ($myinf eq "name" ) { $name=$name.$data; } elsif ($myinf eq "metric_type" ) { $metric_type=$metric_type.$data; } elsif ($myinf eq "metric_value" ) { $metric_value=$metric_value.$data; if ($metric_type eq "Cumulative") { $collection_time = $collection_time/1000; $consumergroups{$object_name}{name} = $object_name; $consumergroups{$object_name}{$name} = $metric_value; $consumergroups{$object_name}{$name."_time"} = $collection_time; } $name=""; $metric_type=""; $metric_value=""; $collection_time=""; $object_name=""; } elsif ($myinf eq "collection_time" ) { $data=$data; $collection_time=$collection_time.$data; } elsif ($myinf eq "object_name" ) { $object_name=$object_name.$data; } } }