Database Administration (MOSC)

MOSC Banner

Counting of INSERT & UPDATE statement into a table during last one hour

edited Sep 28, 2018 11:01AM in Database Administration (MOSC) 13 commentsAnswered ✓

Being DBA I have to deal with badly written application that generate 1000 of insert statements into a log table followed by 1000 update statement after every insert to update a column and all that happening on clicking of button on web application. Unfortunately correction of code is not possible it has to be re-written from beginning and it will take time.

Before we getting into new dev task, I need to give evidence that how many rows has be inserted and how many updated in last hour. what could be best way?

Kashif

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center