9

How can I check which database objects are using certain tablespace in Oracle DB? Any query or somehow through SQL Developer GUI?

1 Answer 1

11

I'm using the following SQL quite often:

SELECT * FROM dba_segments WHERE TABLESPACE_NAME='USERS' ORDER BY bytes DESC;

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:

SELECT * FROM v$tempseg_usage;
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.