Oracle segments only appearing in a few datafiles that are part of the tablespace RBS
Posted on 2004-11-20
I have an Oracle rollback tablespace, it comprises of about 20 rollback segments which are online, we have created them accordingly after examining the application that it runs under and its transaction needs.
Now this is the problem, if I fire this statement in PL/SQL:
SQL> SELECT owner, s.status, segment_name, f.file_name, f.bytes/1024/1024 "Size
3 FROM dba_rollback_segs s, dba_data_files f
4 WHERE s.file_id = f.file_id;
I get a dispersement of rollback segments across only 4 of the ten files that are defined for the RBS tablespace. In other words, why isnt ORacle dispersing the segments across more of the files available? To make the situation a bit more interesting, there is a file within the tablespace that does not appear in the above query that is nearly full? How can this be? The RBS tablespace is only used for rollback segments and nothing else.