Script to check the Tablespace sizes

What does this script do ?
  1. Check for the DMS(Auto Resize Enabled – No) Tablespaces ( As there is no point in checking the SMS and DMS with Auto Resize Enabled – Yes Tablespaces)
  2. Query returns the following columns (Tablespace Name , Free Pages , Container path )
  3. If less than 1000 pages throws warning message
Here’s the script



No comments:

Post a Comment