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:
  • In addition, the init.ora file must have


    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.

About the Author

Steve Hilker

Steve Hilker was a Product Manager for Quest Software. Steve has over 35 years technical experience spanning application development, system administration, database management and various management positions at several software companies. Steve was the founder of RevealNet, best known for its desktop knowledge bases and unique database tools such as PL/Formatter. RevealNet was acquired by Quest Software in 2001. He's had the pleasure of being the product manager for many of Quest's database tools.

Start the discussion at