High Availbility

OS & Virtualization

Thursday, February 26, 2009

SimpleCheck - Oracle diag checking utilties

This program provide a convenient way to check for the status of Oracle database. You can easily find out which datafiles is OFFLINE, which datafiles need recoveries, what many invalid objects in the database, etc. You do not need to remember complex SQL statements to retrieve those information.

This program like all our previous program, it does not requires to be install. If you are running on windows 2003 server, you have all the necessary DDL to run it.

Features
  • Show Hard disk space
  • Show Oracle status "mount, open", version
  • SHow the location of alert.log, archive log
  • Show datafiles which needs recoveries, offline
  • Show how many objects are invalid
  • Show the amount of tablespace free space.
Updates
  • Display a list of tables, last analyzed date, number of rows in a schema
  • Display what privileges a schema owner has
Show a current status of database, Hard disk space, alert_log location.
 
List the tablespace space

 

 

List schema information such as tables, privileges, last analyzed date, etc

Download
Get it from CNET Download.com!