Add datafile to UNDOTBS

[ClaireHCM]

We have a production process that fills up UNDOTBS very frequently and that causes process to be aborted.

In emergency, I'd like to add more datafile for UNDO tablespace, would it drop/block/reject user transactions?

In stead of adding new data file, would it be better to just change existing data file to grow unlimited.

Thanks
Claire

 

[Thargy]

Yes,

especially if it's a system managed undo tablespace. Since this is a 10g forum, I reckon that's a safe bet. I would enable autoextend but limit it to say 10 gb more than you have at present, that way, if it grows enormously, you'll be made aware that something different is going on in the system.

I think this way because managing one of something is always easier than 2 or more. Also, if the thing is system managed, you have no work to do - always a bonus for a DBA.

Regards

T