How can I check which database objects are using certain tablespace in Oracle DB? Any query or somehow through SQL Developer GUI?
How to check which database objects are using certain tablespace in Oracle DB
oracle
Related Question
- Oracle – Listing Objects Using Another Object
- Oracle Database Migration using Oracle SQL Developer
- Oracle – How to Copy a Tablespace to Another Database Without Using Data Pump in Oracle 11G
- Oracle Database – How to Find Installation Directory Using SQL
- Oracle Tablespace not using 100% of available space
Best Answer
I'm using the following SQL quite often:
It will find all the objects which consume some space in given tablespace and sorts the output by used space.
TEMP objects are always related to user session. So you need to query another view: