Home » RDBMS Server » Server Administration » "_corrupted_rollback_segments" and "_offline_rollback_segments"
"_corrupted_rollback_segments" and "_offline_rollback_segments" [message #574581] Sun, 13 January 2013 09:49 Go to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
Hi,all
i have the following questions:
"_corrupted_rollback_segments" and "_offline_rollback_segments" are work at undo segment , but can you u tell me that what's the difference between them ? when to use "_corrupted_rollback_segments" ? when to use "_offline_rollback_segments" ?

Thanks advance.
Lonion
Re: "_corrupted_rollback_segments" and "_offline_rollback_segments" [message #574582 is a reply to message #574581] Sun, 13 January 2013 09:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>when to use
use any such parameter ONLY when directed to do so by Oracle Support
Re: "_corrupted_rollback_segments" and "_offline_rollback_segments" [message #574583 is a reply to message #574582] Sun, 13 January 2013 10:11 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
BlackSwan,thank you for your reply.
Can u answer my question directly ? i look forward to understand their usage clearly ,not only the end solution .
Re: "_corrupted_rollback_segments" and "_offline_rollback_segments" [message #574584 is a reply to message #574583] Sun, 13 January 2013 10:16 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can u answer my question directly ?
I did answered directly & correctly.
unless & until you never have any other questions regarding documented Oracle functionality & features,
your time would be better spent learning them.


https://forums.oracle.com/forums/thread.jspa?messageID=10790137#10790137

[Updated on: Sun, 13 January 2013 10:35]

Report message to a moderator

Previous Topic: ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:kllslt
Next Topic: Preventing database shutdown by a trigger
Goto Forum:
  


Current Time: Thu Mar 28 17:15:18 CDT 2024