Thanks for the question, Krishna.
Asked: July 16, 2020 - 8:20 am UTC
Last updated: July 17, 2020 - 7:55 am UTC
Version: 12.1.2.0
Viewed 1000+ times
You Asked
Hi Team ,
we need to know is there any view to get a count of active rollback segment historically.
from dba_rollback_segs, we can get the current count details for the online and offline segments.
however, historically can we get it from any view.
I understand in 10g, there was a view called DBA_HIST_ROLLSTATS , but I don't see in 12c.(still that would have help ,don't know ?)
so request you to help us, to know the historical value of rollback segments.
Regards,
Krishna
and Chris said...
The undo tablespace has long replaced rollback segments.
You want to look in v$undostat and dba_hist_undostat now.
Is this answer out of date? If it is, please let us know via a Comment