OraFAQ Forum: Server Administration » question about rollback segments

Home » RDBMS Server » Server Administration » question about rollback segments

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

question about rollback segments [message #57606]

Wed, 25 June 2003 09:46

fengq
Messages: 38
Registered: October 2002

Member

Hi, why everytime I restart the database, all my rollback segments becomes offline??? I am able to place them online. my version is 8.1.7

thanks so much for helping

Report message to a moderator

Re: question about rollback segments [message #57608 is a reply to message #57606]

Wed, 25 June 2003 10:27

ctg
Messages: 146
Registered: July 2002

Senior Member

SELECT owner, segment_name FROM DBA_ROLLBACK_SEGS;
If the owner is SYS (meaning they are private), then simply put them in your init.ora file

ROLLBACK_SEGMENTS = (rbs1, rbs2,..,rbsn) -- this parameter brings these PRIVATE rollback segments online when the db opens.

Report message to a moderator

Previous Topic:	Scripts to determine parent/child relationship
Next Topic:	Upgrade using patch set 2376472 to 8.1.7.4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:23:12 CDT 2024