Database Administration (MOSC)

MOSC Banner

How much data is written to the database by one specific module?

edited Nov 30, 2018 9:49AM in Database Administration (MOSC) 3 commentsAnswered ✓

Hi,

   My customer wants to know how much data is written to the database by one particular module during a given time period. The module may be run by a number of database sessions, perhaps more than one running concurrently, but the sessions can be identified by the contents of the 'module' column in v$session. I have investigated using the contents of 'delta_write_io_bytes' from dba_hist_active_sess_history, but these figures seem far too high (I guess they include data written to undo, redo, etc.). We may have to resort to database auditing, but I wonder whether the information required is already accessible

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