Monitor Log File

[hirschnf]

Monday morning and such messages...



Great

[harishgupta111]

Hey

Hi Frank,

Hope you are doing g8 !!

Hey I wann confirm something.. actually my problem is:
I have one Explict cursor that is getting some value from Oracle DB. I want to use that with Orabbix. So just wann confirm is it possible to use Explict cursor in Orabbix? Please reply asap. Thanks

[hirschnf]

What do you mean with "explicit cursor"?

[harishgupta111]

This is the Cursor i have in my query.prop file in orabbix.-->

test_cursor.Query= declare
cursor testcursor is
select avgtime, tmptime from testing.testing_event_log where avgtime>100;
testcursordata testcursor%rowtype;
temp_avgtime NUMBER := 0;
begin
open testcursor;
loop
exit when testcursor%NOTFOUND;
fetch testcursor into testcursordata;
temp_avgtime := temp_avgtime + TO_NUMBER(testcursordata.avgtime);
END LOOP;
dbms_output.put_line(temp_avgtime);
CLOSE testcursor;
End;
test_cursor.NoDataFound=none

I have created the item in Zabbix also. But its showing not supported. If I use normal query then it will show the graph. But if i use this code this its showing not supported.

Thanks

[hirschnf]

hmmm, I don't use orabix, so I think I can't help you.

First thing I would check: how can I get the result from this test_curser?
It is command line? Can you check it manually? What is the result?

[harishgupta111]

hi,

yes, I checked it manually it gave me correct result 33

[hirschnf]

so why don't you copy your last item and change your userparameter where the new command will be execute. So you will get the "33" in your item...

[harishgupta111]

Actually this is different from the last one. This item I am getting from Oracle so that's why I am doing this with ORABBIX.

[hirschnf]

ok, as I said, I don't know anything about orabbix...