Question:

>Oracle 8i for RedHat Linux 6.0
>
>I have a rollback segment tablespace whose name is 'RBS'. But when I
>log on as 'sys' user in either 'svrmgrl' or 'sqlplus', and
>issue 'select distinct tablespace_name from dba_free_space;' or 'select
>tablespace_name from dba_free_space;'. There's no 'RBS' tablespace name
>at all! Why this happen?
>
>'cuase right now I cannot get the free space available info of RBS
>tablespace based on 'dba_free_space'.
>
>I just want to know why 'RBS' disappear from 'tablespace_name' column
>in 'dba_free_space'.
>
>BTW, 'RBS' itself works fine, and I also include all rollback segments
>in init file.
>

Answer 1:

If there is no free space within the tablespace, then
dba_free_space won't return a row. The same is true for the
dba_extents view. I discovered this for myself awhile back
when I tried to write a query that joined those two views.
Basically, I encountered the same behavior as you just did.

Just because there is no free space in the tablespace
doesn't mean that there isn't available space in the
rollback segments. It's just that all your tablespace has
been assigned to your rollback segs.

Jonathan

_____________________________________________________
[email protected]
http://gennick.com
Brighten the Corner Where You Are

Answer 2:

Rollback tablespace is always full, becouse all available space are
allocated to users.
You should look in dba_segments or dba_rollback_segs to get some
informations about ..