Dear Jmodic, 10th May 2001 16:34 hrs chennai

As you have said fine i queried the v$parameter it shows as follows.

NAME VALUE
---------------------------------------------------------------- ------
transactions 75
transactions_per_rollback_segment 5

So i should have 15 RBS ? but my query reads as follows

SQL> select * from v$rollname;

USN NAME
---------- ---------------------
0 SYSTEM
1 RBS0
2 RBS1
3 RBS2
4 RBS3
5 RBS4
6 RBS5
7 RBS6

Note :In My init.ora RBS related parameters has been disabled.

# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )

# If using public rollback segments, define how many
# rollback segments each instance will pick up, using the formula
# # of rollback segments = transactions / transactions_per_rollback_segment
# In this example each instance will grab 40/5 = 8
# transactions = 40
# transactions_per_rollback_segment = 5

Cheers

Padmam