-
CONTROL_FILE_RECORD_KEEP_TIME and Performance
Secnario:
1. Very High Update Activity on the Database
2. High number of Log Switches are occuring
3. Saw "denied expansion of controlfile section" in Alert.Log
4. Saw that CONTROL_FILE_RECORD_KEEP_TIME = 7 Days
5. Changed it to 0
My question:
1. What exactly happens if control file records = 65535 and new log switches are occuring.
2. How does this affect performance.
I've tried to get answers from Metalink, but could not get the answers.
Any insights very helpful.
Thanks
Sridhar
Sridhar R Patnam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|