Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Oracle  excessive generation of archive redo

Posted on 2008-11-10
Medium Priority
Last Modified: 2012-05-05
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 ?)
Question by:tatumino

Expert Comment

ID: 22926981
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
LVL 11

Accepted Solution

mohammadzahid earned 1000 total points
ID: 22927014
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?
LVL 15

Assisted Solution

by:Devinder Singh Virdi
Devinder Singh Virdi earned 1000 total points
ID: 22927051
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
LVL 48

Expert Comment

ID: 22931290
Often if you forget after warm (online) backup to put the tablespace in normal mode
the log file is very big.
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 22932177
Very true of Schwertner comment, use
select * from v$backup
to see if any tablespace is in hot backup mode.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question