I'm looking for a tool that can watch database(mysql and oracle) for changes.
When someone inserts or updates something in any(or chosen) table i want to get to know about it. It could be very useful for working with others people code that do some magic in database.
I know that it can be done using triggers (see this question), but I'm more interested in some tool that can do it, something free.
Database activity monitoring is done by combining several techniques such as network sniffing, memory scraping and reading system tables and database audit logs. Regardless of the methods used, DAM tools enable data correlation so as to provide an accurate picture of all the activities in the database.
What are database monitoring tools? Database monitoring tools are solutions designed to monitor your database management system. Database monitoring software uses a multi-pronged approach for performance optimization designed to help free time and resources for database admins.
SolarWinds Database Performance Analyzer SolarWinds Database Performance Analyzer (DPA) is a comprehensive, cross-platform tool that can monitor not just Microsoft SQL Server but also Oracle, MySQL, MariaDB, Aurora, DB2 and SAP ASE.
For Oracle, you are looking for the AUDIT command. This one writes audit records to the SYS.AUD$ table, which you can monitor.
More information about the AUDIT statement: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4007.htm#SQLRF01107
and about database auditing: http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/security.htm#sthref2916
Regards, Rob.
Not entirely sure if this is what you're after, but there's JetProfiler for MySQL, which'll let you inspect exactly what's happening on a database, query-wise. I'm quite sure there are equivalents for Oracle...
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With