Database Administration (MOSC)

MOSC Banner

Meaning of 'bytes' on dba_data_files - tablespace appears full but isn't

edited Mar 18, 2015 4:20AM in Database Administration (MOSC) 6 commentsAnswered ✓

Hi all, I'm feeling slightly confused here:

I ran the following query on hearing that the customer was having trouble with VMS data:

select tablespace_name, file_name, bytes/(1024*1024) Mb, maxbytes/(1024*1024) "Max Mb", user_bytes/(1024*1024) "User Mb" from dba_data_files
where tablespace_name like '%VMS%';

VMS_INDEX \ORACLE\PRODUCT\10.2.0\ORADATA\CUTLAS2\DBF\VMS_INDEX1.DBF 1335 32767.984375 1334.9375
VMS_TABLE \ORACLE\PRODUCT\10.2.0\ORADATA\CUTLAS2\DBF\VMS_TABLE1.DBF 2500 2500 2499.9375

This made me think the VMS_TABLE tablespace was full. So I deleted about 60% of all the VMS data, then ran the following:

alter table vms_.... enable row movement;
alter table vms_.... shrink space

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center