| Sudden increase in archive log size [message #448962] |
Fri, 26 March 2010 00:47  |
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
|
Senior Member |
|
|
Dear ALL,
We had a database (DB A)that is having version 9.2.0.6.0.This DB is having multiple tables and volume of 6 million in individual tables.
Another database is also 9.2.0.6.0 (DB B), this DB has Mviews pointing to DB A. Mviews are refreshed in every 15 mins, with fast refresh option in 90% cases and remaining having complete refresh.
Last weekend we have migrated DB 2 to version 10.2.0.4.0 - 64bi and on another server.
After version upgrade and DB migration complete refresh was done once for all mviews.
Now DB A is generating huge amount of archive log and also it's UNDO space is getting fully consumed causing performance issue and DB hang.
Can you please help in suggesting what has gone wrong and what we can do to improve response of DB A and also to reduce size of Archive log ?
Thanks in advance.
Regards,
Rajat
|
|
|
|
|
|
| Re: Sudden increase in archive log size [message #448998 is a reply to message #448975] |
Fri, 26 March 2010 03:53  |
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
|
Senior Member |
|
|
Dear Michel,
Thanks a lot for your response and directions.
If we start trace then is there any possibilities of side effects on DB ?
Also, will you help in naming log files that we need to consider and analyze ?
I am checking how to use logminer.
Thanks again for help.
Regards,
Rajat
|
|
|
|
| Re: Sudden increase in archive log size [message #449003 is a reply to message #448998] |
Fri, 26 March 2010 04:11 |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:If we start trace then is there any possibilities of side effects on DB ?
I didn't mention any trace, just mining your current logs, nothing to change in your current processes.
Quote:Also, will you help in naming log files that we need to consider and analyze ?
All that seem weird to you. Start with one and if you do not find the problem then other ones.
Database Utilities
Chapter 17 Using LogMiner to Analyze Redo Log Files
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
