monitoring/NOCpulsePlugins/Oracle/IdleSessions.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
New commits: commit 96ffe1f15c1017f079000fae6c5e10b21729aa40 Author: Milan Zazrivec mzazrivec@redhat.com Date: Mon Apr 2 12:06:47 2012 +0200
518985 - fix ORA-00918: column ambiguously defined
diff --git a/monitoring/NOCpulsePlugins/Oracle/IdleSessions.pm b/monitoring/NOCpulsePlugins/Oracle/IdleSessions.pm index 81bbf9f..54b8900 100644 --- a/monitoring/NOCpulsePlugins/Oracle/IdleSessions.pm +++ b/monitoring/NOCpulsePlugins/Oracle/IdleSessions.pm @@ -17,7 +17,7 @@ sub run {
my $row = $ora->fetch_first(q{select count(*) as COUNT from v$session_wait a, v$session b - where event = 'SQL*Net message from client' + where a.event = 'SQL*Net message from client' and a.seconds_in_wait >= ? and a.sid = b.sid and b.username is not null
spacewalk-commits@lists.fedorahosted.org