I have to collect the lgwr process lag overtime. This information is in the lgwr trace file, but I don't want to parse the trace files. Is there any database table or view that stores this information and I can remotely access it using DB connection. It would be great if anyone can provide me with the query.
I need to capture the following information present in lgwr .trc file. "Warning: log write elapsed time 2080ms, size 0KB". I want to capture the this time elapsed.
select * from DBA_HIST_SYSTEM_EVENT
where event_name ='log file parallel write'
should be close to what you want.