Hi ,
Any script to find how much space is occupied by each user from UNDO tablespace in Orcale 9.i at a particular time ?
Hi ,
Any script to find how much space is occupied by each user from UNDO tablespace in Orcale 9.i at a particular time ?
select sum(used_ublk) "number of blocks used for undo"
from v$transaction;
Multiply the number with ur block size.