Oracle  excessive generation of archive redo

Posted on 2008-11-10
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
    LVL 7

    Expert Comment

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

    take a look into this link:
    LVL 11

    Accepted Solution

    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
    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 47

    Expert Comment

    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
    Very true of Schwertner comment, use
    select * from v$backup
    to see if any tablespace is in hot backup mode.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now