Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Too much redo log files...

568333Jun 28 2007 — edited Jun 30 2007

Hi,

I have a very light application in Oracle 9.2.0.7 in Linux-32bits that is generating 400 logfiles a day. I can´t find why those logs are being generated!

The only thing relevant in that application is a big table that serves only for insert command (1000 per hour) for audit reasons. But this table was created with NOLOGGING option.

Redo Size: 4 groups of 40 Mb each.

The insert statement uses a sequence to generate a unique key. Is this sequence causing my big logfile generation?

Thanks,
Paulo.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 28 2007

Added on Jun 28 2007

#general-database-discussions

22 comments

3,173 views