I know this is more of an Oracle question, but figured I'd ask here as it may be something in the app. My undo tablespace keeps growing and I keep having to add datafiles. It is now up to 50GB. I am fairly new to Oracle, but from what I understand, the undo tablespace needs to be large on databases that have very large transactions, which I didn't think UPTIME had. I am running 11G, so I think there is some builtin management of undo size. Just wanted to ask here for anyone running on Oracle. What is the size of your undo Tablespaces? Any settings recommendations?
Thanks,
Brad