Database Monitoring scripts
|
Useful scripts for monitoring and information gathering on space, user activites,
rollback segments, objects information etc,.
Tablespace usage information
Next extent failure information
Database file information
Space used by schema's
SGA size
Rollback segment's space ifnormation
Sessions details
What SQL's are running against database
Any objects are locked?
User's details
user's roles
Profiles
Roles
Privileges to Roles
Audits
|
Backup and Recovery information
|
Does a datafile needs recovery
When Last hotbackup was done
Log files information