Oracle  excessive generation of archive redo

tatumino
tatumino used Ask the Experts™
on
I have a scriipt which creates tables and indcies at startup, basicallu all DDL's. There are many archive redo generated. I am using Oracle 10g. What could be the reason ?
Thanks very much.
(Also how do I know what is going on, that is creating so much redo without any DML ?)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
you should use logminer to check what statements generate redo logs.

take a look into this link: http://youngcow.net/doc/oracle10g/server.102/b14215/logminer.htm
Depends on many things such as:

1. Index creation if not using NOLOGGING will cause redo logs write.
2. Create table
3. Update, Insert, Delete

Are you running database in ARCHIVE LOG MODE?
Devinder Singh VirdiLead Oracle DBA Team
Commented:
Everything you are doing goes to Redo log files. Generation of redo depends on what are you doing. ie. Suppose you are deleting all rows of table generates maximum redo generation, while truncate of table does very less. Creation of index, tables are again generate redo. If you really want to know what is written in your log files, you can use logminer. just configure it and see what it contain. Probabily it helps you alot.
Good Luck
Top Expert 2008

Commented:
Often if you forget after warm (online) backup to put the tablespace in normal mode
the log file is very big.
Devinder Singh VirdiLead Oracle DBA Team

Commented:
Very true of Schwertner comment, use
select * from v$backup
to see if any tablespace is in hot backup mode.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial