OraFAQ Forum: Server Administration » "_corrupted_rollback_segments" and "_offline_rollback

Home » RDBMS Server » Server Administration » "_corrupted_rollback_segments" and "_offline_rollback_segments"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"_corrupted_rollback_segments" and "_offline_rollback_segments" [message #574581]

Sun, 13 January 2013 09:49

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

Report message to a moderator

Re: "_corrupted_rollback_segments" and "_offline_rollback_segments" [message #574582 is a reply to message #574581]

Sun, 13 January 2013 09:59

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

Report message to a moderator

Re: "_corrupted_rollback_segments" and "_offline_rollback_segments" [message #574583 is a reply to message #574582]

Sun, 13 January 2013 10:11

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 .

Report message to a moderator

Re: "_corrupted_rollback_segments" and "_offline_rollback_segments" [message #574584 is a reply to message #574583]

Sun, 13 January 2013 10:16

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 23:56:55 CST 2025