Re: Rollback segment problem

Hi .
I don't think that is the problem ...
If Supian is getting an ORA 01555 . The available space on the rollback segment tablespace is not the problem.

The error problem should be somewhat like "can not allocate next extent of size xxxx on tablespace yyyy" if that is the problem .

ORA 01555 error is a common error for Oracle databases . In fact we had some discussion and a thread going around last week . And if you are going to check the newsgroup archive this problem has surfaced many many times..

I just have one question before I can repost a possible solution .
Is it an ORA 01555 error or is it another one ? , b'cause what bothers me is you had the problem on a development machine , when this is more likely to occur in a production machine where you have constant updates, insert, deletes while a long querry runs ...

Ciao

Mary Travis wrote:
>
> Could be that the rollback segment in test couldn't grow because other
> rollback segments in the same tablespace were using up the available
> space. Do you have the optimal parameter set on the rollback segment
> storage to force them th shrink periodically?
>
> Just a thought.
> Mary Travis
> DBA
> EDS
>
> Supian Zainuddin <msz1_at_hotmail.com> 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.
>
> Mary Travis
> BellSouth Telecommunications
> email: Mary.B.Travis_at_bridge.bellsouth.com

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================