Oracle excessive generation of archive redo

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 ?)
tatuminoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

grzessioCommented:
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
0
mohammadzahidCommented:
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?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Devinder Singh VirdiLead Oracle DBA TeamCommented:
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
0
schwertnerCommented:
Often if you forget after warm (online) backup to put the tablespace in normal mode
the log file is very big.
0
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Very true of Schwertner comment, use
select * from v$backup
to see if any tablespace is in hot backup mode.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.