If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hi, Am getting confused trying to figure out if we need to add additional
datafiles to tablespaces PODDATA and PODINDEX even though it seems that
the Used bytes for a tablespace is no where near the Max_bytes setting.
When running script that prints out tablespace size statistics it shows the following:

As you may have determined, I am fairly new to using Oracle trying to support a application that
was developed by outside source but no longer supported by contractor.
How do I interpet the above results. Do I need to add additional datafiles?

could you post the query here that is showing the used and free space ? I think something is wrong in that query.

For total space you should look into dba_data_files and for free space look into dba_free_space and do the maths.

There are sample scripts available on this forum under "Oracle Scripts" on the left side.

Here is a sample from there --

select
a.TABLESPACE_NAME,
a.total,nvl(b.used,0) USED,
nvl((b.used/a.total)*100,0) PCT_USED
from
(select TABLESPACE_NAME,
sum(bytes)/(1024*1024) total
from sys.dba_data_files
group by TABLESPACE_NAME) a,
(select TABLESPACE_NAME,bytes/(1024*1024) used
from sys.SM$TS_USED) b
where a.TABLESPACE_NAME=b.TABLESPACE_NAME(+);