finding tablespace size in oracle if datafiles are autoextensibleor limited
Hi Guys,
it is may be simple but not getting through.. i am using below query to find in db that bytes used and bytes assigned at tablespace leve but not getting correct results.
i have tablesspaces whos size is intially 100mb for example and autoextensible on or limited or unlimited disk space but when i run below query it gives many 32768 values as maxbytes.. anything wrong with below query?? please correct me...
select tablespace_name, round( sum(bytes/(1023*1024) ))used_mb, round(sum( maxbytes/(1024*1024))) assigned_mb , autoextensible from dba_data_files group by tablespace_name,autoextensible
how to display correct values in all the sizes assigned in different scenarios??