Why don’t I see any jobs for Space Manager?

Check the following:

• You must have SELECT access on the Space Manager tables and on DBA_TABLESPACES
• TOAD schema must have the privileges to create and alter jobs, create and drop its own tables and procedures, and must have SELECT access on:
  • DBA_TABLESPACES
  • DBA_DATA_FILES
  • DBA_FREE_SPACE
  • V_$FILESTAT
• In addition, the init.ora file must have

  JOB_QUEUE_PROCESSES = 1

  or more as TOAD currently uses the built in Oracle job processes to schedule the data collection. So the user must have sufficient privs to schedule a job as well.

Also, remember that Space Manager cannot collect stats more than once a day, regardless of the formula specified in the setup.