Mihael ,expired according to undo_retention
I used the first query which gives 1 usedblk and 1 usedrec for 4 users .
the next query shows the sessions using undo ... but if i total the value it comes to approx 4GB ... but my undo is 8GB
so where is the rest 3.5 GB being held ... can you please help here or should oracle take care on its own .. i am on 10.2.0.3 version.
As of now this is the output
TABLESPACE_NAME STATUS GB
UNDO_TBS1 UNEXPIRED 3.64129638671875
UNDO_TBS1 EXPIRED 3.46905517578125
UNDO_TBS1 ACTIVE 0.05078125
can you please let me know what does expired mean here ?
982868 wrote:yes, and oracle also can use unexpired blocks if no expired found and if undo retention is not guaranty
so will oracle reuse the expired blocks if it gets full ?