Databases Reference
In-Depth Information
$asqlid=sprintf "%-10s %-15s", \
"$words[1]", "$words[6]";
$aobj=sprintf "%-10s %-15s", "$words[1]", "$words[8]";
$bytesperop{$as}+=$words[4]/1048576;
$cntperop{$as}++;
$bytespersql{$asqlid}+=$words[4]/1048576;
$cntpersql{$asqlid}++;
$bytesperobj{$aobj}+=$words[4]/1048576;
$cntperobj{$aobj}++;
$tbytes+=$words[4];
}}
## End various arrays to store cellcli output ##
}
## Print output ##
if ($ars > 0) {
$hdr=sprintf "%-10s %-10s", "Cell", "#Requests"; &prtreport(\%cell, $hdr);
$hdr=sprintf "%-10s %-10s", "DB", "#Requests"; &prtreport(\%dbnm, $hdr);
$hdr=sprintf "%-10s %-18s %-25s %-30s %-10s", \
"DB", "ioReason", "ioType", "requestState", "MB";\
&prtreport(\%bytesperop, $hdr); $hdr=sprintf "%-10s %-18s %-25s %-30s %-10s", \
"DB", "ioReason", "ioType", "requestState", "#Requests"; \
&prtreport(\%cntperop, $hdr);
if (defined $options{v}) {
$hdr=sprintf "%-10s %-15s %-10s", "DB", "SqlID", "MB"; &prtreport(\%bytespersql, $hdr);
$hdr=sprintf "%-10s %-15s %-10s", "DB", "SqlID", "#Requests"; &prtreport(\%cntpersql, $hdr);
$hdr=sprintf "%-10s %-15s %-10s", "DB", "Object", "MB"; &prtreport(\%bytesperobj, $hdr);
$hdr=sprintf "%-10s %-15s %-10s", "DB", "Object", "#Requests"; &prtreport(\%cntperobj, $hdr);
}
}
## End Print output ##
[oracle@cm01dbm01 source]$ ./lst13-01-activereq.pl -g ~/cell_group -s
Cell #Requests
------------------------------------------------------------------------------------------
cm01cel01: 123
cm01cel02: 109
cm01cel03: 110
DB #Requests
------------------------------------------------------------------------------------------
EDW 342
DB ioReason ioType requestState MB
------------------------------------------------------------------------------------------------
EDW Null PredicateCacheGet Queued for Predicate Disk 1
EDW Null PredicateCacheGet Queued for Predicate Read 6
EDW Smart scan Predicate Pushing Predicate Computing 208
EDW Smart scan Predicate Pushing Queued for Predicate Disk 77
EDW Smart scan PredicateFilter Queued for Filtered Backup 48
Search WWH ::
Custom Search