data read and written to DB by a SAP job

[Former Member]

Hi,

I wanted to find if there is a way of finding out how much data is read and written from the database in SAP/Oracle. I have asked a number of people but many don't know how this can be found out. Does anyone know how this is posible, just needed to make some amendments to an SAP system for testing purposes.

Thanks,

Mani

[stefan_koehler]

Hello Mani,

>> I wanted to find if there is a way of finding out how much data is read and written from the database in SAP/Oracle

Of course there are some possibilities.. take a look at ST03n

ST03n => Workload => Total => Select a Timeframe

After that take a look at the point "DB Connection Statistics" .. there is anything you need .. reads, changes and block statistics.

If you want that on object/transaction level take a look at Table Access Statistics.

Regards

Stefan