Re: Rollback Segment Question

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 11 Apr 2005 12:48:05 -0700
Message-ID: <1113248663.483852@yasure>

amerar_at_iwc.net wrote:

> Frank van Bortel wrote:
> 

>>amerar_at_iwc.net wrote:
>>
>>>Hey All,
>>>
>>>Take a look at the results of this query. Why is it that rollback
>>>segment 23 (RBS23) seems to have all the extends?
>>
>>The usual reason... a long running transaction.
>>
>>And... time to upgrade.
>>Now, how do I know that?
>>--
>>Regards,
>>Frank van Bortel

> 
> 
> If I can ever convince this palce to upgrade to 9i to 10g, it would be
> a miracle.  They are so damn scared of every little change.....

Then give them something else to be scared of: Sarbanes-Oxley.

Not having FGA (fine grained auditing) can put people in jail. They can either invest a large amount of money writing it themselves or upgrade.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Apr 11 2005 - 14:48:05 CDT