How to check what is exactly consuming space in your tablespace

A focused SQL query that goes from "this tablespace is full" to "here is the exact objects that are responsible".

How to check what is exactly consuming space in your tablespace
Photo by Arum Visuals / Unsplash

Your tablespace monitor just fired. The usage is at 95% and growing. You know which tablespace is the problem, but... Do you know what is inside it and which objects are responsible? That is the question this post answers.