Tool Scripts

SCRIPTS THAT WORK AS A TOOL

 
Tool

Database Up/Down time Monitor

Purpose Utility to capture the Oracle database up time statistics. The database shutdown and startup information are extracted from the alert log files and saved in an oracle table. The scripts provided here will read the alert log file and load information to an Oracle table. You may have many different reports generated using the information from the Oracle table.
View Script and description
 
Tool

Database Performance Monitor

Purpose Utility to monitor your database health for a period of time. There are various parameters in the database which could be monitored and improved. Here I take a simple example of monitoring the SGA usage. You may add more monitoring SQLs to these scripts and capture the data.
View Script and description
 

 

Search BijooS.com Exact Match Search      
Home Oracle DBA TKMCE Alumni H1B Info Guestbook

Biju Thomas is Oracle7.3 OCP, Oracle8 OCP, 
Oracle8i OCP and Oracle9i OCA/OCP Certified DBA

Questions/Comments? Write to webmaster@bijoos.com. The scripts, tips and articles appearing on BijooS.com cannot be reproduced elsewhere without the prior permission from the webmaster.