no, it's normal, your temp tablespace is empty, then someones makes a big query which manipulates data, your TEMP tablespace will then have segments created until it is filled (100%), and then Oracle will manage unused segments (because of course all segments are not used simultaneously and some were used a while ago), and your tablespace should then stay 100% filled ... this is the normal behaviour of Oracle 8, do not panic ))