Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: undo tablespace keeps growing, why can't I reclaim space?
Hans I tried but couldn't follow all of your explanation.
If you have more than one commit, each commit causes the beginning of a new transaction.
Each new transaction can go to a different undo segment.
Do you have the same volume of data in test and production? Do you have the same indexes in place?
It seems unlikely that something that takes 2-3 gig in test will take 40 gig in production unless there are big differences in your environment that don't seeem clear to me yet. Received on Mon Aug 15 2005 - 08:46:50 CDT
![]() |
![]() |