ERPstuff - Oracle EBS Community

I have a Problem of Archiving.

My Database(9i) is Generating Frequent Archives as the same size of RedoLog File (100MB).
I want to Know that What is reason behind it?

Some Time I found it in Between 10:00 AM - 11:00 AM & Some Time in 04:00 PM - 06:00 PM Timings.

In other Timings, its Normal.

I have Checked out many things but can't find the reason.

I have discussed this metter with my friends but they are suggesting about LOG MINER.

is there any other way to find out the reason?

I want to define one more thing that we have a practice of creating No-Logging Tables for Reporting Purpose.

It might be possible that No-Logging Clause was missed when table was created.

but how can I find out that table also?

Thanks in Advance,

Muhammad Waseem Haroon

waseemharoon@gmail.com
mwaseem_haroon@yahoo.com
ocp_waseem@hotmail.com

1- To check logging status of tables,
select table_name, logging from user_tables where logging = 'YES'

2- Check if any process is scheduled?
3- Check if materialized views are not updated at that time?

Thanks