increase of undo data file size doubt
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: increase of undo data file size doubt

  1. #1
    Join Date
    Jul 2006
    Posts
    96

    increase of undo data file size doubt

    I am observing daily the sizes of the data files.
    undo datafile size was still 500 mb till yesterday. This is
    initial size which i have give. suddenly it increased up to 1.4 GB within one day. how does it happen suddenly.
    I did not find any bulk updations or deletions in tables.
    when does a datafile or undo datafile size will be increased.

    thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    when more people need undo, it will increase

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    If undo_retention param is increased, the filesize will likely increase. It will not shrink on it's own if you reduce the parameter. Switch to a new undo tablespace and remove the old one (after the transactions are done .. which may take some finescing)

    If the number of changed blocks in transactions increase, the filesize will increase. It's all about how much data to hold to satisfy your undo_retention timespan.

    I didn't know about the number of connections effecting this, but It seems plausable in my mind.

    Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    By the way, 900mb is cheap to avoid the dreaded ora-1555 crapshot too old...
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width