Blogs | Toad

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

Post author:Written By |
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.

Tags: ,