|
I have recently found that one temporary rollback
segment in system tablespace is having more then 600 extnets . It looks like
previous dba created this rollback segment at the time of db creation and forgot
to take it offline .
Now how do I find it this rollback segment is being
used actively . I see values in gets , writes from v$rollstat view
.
What step should I take to drop this rollback
segment . What implication might have if I take this offline ? I want to relase
the space taken by this rollback segment ( >600 extents ..thats big ) , so
just taking offline wont do this.
Are there any views accessible from system( no
sys) account which can tell me which trasaction is using which rollback
segment .
thanks
-ak
|
- Rollback segment sinardyxing
- RE: Rollback segment Mark Kirk
- Re: Rollback segment Tim Sawmiller
- Re: Rollback segment Dave Weber
- RE: rollback segment AK
- RE: rollback segment DENNIS WILLIAMS
- Re: rollback segment Daniel W. Fink
- Re: rollback segment Darrell Landrum
