Oracle tablespaces in sqlplus
Posted on 12. Feb, 2009 by lohi
in oracle, sqlplus
I had the fortune to work as Oracle DBA for a while in a place where we had no administrative tools at all, so we had to do with good ol' sqlplus.
Here are two scripts, the first to check size and usage of all tablespaces and the other is for checking data files sizes and names.
| Attachment | Size |
|---|---|
| free_all.sql | 1.03 KB |
| chk.sql | 503 bytes |
Comments
Sounds like a pain to do that monitoring on alot of servers without administrative tools.
Thankfully scripts are the solution ;-)
Nice work. Really appreciated.