Community

Script to find the tablespaces within certain extents

By Prince Kumar – The following script finds the tablespaces that can extent to a maximum of "ExtLimit". In this case, I didn’t want any files to be more than 2 GB so I set MAXSIZE to 2 GB. Also, I did not include temp files in this script.

Read More - Register for Free Membership

Tags: