Database Space Usage Report
- The script generates a report of tablesapces, data files, roll back segments, control files, log files, objects (user wise, valid and invalid)
pop
(Added: 9-Apr-2000 Hits: 10242 Rating: 4.77 Votes: 13) Rate It
DB Growth over time
- A script to track the space utilization of your database over time
(Added: 8-May-2000 Hits: 9122 Rating: 2.93 Votes: 13) Rate It
Free space report by tablespace
- This PL/SQL script reports the %space left on each tablespace
(Added: 1-Sep-1999 Hits: 6884 Rating: 4.67 Votes: 6) Rate It
Freespace in Tablespace
- Free Space left in the tablespaces of the database
(Added: 24-Aug-1999 Hits: 6091 Rating: 1.00 Votes: 1) Rate It
If any tablespace has less then 5% free then a page message is sent to the DBA cell phone. If any tablespace has 15% free but above 5% then only send an email.
The procedure relies upon SYS.MAIL_FILES proc which is well know proc on the DBA Internet web sites, but which we use here. ( I have included it below too.)
I realize any of Oracle's internal mailing procedures could of worked, but we have been using this we no issues for a long time (since our 8i days).
The reason I did this is so my other monitor scripts that use to run on Sun UNIX are now less OS "dependant" allowing to port to Linux if or when we want and to utilize the DBMS_JOBS inside of Oracle so to move away from the old crontab UNIX jobs.
Currently, all the below scripts I have been tested using 9i release 2 (9204) but should easily port to other versions of Oracle (8i, 9ir1, 10g).
(Added: 28-Oct-2004 Hits: 4038 Rating: 9.50 Votes: 2) Rate It
Table usage report
- The script tells you how often specific tables are loaded into memory and the number of times those tables have been executed. The statistics are based on the last start of the instance. Run this script after the instance has been running under a normal daily load.
(Added: 23-Aug-1999 Hits: 6314 Rating: 4.50 Votes: 4) Rate It
