Home » RDBMS Server » Server Administration » Sudden increase in archive log size (one DB on 9.2.0.6.0 and another on 10.2.0.4.0 - 64bi)
Sudden increase in archive log size [message #448962] Fri, 26 March 2010 00:47 Go to next message
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 #448975 is a reply to message #448962] Fri, 26 March 2010 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Analyze the logs to know what's inside them.
See LogMiner.

Regards
Michel
Re: Sudden increase in archive log size [message #448998 is a reply to message #448975] Fri, 26 March 2010 03:53 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: oracle in not available
Next Topic: Database Configuration Assistant doesn't work Oracle 8.0.5
Goto Forum:
  


Current Time: Sat Dec 03 01:17:03 CST 2016

Total time taken to generate the page: 0.14626 seconds