Monitoring Scripts

This section is devoted to all the scripts which makes my job as a DBA a lot easier.
I have categorize the scripts into 2 sections

1. Database Scripts
2. Weblogic Scripts

I will update this list every once in a while so please check it out and enjoy the collection
Please share this post with everyone:

Database Scripts:

1. Script to Delete RMAN backupsets older than a specified number of days
2. Script to Display database SGA statistics
3. Script to shows active transactions
4. Script to display database locks and latches (with tables names, etc)
5. Script to release DBMS_LOCK locks on database
6. Script to summery of all datafiles and archlogs backed up over the last 24-hours
7. Script to list the Database users with deadly system privileges assigned to them
8. Script to show Used/free space in Meg by tablespace name
9. Script to shows current size, used & freespace within the datafiles.

Weblogic Scripts:

1. WLST Script to list all deployed composites
2. WLST Script to start up and Shutdown Weblogic Servers
3. WLST Script to redirect Weblogic Application Status to .CSV file