RE: gv$asm_disk_iostat

Backups going into the FRA ?
Note that that statistics you show would be cumulative, and not for a specific time-window.

Hemant K Chitale

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nabil Jamaleddin Sent: Wednesday, September 09, 2015 11:58 PM To: oracle-l_at_freelists.org
Cc: nmjamaleddin_at_multiservice.com
Subject: gv$asm_disk_iostat

I guess I don't understand gv$asm_disk_iostat with respect to oracle 11.2.0.4

SELECT failgroup, ROUND(SUM(bytes_written / (1024 * 1024 * 1024))) Write FROM gv$asm_disk_iostat
GROUP BY failgroup ORDER BY failgroup;

FAILGROUP WRITE DATA1 1865

DATA2 1927

FRA1 1975

FRA2 1912

UTIL1 4

UTIL2 4

Protection is external (data and fra) so the failgroups are not a mirror.

All my datafiles are in data. Redo log files are on fra with a member (mirror) on data. So it seems to me that the writes to data should be from all the datafiles and from the redo logfiles. Writes to fra are only from redo logfiles. So writes to data - writes to fra = datafile writes. But the writes to fra are larger than data.

What am I missing?

Thanks in advance.....

This email is intended solely for the use of the addressee and may

contain information that is confidential, proprietary, or both.

If you receive this email in error please immediately notify the

sender and delete the email.

This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html

--
http://www.freelists.org/webpage/oracle-l