How to monitor particular column in database?

I have an Oracle Database and I want to monitor a particular table/column in the DB . If the column value crosses threshold value I want to call my java application code to perform some operation like          

"  EXAMPLE SCALE UP OR SHUTDOWN ". How can I achieve this? Thankx in Advance

Views: 39

▶ Reply to This

Replies to This Discussion

Permalink Reply by Niesha Fickett on October 8, 2013 at 5:12pm 
Set Serverout On 
Declare 
comm Varchar2(2000);
 Begin 
comm := OSCommand_Run('/home/jguy/runJavaApp.sh')--for calling commands 
DBMS_OUTPUT.Put_Line(comm); 

End;
Permalink Reply by Lilliam Driskill on October 8, 2013 at 5:13pm

I suggest you to use triggers, they are designed to do stuff like this and I really wouldn't mess up it with Java in this case.

Permalink Reply by Parker Johson on October 8, 2013 at 5:15pm

You can use triggers (i this case an update trigger) that will execute a particular function/stored procedure on certain conditions.

▶ Reply to Discussion

RSS

Oracle Jobs in US

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service