RE: Reads from Control file under "IOStat by Filetype summary"
- From: John Hallas <John.Hallas@xxxxxxxxxxxxxxxxxx>
- To: "'vijaysehgal21@xxxxxxxxx'" <vijaysehgal21@xxxxxxxxx>, "coskan@xxxxxxxxx" <coskan@xxxxxxxxx>
- Date: Thu, 5 Jun 2014 11:44:51 +0100
Frankly Vijay why not use the DBA team at your company who are paid to be more
knowledgeable in this area than you need to be.
I would not be that impressed if one of my users posted AWR data out to the
world requesting advice on it without first consulting the internal SME team
John
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of vijay sehgal
Sent: 29 May 2014 13:46
To: coskan@xxxxxxxxx
Cc: timur.akhmadeev@xxxxxxxxx; ORACLE-L
Subject: Re: Reads from Control file under "IOStat by Filetype summary"
Dear All,
Thanks a lot for your inputs.
1. I have requested the DBA team to provide me queries that had wait events
"control file sequential read", "db file scattered read" and "direct path read"
2. As Jonathan hinted, the "archive_lag_target" is set to 5 minutes.
3. I have also requested the team to share if any monitoring scripts are being
executed against the database.
While I wait for the inputs, I have 1 more question. How to derive balance
value for "arhive_lag_target" parameter. For this particular scenario the
environment has dataguard configured.
Warm Regards,
Vijay Sehgal.
______________________________________________________________________
Wm Morrison Supermarkets Plc is registered in England with number 358949. The
registered office of the company is situated at Gain Lane, Bradford, West
Yorkshire BD3 7DL. This email and any attachments are intended for the
addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to
the email that you have received in error and then destroy the email.
If you are not the intended recipient, you must not use, disclose, copy or rely
on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the
Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to
time, apply to any contract that we enter into. The current version of our
Standard Terms and Conditions of Purchase is available at:
http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are
virus-free, we cannot guarantee this or accept any responsibility,
and it is the responsibility of recipients to carry out their own virus checks.
______________________________________________________________________
Other related posts:
