Re: Rollback segment problem

In article <34B57856.2825F077_at_hotmail.com>, 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.

Actually, there is plenty that could be different with the same allocation. Get ahold of any of the books on Oracle tuning, you could have some fragmentation issues. Also, simply having different other things running, or having previously run, could be taking up space.

Try select * from dba_rollback_segs to be sure they are really defined the same, too.

>
>The only difference that we could detect is that the tablespace sizes
>are slightly different, will this have an impact on the rolback segment
>?

It could, but other things are more likely.

>
>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.
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry_at_eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the _at_#%*& DBA!