Subroutine for values collected as delta but not from v$sysstat


# Fills the hash %nonstandard_values

 

sub collect_nonstandard_delta_values {
 my $sth2;
 $sth2 = $dbh_client_db->prepare(" select sum(reloads) value from v\$librarycache " );
 $sth2 -> execute;
 my $value = $sth2 -> fetchrow_array;
 $sth2 -> finish;
 $nonstandard_values{'shared pool reloads'} = $value;
$sth2 = $dbh_client_db->prepare(" select request_failures FROM v\$shared_pool_reserved " );
 $sth2 -> execute;
 $value = $sth2 -> fetchrow_array;
 $sth2 -> finish;
 $nonstandard_values{'shared pool failures'} = $value;
}
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: