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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

morguloCommented:
You can check tablespace space usage:
SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES
0
slightwv (䄆 Netminder) 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
awking00Information Technology SpecialistCommented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
awking00Information Technology SpecialistCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.