Oracle I/O activities

[former_member603657]

Hallo Experts,

I found in PowerPoint slide "LGWR_IO" (see in attachment) from SAP Marketplace, it says, REDO_GB/H is high redo generation but i tried to check this parameter in SAP dbacockpit under SAP Performance -> Wait Event Analysis -> IO Activities ("DBACOCKPIT_IO_Oracle" in attachment), but i didn't find it.

Our SAP system has database oracle.

Is there a way to check this parameter for database I/O, i mean in sap system or database or in operating system?

Thanks Gangadhar

[tamil_arasan]

Hi Gangadhar,

Can you please check if you can add a column which shows REDO_GB/H in the result layout from DBACOCKPIT ? or just check this SAP note https://launchpad.support.sap.com/#/notes/1438410 and download the attached scripts from SAP note and try to execute the script from file " IO_RedoLogsPerHour.txt" in DBACOCKPIT/SQLPLUS and check if this gives the required result?

Thanks,

Pradeep