Re: Rollback segment problem

From: Dennis E. Marquis <marquisd_at_bms.com>
Date: 1998/01/13
Message-ID: <34BBA9CF.BB4041EF@bms.com>#1/1

Supian,

Were you sure that no other Oracle users were running transactions at the time. RBS space is shared and it would be possible for more then one process to latch onto a RBS and in affect make less of it available to the other processes which may be writting to that same RBS. Were these two processes the only ones running at the time.

This query will show all sessions that are using RBS.

select s.sid sid,

  s.serial#,
  s.username,
  s.osuser, s.machine, s.status,
  r.name RB_SEG,
  s.program

  from v$session s, v$transaction t, v$rollname r   where s.taddr=t.addr
  and t.xidusn = r.usn

Dennis

Supian Zainuddin wrote:
>
> Our team is having problem with rollback segment.
>
> The scenario is as follows;
>
> We have 2 servers allocated for the project i.e. development and system
> server. Both with Oracle 7.1.3 installed and an application kit ( same
> on both servers ).
>
> Upon executing the application ( both sides ), a batch job is launched
> with the same user name ( having the same authoristaion and allocated
> parameters ) targetting on the specific server.
>
> The system server managed to complete but the development gave an error
> of rollback segment too small.
>
> Both DB on both servers were allocated the same rollback segment size,
> therefore in theory this should not have happened.
>
> The only difference that we could detect is that the tablespace sizes
> are slightly different, will this have an impact on the rolback segment
> ?
>
> I appreciate any tips from anyone who have had the same problem, or
> whoever that knows where the problem might be, or any tip whatsoever.
>
> Does anybody have any real documentation on rollback segment that you
> could forward that might help.
>
> Thank you to all.
Received on Tue Jan 13 1998 - 00:00:00 CST