Jump to content
ks.sivakumar

Archive log generation more than usual

Recommended Posts

Hi Team,

In our production Database archive log is generating more than usual. since earlier days archive log generation was very less compared to now a days 

Also by using queries can able to identify how many archive logs are generated during particular intervals of time.

But Need to know which particular process generating those and also need to know Is there any setup can be done in oracle so that

generation of archive log sizes can be reduced ??? ...

could you guys help me for the above my issues. 

 

Siva.

 

 

 

 

Share this post


Link to post
Share on other sites

Hi Sova, and welcome to the forum!

Redo usage is directly tied to DML volume.

it’s not uncommon for a growing database to consume more redo logs!

Please read:

http://www.dba-oracle.com/t_redo_amount_transaction.htm

As for finding the programs that are issuing the DML, that is tricky.

These queries show the tables that are experiencing high DML (and high redo😞

http://www.dba-oracle.com/t_display_high_dml_activity_tables.htm

These queries against v$transaction are very helpful:

http://www.dba-oracle.com/t_find_session_generating_high_redo.htm

Sometimes a AWR report might show high DML statements.

Good luck!

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×