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.
when more people need undo, it will increase
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.
By the way, 900mb is cheap to avoid the dreaded ora-1555 crapshot too old...
Click Here to Expand Forum to Full Width