monitoring/NOCpulsePlugins/Oracle/IdleSessions.pm | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 96ffe1f15c1017f079000fae6c5e10b21729aa40
Author: Milan Zazrivec <mzazrivec(a)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
Show replies by date