About TableSpace.

[PepperCrab]

我有一个TABLESPACE ,大约1个G , 从OEM中发现大约500M已满,但是我不知道为什么会这样,应为没有OBJECT建立在它之上.

[black_snail]

At first , you need to verify what you say by using
select owner, segment_name, sum(bytes), sum(blocks) from dba_Segments where tablespace_name = 'yourtabelspace' group by owner, segment_name;

if there is something , it means your tablespace actually contains objects .

I guess what troubles you is tempary tablespace or rollback tablespace , usually they will grow under some algorithm by oracle , there is no permanent objects inside it .

[black_snail]

for temporary tablespace , if the sorting required and over the size of sort_area_size , the space will be used to perform the sorting .
for rollback tablespace , a cycling algorithm is implemented .

But I think Oracle Reference has the best answer anyway

[yuxuan]

你建立的表空间大小是1G，已使用500M，满了，应该不会的

是什么表空间，数据表空间？回滚表空间？临时表空间？

[supershb]

你的TableSpace有1G，但你没有把它空间全部赋给你的instance.
改一下就OK了。