Tablespace

The following are statements and queries I use working with tablespaces in Oracle. Query Tablespace Usage ⚠️ Please be aware of the following: If this query runs really slow, it may indicate you need to empty your recycle bin You should not run this query frequently on large databases as it’s not a lightweight query 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 set tab off set linesize 200 set pagesize 100 select files.