space tablespace

Is there any query helps to find for a tablespace to find the space it is taken and the remaining space..
nobleitAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
This is more complicated that you might thing.  

For example:  Oracle can allocate a lot of space to an object.  This space is available for that object to use but nothing else.  It will show up as 'used' but that does not mean you are in danger or running out of space.

In addition to the DBA_DATA_FILES view above, there is a DBA_FREE_SPACE view and a DBA_EXTENTS view that are also important in this calculation.
0
 
morguloCommented:
You can check tablespace space usage:
SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES
0
 
awking00Commented:
I use the attached to check out tablespace size and usage. I wish I could remember where I got it to give proper credit.
tablespace-Free.txt
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
slightwv (䄆 Netminder) Commented:
>> I wish I could remember where I got it

Maybe:  http://www.icgteam.com/Scripts/GeneralSQLScripts/all_ts8.txt ?
0
 
slightwv (䄆 Netminder) Commented:
That script should work but you need to understand what it is telling you.

Just remember my warning:  I can have a table show it is using 100 Exa-Bytes and have NO ROWS.  It's all about allocated extents...
0
 
awking00Commented:
Well, that doesn't look exactly the same as I recall but, given aliases used, etc., I suspect I got it from someone who got it from there :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.