-- view to monitor space usage by different occupants and procedure to move the feature to a different tablespace. SQL> COLUMN move_procedure FORMAT a35 SQL> COLUMN occupant_name FORMAT a30 SQL> SELECT occupant_name, move_procedure, space_usage_kbytes FROM v$sysaux_occupants; OCCUPANT_NAME MOVE_PROCEDURE SPACE_USAGE_KBYTES ------------------------------ ----------------------------------- ------------------ LOGMNR SYS.DBMS_LOGMNR_D.SET_TABLESPACE 6080 LOGSTDBY SYS.DBMS_LOGSTDBY.SET_TABLESPACE 896 STREAMS 512 ...