Home » RDBMS Server » Server Administration » Rollback segments offline/recreation.
Rollback segments offline/recreation. [message #55056] Mon, 30 December 2002 15:05 Go to next message
Tony
Messages: 190
Registered: June 2001
Senior Member
Hi,
I'm planning to remove my current rollback segments and recreate them with higher values. How do you know when is it safe to take the rollback segments offline and/or recreate them with higher values? In other words how do you know that other jobs are not using it?
Thanks
Re: Rollback segments offline/recreation. [message #55062 is a reply to message #55056] Tue, 31 December 2002 06:34 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
just try to take it offline.
If there is any active transaction, by default oracle does not allow you to take the concerned RBS offline.
Anyhow, that IS NOT RECOMENDED. try in a test machine.

----------------------------------------------------------------------

this query may help you
SQL> ed
Wrote file afiedt.buf

  1  select  r.name,
  2     l.sid,
  3     p.spid,
  4     nvl(p.username,'no transaction') username,
  5     p.terminal
  6  from    v$lock l, v$process p, v$rollname r
  7  where   l.sid = p.pid(+) and
  8     trunc(l.id1(+)/65536) = r.usn and
  9     l.type(+) = 'TX' and
 10     l.lmode(+) = 6
 11* order by r.name
SQL> /

NAME                                  SID SPID      USERNAME        TERMINAL
------------------------------ ---------- --------- --------------- ----------
PRODR1                                              no transaction
PRODR10                                             no transaction
PRODR11                                             no transaction
PRODR12                                             no transaction
PRODR2                                              no transaction
PRODR3                                              no transaction
PRODR4                                              no transaction
PRODR5                                              no transaction
PRODR6                                              no transaction
PRODR7                                              no transaction
PRODR8                                              no transaction
PRODR9                                              no transaction
SYSTEM                                              no transaction

13 rows selected.

Previous Topic: connection problem
Next Topic: 9i Server/Client Machine name change in Windows
Goto Forum:
  


Current Time: Sat Dec 28 06:17:07 CST 2024